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 will print out as from what you had seen in Column F? Since the list contains A-G, it will print the output from A to G. Thanks.
Or
=SORT(UNIQUE(VSTACK(FILTER(B2:B51,B2:B51<>""), FILTER(C2:C51, C2:C51<>""), FILTER(D2:D51, D2:D51<>""))))
For example (if you have Microsoft 365 or use Excel Online):
=SORT(UNIQUE(VSTACK(OFFSET(B2:B51, 0, 0, COUNTA(B2:B51)), OFFSET(C2:C51, 0, 0, COUNTA(C2:C51)), OFFSET(D2:D51, 0, 0, COUNTA(D2:D51)))))
