Forum Discussion
Display row of unique values based on data validation list?
I have 2 columns (Picture provided) Column A being the starting Week Of (Date of every monday). Column B being the dates of the 7 days that account for the Week of column. So 7 duplicated date values in column A, and Column B with 7 unique date values.
Within that I have a reference for data validation of all 'Week Of' Dates. The goal is to have a transposed (column by column) unique identifier that whenever I select a new Week Of Date from my list, it will display the 7 days from say Column F to Column L.
So far I've used the TRANSPOSE & UNIQUE functions to just get a foundation of what I want to create but am not sure how to utilize a VLOOKUP or IF statement to bring this formula together.
- nkal24Brass Contributor
Would first_cell_in_formula_display = data_validation_list+SEQUENCE(,7,0) work?