Listing only unique values
Posted: Thu Oct 04, 2012 9:27 pm
I am trying to make a list of only the unique values form a long list of several values (text and numbers) for a summary. I tried to use the sumdistinct function, but that does not work with text values. How can I create such a summarized list? see example below
complete list:
car
bike
car
car
car
bike
bike
bike
The result I look for:
car
bike
greetings
Henk
complete list:
car
bike
car
car
car
bike
bike
bike
The result I look for:
car
bike
greetings
Henk