Forum Discussion

FatTummi's avatar
FatTummi
Copper Contributor
Aug 05, 2024

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.

  • nkal24's avatar
    nkal24
    Brass Contributor

    Would first_cell_in_formula_display = data_validation_list+SEQUENCE(,7,0) work?

Resources