Dear Sir,
I have two sheets 1) Bank Statement 2) Bank Ledger
My data is not in a same format I wanted to reconcile both sheet and highlight the matching cells with color yellow amount difference with up to Rs 1 can be ignored.
I have been trying to solve this type of problem since years because my data is large and comes in as per attached sheet format only.
Does excel have any solution for the same?
I have two sheets 1) Bank Statement 2) Bank Ledger
My data is not in a same format I wanted to reconcile both sheet and highlight the matching cells with color yellow amount difference with up to Rs 1 can be ignored.
I have been trying to solve this type of problem since years because my data is large and comes in as per attached sheet format only.
Does excel have any solution for the same?