Hi, Please can you help.
Hi, I have names in Column A1 to A9, some names repeated. I need a formula in A14 and down (A19) to look , at A1 to A9 and return only unique names. Only one name of each.
I can not use the menu's Data Filter option in this case. I need a formula to look at that range and return a name once of each person.
Thanks guys much appreciated.
A
1 John
2 peter
3 john
4 vaughan
5 gavin
6 paul
7 vaughan
8 george
9 gavin
10
11
12
13
14 John
15 Peter
16 Vaughan
17 Gavin
18 Paul
19 George
Hi, I have names in Column A1 to A9, some names repeated. I need a formula in A14 and down (A19) to look , at A1 to A9 and return only unique names. Only one name of each.
I can not use the menu's Data Filter option in this case. I need a formula to look at that range and return a name once of each person.
Thanks guys much appreciated.
A
1 John
2 peter
3 john
4 vaughan
5 gavin
6 paul
7 vaughan
8 george
9 gavin
10
11
12
13
14 John
15 Peter
16 Vaughan
17 Gavin
18 Paul
19 George