Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
simple chart question | Excel Worksheet Functions | |||
Simple If, Then formula for excel | Excel Discussion (Misc queries) | |||
simple if then function | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Help with what should be a simple formula | Excel Worksheet Functions |