View Single Post
  #7   Report Post  
anon125 anon125 is offline
Junior Member
 
Posts: 6
Default

(A ND(RIGHT(A1,1) i gues that should be AND.

I am confused now but the latest formula looks like an earlier one!

wish i could post the excel file!


thanks all