I have a spreadsheet which keeps track of all staff, clients, and related data. In the 'Attendance' tab, there is a list of clients that are seperated by their appropriate ratio (e.g. 1:1, 2:1, 4:1). In addition, the clients' weekly schedule varies from one day to the next (e.g. M, T, W, R, F). I am attempting to build a subarray based on both the ratio (e.g. "4:1") and daily schedule (e.g. "R"). I have had success with using just the ratio, and just the schedule, but when I combine the two, it doesn't produce the desired results. Both the formula and array are listed below:
Formula:Please Login or Register to view this content.
Client Data.png
Note: The "R" that I was using today to check for Thursday will eventually be substituted with the following formula so that the list updates automatically each day.
Formula:Please Login or Register to view this content.
Thank you in advance for your assistance.
jbalan
Bookmarks