View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rodchar rodchar is offline
external usenet poster
 
Posts: 80
Default 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