only match if column is not empty

[rodchar]

hey all,

i have 2 columns

beforeAmt, afterAmt
1,2
2,2
"blank row"
3,3

i'd like to do an EXACT on beforeAmt and afterAmt but not on the blank rows
is there a way to leave those blank and do the match for the others?

thanks,
rodchar

 

[RagDyer]

Try this:

=IF(AND(A1<>"",B1<>""),EXACT(A1,B1),"")

 

[rodchar]

thanks for the help,
rod.

Try this:

=IF(AND(A1<>"",B1<>""),EXACT(A1,B1),"")