LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
nospaminlich
 
Posts: n/a
Default Finding Duplicates

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding and Deleting duplicates in a column Brian Excel Worksheet Functions 3 February 5th 05 02:19 PM
Finding Cell References Zokess Excel Discussion (Misc queries) 2 February 4th 05 04:52 PM
Finding Duplicates and somehow flagging them in another column KenRamoska Excel Discussion (Misc queries) 1 January 31st 05 06:20 PM
removing duplicates testing in 2 coloms Warzel Excel Worksheet Functions 3 January 23rd 05 11:39 AM
Find duplicates R. Choate Excel Discussion (Misc queries) 5 November 28th 04 10:14 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"