With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, November 27, 2014
yogi_Stats Such As LessonsTaken LastLessonDate PaymentMade BalanceDue Etc For Lessons taken By A Specified Student
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.