Dear Sir,
I wanted to find duplicate values between two lists but if I apply conditional formatting its taking duplicate value even if that is not available in list two.
I wanted to highlight duplicate values only if available in both list.
Please note I can use remove duplicate from list one but data is big and there are so many columns so I can’t apply remove duplicate.
I wanted to find duplicate values between two lists but if I apply conditional formatting its taking duplicate value even if that is not available in list two.
I wanted to highlight duplicate values only if available in both list.
Please note I can use remove duplicate from list one but data is big and there are so many columns so I can’t apply remove duplicate.