Gazar
Suppose u want the comparison result to appear in column G, then u can write
a formula like this:
=if(D2<F2, "", "match")
The result would be that when D and F do not match, the cell in G would be
blank, otherwise "match" will be written in the cell
Hope this was helpful
"garzar" wrote:
Comparing columns D and F, If the data doesn't match, I need a blank inserted
where the columns don't match. How can I achieve this?
|