| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choose function not working
Hi Dave,
Am Sun, 11 Dec 2016 09:59:47 +0000 schrieb Dave1972: Worked a treat...thank you. However...now I am intrigued....why didn't the other formula work? any clue? period is only one cell. Therefore MATCH doesn't work. If you have a range named "period" you can use CHOOSE(MATCH...) Have a look: https://1drv.ms/x/s!AqMiGBK2qniTgYM8Bn8SrF_p88VMVw period is the named range R1:R4. Regards Claus B. -- Windows10 Office 2016 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choose format while Find & Replace not working | Excel Discussion (Misc queries) | |||
| Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
| which function to choose? | Excel Worksheet Functions | |||
| Which function to choose? | Excel Worksheet Functions | |||
| CHOOSE Function | Excel Worksheet Functions | |||
Hybrid Mode
