Pls Help!

[cjjoo]

i got a row of inputs with letters and numbers at the end of it ( e.g RN1, RN2)

now i wan to count the number of returns from RN regardless of the number behind. So how do i do it?

A1:A10

RN1
RN2
RN4

count_num_ of_returns

tks..

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[cjjoo]

i have tried it before but it does not work! sob sob . Any more
suggestions? tks

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[cjjoo]

i have tried it before but it does not work! sob sob . Any more
suggestions? tks

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[BenjieLop]

Based on your given conditions, Max's suggested formula

=COUNTIF(A1:A10,"RN*")

should work.

Regards.

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> i got a row of inputs with letters and numbers at the end of it ( e.g
> RN1, RN2)
>
> now i wan to count the number of returns from RN regardless of the
> number behind. So how do i do it?
>
> A1:A10
>
> RN1
> RN2
> RN4
>
> count_num_ of_returns
>
> tks..
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> i have tried it before but it does not work! sob sob . Any more
> suggestions? tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=401872
>

[Max]

Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[cjjoo]

hey guys i got tks alot!!

[Max]

Glad to hear that !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--