Choose.

  • Thread starter Thread starter Rodney
  • Start date Start date
R

Rodney

I am currently using a similar statement in a DB,
how may I adapt it to an Excel cell please?
(striking trouble with the divisor into the text string)

=CHOOSE(FIND(VENUE,"W ANSWVICS AN TCANTAS",0)/3,1,2,3,4,5,6,7)

Thank you.
 
Hi Gary,
Yep, that fixed it nicely.
appreciated.



| Hi Rodney,
| Try changing the zero to one.
| Gary
 
Back
Top