Hello p45cal,
Wow, a very impressive modification.
I have been changing your formula by switching parts around and editing the expected result.
In my attached workbook I used data validation in column B to quickly change the restriction type to test the formula.
The small table to the right are the restrictions in order of severity and the expected result from the formula.
As I said in a previous post, I was quite happy with your original formula and it would have done what I was after, but this modification has taken it to another level.
Greatly appreciated, Dave T
|