Count formula which counts UNIQUE TEXT VALUES which start with a specific text string

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

Hi
confirm LFB in one cell, TEST in another cell and the values in third cell?
If they are together then you can try entering the formula in any other cell like =COUNTIF(cellref,"*LFB*") which will give you the answer 2. Change the LFB to any text string will return the count of given text
Hope this will help