Hi, I have the following sheet and I want to find and return all values for the duplicate item.
A B C
1 TOM 56 68
2 JOHN 12 84
3 TOM 55 22
4 PAUL 18 32
5 Fred 53 82
6 TOM 64 13
I want to type the name Tom into F1 and return the values 56,68 55,22 & 64,13 into G1,H1 G2,H2 & G3,H3
Thanks in advance.
Richard.
Bookmarks