| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing cell to row, return all matchs
AHello, working on a project but can't get formula to work, started with
nested IF but due to limitations gave up. Heres the problem... When working with the below route line (imported from AS400) what formula string can I use to bring back any result of duplication? A B C D E F G H I J K L M KENNWA E PASCWA E KENNWA E YAKIWA E ONTAOR E FONTCA L YAKIMA Not only do I want to know that KENNWA is in the row 2 times.. but YAKIMA is as well. (regardless of E or L between them) currently seem to have some success with the following... =IF(COUNTIF($A1:M13,A1)1,1,0) Did the 1 due to it finding itself every time... but having to replicate formula for each cell thru M. Is there a faster/easier way? -- EOD- we take the licking when it stops ticking. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| sumproduct return value by comparing two criteria..... | Excel Worksheet Functions | |||
| Comparing two lists and return specified data | Excel Worksheet Functions | |||
| comparing cell | New Users to Excel | |||
| return array result in cell based on comparing dates | Excel Worksheet Functions | |||
Threaded Mode
