Excel Macro
-
I have an excel spreadsheet consisting of three columns Column A is an account number, B and C a numerical value in each. I would like to place a flag in column D if there are repeats of the same numbers eg duplicates in column A. I have been tying the following but it wont work. Does anyone have any ideas please? =IF(COUNTIF(Range1,A2)>1,"Duplicate","") In cell C1 is the title Range1. Cells A2 through C4000 are the named range Range 1 I have tried a couple of bits and pieces to do a very simple flag but cant seem to get them to work. The first was the one above, and another is this one: =SUM(IF(A1:A2000=A1,1,0)) The idea being if any of the cells from a1 to a2000 is a duplicate of a1 then it gets an integer in the column I write the formula to. I had hoped if I copied it to each cell then it would look through the whole list. Not so though as I just get a long list of 1's rather than 1's and 0's. If anyone does know of a way to id duplicates in this way I would be mst appreciative.