Forum Discussion
Duplicate values with partial matches
Hello Gurus, i have an excel sheet with 3000 rows with column A named countries and another column B named cities. I need to highlight the duplicate city names in column B for each country in col...
SergeiBaklan Thank you. This has cleared the problem upto an extent. But now it is searching the whole sheet with all columns. whereas my search should be limited to A and B Columns.
| ALB | Gjirokastra -Expired as of XXXX | 112 | Gjirokastra -Expired as of XXXXXX |
Technically this is not duplicate but it is highlighting as duplicate because the same name exits in Column D.
Nope, it highlights entire row within the range if duplicate is in column B only. Here is the sample with your formula as in previous post