Excel Geniuses, I'm in need of some inspiration here.
I am attaching a file that has 3 tabs currently.
I have '2019query' which isn't live in this file. in addition to the query table, I have added several columns to help create a calendar of summer events at different campus locations.
The locations tab has the table of locations plus a countifs for the total number of programs that a campus has. Next to that table I have a series of columns with indexmatch used to pull the specific campuses that have 1 program, 2 programs, etc.
The tab called '1' is my actual trouble right now.
You will see a drop down menu using validation for the campuses with only 1 program, an array pulling that data from the query, and finally a calendar.
So I'm having trouble with the array and the formulas below the array.
My array is supposed to pull in the matching records based on the drop down selection. Specifically, it is supposed to pull the data in columns BX:EB.
Under the array, I have a concatenate formula in row 18. It is supposed to check to see if there is anything in the first row for that day and add it with a CHAR(10) to begin a new row for the next item - or skip it all the way through the array.
Row 19 is supposed to sum the total number of students expected for that day based on if there is a program listed for that day.
Finally, my calendar is just a series of basic if statements.
In my real file, with the working query, the array worked just fine, so I'm not sure why that isn't working in the clean version I uploaded. but the sum in row 19 is not seeing an empty array cell value as really being empty. so it sums the students even when there isn't a program.
BTW - if you have a sweeter, better, cooler way to create this whole thing from my query...I'm ALL EARS!!!! This is a series of headaches to make something that I wich could just be easy.
Bookmarks