Hello All,
I have a condition formate that allows me to highlight names in to separate columns. but I need the formula to exclude characters buy still highlight them as duplicates if that makes sense.
So some names have ( ' ) or a space or even ( - ). But I am looking for the formula to count it as a duplicate.
The formula that i am using is =COUNTIFS($F$1:$F$96739,$F1,$G$1:$G$96739,$G1)>1
I also use a modified verison to detect duplicates on other sheets as well. I have provided a link as I am not able to use XL2BB. It crashes every time i use it. BLANK WORKBOOK.xlsb
I have a condition formate that allows me to highlight names in to separate columns. but I need the formula to exclude characters buy still highlight them as duplicates if that makes sense.
So some names have ( ' ) or a space or even ( - ). But I am looking for the formula to count it as a duplicate.
James | o'brien |
James | obrien |
Jose | Arroz-Ortega |
Jose | Arroz Ortega |
Jose | Arroz-Ortega |
The formula that i am using is =COUNTIFS($F$1:$F$96739,$F1,$G$1:$G$96739,$G1)>1
I also use a modified verison to detect duplicates on other sheets as well. I have provided a link as I am not able to use XL2BB. It crashes every time i use it. BLANK WORKBOOK.xlsb