Returning distinct values from a column

[djfatboyfats]

Good afternoon,

I have a column that has some names in, the column can have some blanks in between and duplicates, i want to get the next value down in the list, ignoring the blanks and duplicates. I have managed to ignore the blanks using the formula below, but I cant get distinct values, could someone help me please?

Please Login or Register  to view this content.

Column A

Example 1
Example 2

Example 3
Example 1
Example 4
Example 2
Example 1

Required Result

Example 1
Example 2
Example 3
Example 4

Thanks in advance

DJ

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[Pepe Le Mokko]

Administrative note
Also , please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[AlKey]

Give this one a try:

Enter formula in cell B2 and copy down

You may need to use CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

v	A	B
1
2	Example 1	Example 1
3	Example 2	Example 2
4		Example 3
5	Example 3	Example 4
6	Example 1
7	Example 4
8	Example 2
9	Example 1

[djfatboyfats]

Excellent thank you.