I am not entirely sue what you need, and there are probably several ways to
do this.
However, if your possible duplicates are in Column 1, and you want to see
only duplicates in column 2, the following formula works for me if you fill
it down so A1 becomes A2 in row 2 and A3 in row 4:
=IF(MATCH(A1,A:A,0)<>ROW(A1),A1,"")
The list must be sorted for this to work, because it is simply checking to
see if I finds the value in a row that is NOT the row it got it from.
Hope this helps.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC Is
there a formula that I can run to find duplicate cell values in a single
column. I would like the results to show in a different column. For example I
have a column of 4000 Alpa/numeric items. In the column are duplicate values.
I want to isolate them in there own column. Any way that I can do this?
Thank you.
This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
--
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:
[email protected]
