| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I highlight duplicates cells in excell prior to deletio
Thanks!
"Mike H" wrote: Try, =IF(VLOOKUP(A3,Offers!$B$2:$U$751,18,FALSE)=0,"",V LOOKUP(A3,Offers!$B$2:$U$751,18,FALSE)) Mike "Paul B" wrote: I don't want to delete them straight away as I found that the new remove duplicates function has removed entries which were not exact duplicates |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i locate/highlight duplicates ? | Excel Discussion (Misc queries) | |||
| compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions | |||
| How do I get excell to highlight entire row when I am in any cell | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| Search should highlight entire row in Excell in red | Excel Discussion (Misc queries) | |||
![Paul B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
