Statsman
Now you are changing the rules.
Only way I can think to do this is build your own function.
Put the code below in a general module in the relevant workbook.
[NOTE: For those that are interested, I know there is no comments, and the choice of variable names is not particularly spectacular!!!!]
Now in your spreadsheet, say B1, enter the formula
and it should return 4. Make it
and it will return 2.
If you want to go down this track, then you will have to make the search string in the form I have used in the function.
HTH
rylo
Bookmarks