Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
good evening,
i'm needing to tag duplicate entries in a single column. the entries were downloaded from access. i'm using the following formula, but keep returning #NAME?. please advise. =IF(COUNTIF(Range1,A1)1,"Duplicate","") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting duplicate entries in an Excel list | Excel Worksheet Functions | |||
Deleting duplicate entries in Excel list | Excel Discussion (Misc queries) | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |