only match if column is not empty
 

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

only match if column is not empty
 

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rodchar" wrote in message
...
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

only match if column is not empty
 

thanks for the help,
rod.

"RagDyer" wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rodchar" wrote in message
...
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