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.
Bookmarks