VBA find matching ID then compare other values in row

[Kinjal Doshi]

To hiker95

I went through your earlier post - https://www.mrexcel.com/forum/excel...atching-id-then-compare-other-values-row.html

It was very helpful.. but it works only on 6th column. My requirement is that it works in all the columns that my excel sheet has... please check if you can help me out...

Thanks
Kinjal.

 

[Kinjal Doshi]

Hi Mick,

I found the error.., It throws type mismatch error... when I have the value "#N/A" in any of the cell.
When I removed all of these... It worked perfectly fine.


Regards
Kinjal