Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to check for duplicates excluding blank cells across a range A3:I3
I've looked at Chip Pearson's site and tried adapting the formula there =IF(MAX(COUNTIF(INDIRECT("A2:A"&(MAX((A2:A500<"") *ROW(A2:A500)))),INDIRECT("A2:A"&(MAX((A2:A500<"" )*ROW(A2:A500))))))1,"Duplicates","No Duplicates") to =IF(MAX(COUNTIF(INDIRECT("A3:I"&(MAX((A3:I3<"")*C OLUMNS(A3:I3)))),INDIRECT("A3:I"&(MAX((A3:I3<"")* COLUMNS(A3:I3))))))1,"Duplicates","No Duplicates") as an array but it gives the answer Duplicates if any cell has a value, if they are all blank the answer is #Ref! I'm stuck now I'm afraid I'd appreciate any help. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
Finding Cell References | Excel Discussion (Misc queries) | |||
Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) | |||
removing duplicates testing in 2 coloms | Excel Worksheet Functions | |||
Find duplicates | Excel Discussion (Misc queries) |