| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Choose.
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. |
|
#2
|
|||
|
|||
|
Hi Rodney,
Try changing the zero to one. Gary |
|
#3
|
|||
|
|||
|
Hi Gary,
Yep, that fixed it nicely. appreciated. | Hi Rodney, | Try changing the zero to one. | Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I choose top two numbers in a column? | Excel Worksheet Functions | |||
| CHOOSE function | Excel Discussion (Misc queries) | |||
| I cannot choose Conditional Formatting | Excel Discussion (Misc queries) | |||
| Why does Excel automatically choose the PlotBy method | Charts and Charting in Excel | |||
| Help with macro to choose printer | New Users to Excel | |||
Hybrid Mode
