Hi All,
i need your help to find out duplicates Column A and B. but i used simple CF and highlight duplicates value, in this same column values highlights.
i need to perfect match single value column B to match column A. example 280 value column B lies 40 time and column A 43 time so i want highlight 40 values match column A and 2 time values column A is extra after using filter.
i used formula =ISNUMBER(MATCH(B2,$A$2:$A$385,0)) for perfect match but this is also showing TRUE.
can you tell me how i can do highlights duplicates values exact match. if any value not lies in column A not highlight
hope you understand my point.
Thanks
Bookmarks