Count how many unique charecter in cell

[Axmed.cm]

Hi All

Can I have this in formula or code?

how many "M" in cell A1 whose value is "My mom alway love me"

Thanks in advanced

[zbor]

Here, try this:

Please Login or Register  to view this content.

[Axmed.cm]

Thanks Dear.

it is working perfectly.

[Axmed.cm]

Dear All

I have been wondering if there is a formula of getting address(Row and column number) of last non blannk cell in range. or even the Column number only.
for example
here is data

(1 2 3 4 5 6 7 8 9 10 11 12 ) in A1:N1 respectively. 12 is last non empty cell and its adddress is ($L$1)

can i find this in formula???

Thank you in advance

[JohnTopley]

If no embedded blanks in range:

=ADDRESS(ROW(),COUNTIF($A$1:J1,"<>" & ""))

If embedded blanks try:

=ADDRESS(ROW(),COUNTIF($A$1:J1,"<>" & "")+COUNTBLANK($A1:J1))

[Glenn Kennedy]

I posted in the wrong place.

[Glenn Kennedy]

Welcome to the Forum, unfortunately: you've broken a couple of rules. You hijacked an older thread (even if it was one of your own, changing its content, etc... and then duplicated this query elswhere on the Forum.

This thread will now be closed, you may continue in your other thread.

Thread Closed.