If (and that's a big if) I have understood correctly perhaps the below version is along the lines of what you want ?
The above as you can see has some additional optional parameters (in addition to pre-requisite range argument) that denote:
1) font is bold (default is False)
2) prefix (default is nothing)
3) suffix (default is nothing)
4) case sensitivity (default is insensitive)
So in essence:
So if you wanted to simply count the unique values in the non-contiguous range of A1:A5 / C1:C5 you would use as before
If you wanted to further restrict based on those values for which font is bold
If you wanted to restrict to names prefixed with ** and bold then:
If bold font of no consequence you would change TRUE to FALSE (or remove the TRUE), ie
If you wanted to restrict to names with suffix of ** and bold then:
Case sensitivity is the final optional parameter
ie the above does the same as the predecessor only now Mike** and MIKE** would be seen as unique values
One thing to note given the above - altering the Bold state of a cell is not a Volatile action (per se) and so will not invoke a calculation
(ie changing Mike** to Mike** won't cause the UDF to recalculate unless done via an edit in the Formula Bar - ie re-entering the value)
Bookmarks