Count using left function in Range

[vinaynaran]

Dear all,

Please see attached file.

Actually I want count of first 4 Digits of Post code.

In file have used column C but don’t want to use this column to get Count.

Is there are any other way to do?

Please help me.


Vinay

[Sadath31]

use
=COUNTIF($B$2:$B$55,G2&"*")

[vinaynaran]

Excellent Sadath

It working perfect.

Thank you very much.

Regards


Vinay