View Single Post
  #7   Report Post  
Bob Phillips
 
Posts: n/a
Default


<a wrote in message ...

both formulae worked,
but I would prefer the IF statement even though its abit longer.
since it applies to both cases of A1 B1 or B1 A1, i can drag the

formula
down the whole column.


and mine doesn't?