| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicate Values in Excel 2007
I have successful Vlookup formulas and duplicate values between multiple
columns in a multipage spreadsheet. However, when I try to compare by duplicate value a third set of 2 columns, Excel 2007 sees the entries as unique while they are clearly duplicates. The only thing I see different in this comparison over the other column comparisons is that I am using a formula =LEFT(J3, SEARCH(" ",J3,SEARCH(" ",J3,1)+1)) in one of the columns. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel error - Highlighting duplicate values | Excel Discussion (Misc queries) | |||
| Conditonal Formating Excel 2007 - Duplicate Values | Excel Worksheet Functions | |||
| How do I match duplicate numbers/values in Excel? | Excel Discussion (Misc queries) | |||
| How do I filter out duplicate values in Excel 2000? | Excel Worksheet Functions | |||
| Duplicate & Zero Values in Lists (Excel 2003) | Excel Worksheet Functions | |||
Threaded Mode
