Nov 14, 2024
Creating Lists Based on Drop Down Answers in Sheets
Column A would be names, Column B would be ages of those names, Column C would drop down lists of different groups those names could be in.
Is there a way to then auto populate a separate list for each of those groups from Column C, that would include the data from Colum A and B. That separate list would either be on same sheet or a completely new sheet.
In short, trying to create a master roster/attendance sheet, that could then auto populate new rosters for the individual groups, and update those group rosters if the group is changed on the master roster.
Details
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies
For me or other forum contributors to help (if I'm not around), I suggest you share an editable COPY of your sheet. Use your sample sheet to demonstrate what you'd like the sheet to do! Here are some tips to help you get a great answer quickly... Product Experts TIPS FOR SHARING
***** IMPORTANT: Read the Tips post above, then check your sharing settings before posting - you want "Anyone with the link can Edit"
Please also have more sample data so we can better assist you.
Ben Liebrand
Nov 18, 2024
Hi, BigMacc14,
This is the typical formula and I have placed it in each of the groups. The formulas are in row 3
=QUERY($A$1:$C, "SELECT Col1,Col2 WHERE Col3 = '" & G1 & "' ORDER BY Col1 ", 1)
Please note that the formula outputs the header row as well in each case, so I first cleared range G3:N3 before inserting the formulas.
I also added the count formula in each group in row 2
=COUNTA(G4:G)
I hope this helps,
Ben Liebrand
Thanks for the insight,
This would be a sample of it:
https://docs.google.com/spreadsheets/d/14_i2MKXK6HHX1B8rtDFVvFftVxHlhLjwmUZYceMOn8g/edit?usp=sharing