Hi All,

I have a spreadsheet, with text entries in the columns. I want to have a formula which will count the UNIQUE text entries within those columns. The next bit is, that each of the text strings in the different cells, will start with certain things, depending on what client they are for, so I want to be able to ask the formula to count the number of UNIQUE text strings which start with LFB, or JLR, or LMS etc.

For Example, if I had 3 cells, with the following strings within them:

LFB - TEST 1
LFB - TEST 2
JLR - TEST 1
JLR - TEST 2
LMS - TEST 1
LMS - TEST 2

A formula to count the unique text strings would return an answer of 6, however, I would like a formula, which I can specify what the string must start with. So in the case of LFB, the formula I desire would return a value of 2.

If you need any further explanation, please let me know, but for now with the limited access I have to the website from my phone, this was the best way I could demonstrate what I meant.

Thanks in advance for your help gurus!




Chris