| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pls help with Excel Function
I have a list of thousands of records. I need to identify duplicates. There
can be more than one duplicate. I am using this function =IF(countif(B$2:B$3000,B2)1, "Duplicate","No Dup"). This marks all the same rows duplicate. I would like for the function to look at the first dup not mark it dup and only mark the next row if dup as Duplicate. For instance: Duplicate testing No dup testing Duplicate testing Duplicate testing Duplicate testing Duplicate testing Duplicate Monday No dup Monday Duploicate Monday Duplicate Monday |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
Threaded Mode
