| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pls Help!
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 |
|
#2
|
|||
|
|||
|
Try: =COUNTIF(A1:A10,"RN*")
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "cjjoo" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "cjjoo" wrote in message ... 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 |
|
#6
|
|||
|
|||
|
Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
|
#7
|
|||
|
|||
|
Based on your given conditions, Max's suggested formula =COUNTIF(A1:A10,\"RN*\") should work. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=401872 |
|
#8
|
|||
|
|||
|
hey guys i got tks alot!! -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=401872 |
|
#9
|
|||
|
|||
|
Glad to hear that !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
