uNIQUE AND SORT with filtered data

Hello all

If I apply a fitler to a column
Can I use unique sort to return data from another column based on the remaINING values only?

thanks

Please post a sample sheet showing EXACTLY what you want.

Hi Glenn

Please find a sample sheet attahced.

I have filtered column A by a value. But I want to be able to apply a unique sort on column B to return the unique values and sort it, in column column C - but ensure it returns all the values unaffected by me applying a filter in column A.

Thank you

Hi Fluff13,

Not really usable for me in my main (real) spreadsheet - is there something more generic/can you break down the logic for me to amend the numbers accordingly?

No sadly no luck.

I have this range and 150 values:

=LET(Data,Q222:Q7151,SORT(UNIQUE(FILTER(Data,SUBTOTAL(150,OFFSET(Q1,SEQUENCE(ROWS(Data)),1))))))

I`m getting a #VALUE error

Not 100% sure that I follow you, but:

=IFERROR(INDEX(UNIQUE(SORT(B2:B151)),SUBTOTAL(103,B$2:B2)),"")

copied down??

thank you both, but I think my complexity is all the value's do not display as some rows are hidden (due to the filter in the other column)?

No, I think the complexity is that you have not explained clearly what you want.

However, I want to amend my offering. With NO filters in place:

=IFERROR(INDEX(UNIQUE(SORT($B$2:$B$151)),SUBTOTAL(103,B$2:B2)),"")

copied down.

Now apply your filters.