owen_1987
09-09-2011, 02:21 AM
Hi all,
I have column A(which has names in) and I have been trying to design something that will find duplicate names in column A. What I need is a searching function that starts at A1 and searches column A, then offsets to the cell below and then search for a duplicate of that name etc etc. If it finds a name that is duplicates highlight the cell in yellow
The problem is the names are variable so I can't use a countif.
Can anyone help me with this please?
I have column A(which has names in) and I have been trying to design something that will find duplicate names in column A. What I need is a searching function that starts at A1 and searches column A, then offsets to the cell below and then search for a duplicate of that name etc etc. If it finds a name that is duplicates highlight the cell in yellow
The problem is the names are variable so I can't use a countif.
Can anyone help me with this please?