Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW MANY "/" IN THIS CELL A1 = "RG/351/87/11/3"
hi,
i want to calculate the following; CELL A1 HAS A VALUE = RG/351/87/11/3 1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL 2- HOW MANY "3" (THREE) IN THIS CELL. ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC WORD/NUMERIC/SPECIAL CHARACTER IN A CELL. THANKS FOR YOUR COOPERATION. I HOPE I WILL GET IT SOON. SAQIB YAQUB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW MANY "/" IN THIS CELL A1 = "RG/351/87/11/3"
=LEN(A1)-LEN(SUBSTITUTE(A1,A2,""))
Put this in b1 and the character you want to count in A2 "- - - - -" wrote: hi, i want to calculate the following; CELL A1 HAS A VALUE = RG/351/87/11/3 1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL 2- HOW MANY "3" (THREE) IN THIS CELL. ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC WORD/NUMERIC/SPECIAL CHARACTER IN A CELL. THANKS FOR YOUR COOPERATION. I HOPE I WILL GET IT SOON. SAQIB YAQUB |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW MANY "/" IN THIS CELL RANGE A1:A5
Dear Mike,
thanks for reply. I have one query more. if i have a range then how i can calculate; CELL A1 RG/351/87/11/1 CELL A2 RG/351/87/11/2 CELL A3 RG/351/87/11/3 CELL A4 RG/351/87/11/4 CELL A5 RG/351/87/11/5 THANKS FOR IN ADVANCE. TAKE CARE SAQIB YAQUB "Mike" wrote: =LEN(A1)-LEN(SUBSTITUTE(A1,A2,"")) Put this in b1 and the character you want to count in A2 "- - - - -" wrote: hi, i want to calculate the following; CELL A1 HAS A VALUE = RG/351/87/11/3 1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL 2- HOW MANY "3" (THREE) IN THIS CELL. ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC WORD/NUMERIC/SPECIAL CHARACTER IN A CELL. THANKS FOR YOUR COOPERATION. I HOPE I WILL GET IT SOON. SAQIB YAQUB |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW MANY "/" IN THIS CELL RANGE A1:A5
=SUMPRODUCT(LEN(C1:C5)-LEN(SUBSTITUTE(C1:C5,"/","")))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "- - - - -" wrote in message ... Dear Mike, thanks for reply. I have one query more. if i have a range then how i can calculate; CELL A1 RG/351/87/11/1 CELL A2 RG/351/87/11/2 CELL A3 RG/351/87/11/3 CELL A4 RG/351/87/11/4 CELL A5 RG/351/87/11/5 THANKS FOR IN ADVANCE. TAKE CARE SAQIB YAQUB "Mike" wrote: =LEN(A1)-LEN(SUBSTITUTE(A1,A2,"")) Put this in b1 and the character you want to count in A2 "- - - - -" wrote: hi, i want to calculate the following; CELL A1 HAS A VALUE = RG/351/87/11/3 1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL 2- HOW MANY "3" (THREE) IN THIS CELL. ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC WORD/NUMERIC/SPECIAL CHARACTER IN A CELL. THANKS FOR YOUR COOPERATION. I HOPE I WILL GET IT SOON. SAQIB YAQUB |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW MANY "/" IN THIS CELL RANGE A1:A5
=SUMPRODUCT(LEN(A1:A1000)-LEN(SUBSTITUTE(A1:A1000,C1,"")))
Checks the range A1 _ A1000 for the character in C1 "- - - - -" wrote: Dear Mike, thanks for reply. I have one query more. if i have a range then how i can calculate; CELL A1 RG/351/87/11/1 CELL A2 RG/351/87/11/2 CELL A3 RG/351/87/11/3 CELL A4 RG/351/87/11/4 CELL A5 RG/351/87/11/5 THANKS FOR IN ADVANCE. TAKE CARE SAQIB YAQUB "Mike" wrote: =LEN(A1)-LEN(SUBSTITUTE(A1,A2,"")) Put this in b1 and the character you want to count in A2 "- - - - -" wrote: hi, i want to calculate the following; CELL A1 HAS A VALUE = RG/351/87/11/3 1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL 2- HOW MANY "3" (THREE) IN THIS CELL. ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC WORD/NUMERIC/SPECIAL CHARACTER IN A CELL. THANKS FOR YOUR COOPERATION. I HOPE I WILL GET IT SOON. SAQIB YAQUB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |