I have a formula setup that basically references a table column (day in this case) and finds all the unique day values
=OFFSET(Table1[Day],0,0,COUNTA(Table1[Day])-2,1)
This works great, UNTIL I sort that table column "Day" and then all goes wrong (it only finds one day and repeats it). How do I go about fixing this and/or making the formula smart enough to get all the unique days regardless of the table sort order?
The Table is on sheet 1 and sheet 2 has the day place holders.
Thanks for any help with this
Bookmarks