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