Thursday, November 27, 2014

yogi_Stats Such As LessonsTaken LastLessonDate PaymentMade BalanceDue Etc For Lessons taken By A Specified Student

              Google Spreadsheet   Post  #1849
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-27-2014
post by  EricF^:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!mydiscussions/docs/PYBlXgCvnO4
How do I collect only the data from range where a condition is true of the cell next door?
Hello amazing and helpful people of the internet. I run a language school and I'm taking December to fix our accounting nightmare. Thanks to the friendly people of this forum, I'm now able to pull the last date of a student's lesson to see whether their remaining balance is still valid (rather than checking manually when we remember to do it). This will allow me to be a decent human being and dutifully warn them before it expires too!

Here's how it works: The name of the student corresponds to the tab with their financials. I use a MAX(ARRAYFORMULA(Indirect())) formula to get the job done. Very clean.

Now I want to take this a step further. Next to the date of each lesson is a standardized teacher code which tells me who their lesson was with. This is important to pay our teachers (at the end of each month, we see who they taught and tally it up). I want to be able to see the last date that a student learned with a specific teacher. Even if the workaround is tough, I want to avoid scripts at all costs. Scripts are useful, but also buggy and I can't afford to have a formula that I can't personally understand and fix.

How do I collect only the data from range where a condition is true of the cell next door?
---
Oops, sorry Yogi. I did just that and forgot to include the link in the last reply.
-----------------------------------------------------------------------------------------------------------------------------