I'm trying to do what is quite advanced spreadsheet work for me and I'm a bit out of my element. I've gotten this far on my own with a little research and perserverance, but I've hit a wall and need help.
I am trying to create a worksheet for a summer camp that will allow me to arrange campers by what activities they are in. It makes it easier if I can list out what they are in and then have it populate into the final sheet, but it needs to be a printable neat document, which means there can't be blanks where the formula came out not to be true for the activity.
The current formula I have is: =arrayformula(IFERROR(if('Dropdown Menu''s '!C33:C47="social group",INDEX('Dropdown Menu''s '!A33:A47),"")))
P1 - Array IFERROR IF INDEX Formula.JPG -- Image #1 is where my problem is, I want the data to move up and skip the blanks.
Datasheet.JPG
-- Image #2 is just where the information to run the formula is coming from.
Let me know if you have questions. I'll do my best to answer them.
Any advice is appreciated.
Thanks!
Bookmarks