how to select distinct value from a column in excel automatically.

[hyugai]

Hi Everyone,

This is my first post. I'm not so good with excel macro or functions.

So i have one column with a list of name (Column A) and I want to get a distinct value of column A and produce Column B automatically. So that when I enter a value in column A, column B get updated automatically.

A B
----------------------------
1|Joe | Joe
2|Joe | John
3|John | Liz
4|John |
5|John |
6|Liz |
7|Liz |
8|Liz |


Please help
thank you in advance.

[mmmarks]

HI welcome to the board

Please Login or Register  to view this content.

paste above formula in C2. Note: Be sure C1 shoudl be empty and hit CTRL+SHIFT+ENTER NOT JUST Enter and drag down

[Ace_XL]

I'd go with pivot tables..See attached

[mmmarks]

Hi,

there is another simple way.

Go Data --> Adanced filter--> in List range, Select the range
then -->Click on Copy to another location -->copy to "select a cell where you want output
--> Check on Unique records Only--> then OK

Thanks
A

[oeldere]

This recorded macro will do that for you.

See the example.

Please Login or Register  to view this content.