LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
 
Posts: n/a
Default Checking for duplicates - think this is simple

Hi. I'm not much an Excel guy, so I'm hoping someone can help me
fairly quickly. Thanks so much in advance!

I have several columns of numbers, say 10 columns of numbers with the
same number of rows (again, let's keep it simple and say 10 rows -
although I need to run this a few times against different data, so
although it will always be 10 columns, it might be 9 rows in one case,
11 rows in another).

So in my 10x10 grid of numbers, I want to see if A1 has any duplicates
in A2-A10. If it does, I want to either to mark A1 with a "*" or I
could also insert a column between A and B and make B1 = "*". But then
I want to also check A2 for any duplicates in A1 and A3-A10. And do
the same for A3 - checking for any duplicates in A1-A2 or A4-A10. Make
sense? I sure hope so. :)

The problem is, I want to do the same thing for column B, column C,
etc.

So column A could have numbers like:

70 *
73
68 *
70 *
79
68 *
....

Is there any way to do this? I guess I could set up
IF(A1=A2,"*",IF(A1=A3,"*",IF...) but that'd be a nightmare, I think.

Any help would guarantee a Christmas this year! :)

Thanks again so much!
Steve

 
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
simple chart question Shooter Excel Worksheet Functions 1 January 24th 06 09:30 PM
Simple If, Then formula for excel mike_vr Excel Discussion (Misc queries) 4 December 1st 05 04:26 PM
simple if then function amy Excel Worksheet Functions 4 July 6th 05 05:36 PM
Simple Simple Excel usage question BookerW Excel Discussion (Misc queries) 1 June 23rd 05 10:06 PM
Help with what should be a simple formula B Millar via OfficeKB.com Excel Worksheet Functions 2 June 16th 05 04:18 PM


All times are GMT +1. The time now is 05:58 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"