Forum Discussion
How to get all the unique distinct value from a list in Excel
Hi there I had a group of list from column B to column D with different number of rows. How should I get all the unique distinct value such that once there is any letter appear in the list, it wi...
Or
=SORT(UNIQUE(VSTACK(FILTER(B2:B51,B2:B51<>""), FILTER(C2:C51, C2:C51<>""), FILTER(D2:D51, D2:D51<>""))))