| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
A cell contains "1,2,3"; and I want to count those sep. by comma
I have three columns. Column A contains a number, column B contains bunch of
numbers separated by comma corresponding to the number in column A. In the column C, I want to count the numbers in col. B separated by comma. Example: Column A Column B Column C 1200 2,3,4,8 4 (i.e. there are four numbers in column B) |
|
#2
|
|||
|
|||
|
One possibility:
=IF(B1="","",LEN(B1)-LEN(SUBSTITUTE(B1,",",""))+1) In article , "Mahendra" wrote: I have three columns. Column A contains a number, column B contains bunch of numbers separated by comma corresponding to the number in column A. In the column C, I want to count the numbers in col. B separated by comma. Example: Column A Column B Column C 1200 2,3,4,8 4 (i.e. there are four numbers in column B) |
|
#3
|
|||
|
|||
|
Mahendra,
In C1, to count the items in B1 =IF(B1<"",LEN(B1)-LEN(SUBSTITUTE(B1,",",""))+1,0) HTH, Bernie MS Excel MVP "Mahendra" wrote in message ... I have three columns. Column A contains a number, column B contains bunch of numbers separated by comma corresponding to the number in column A. In the column C, I want to count the numbers in col. B separated by comma. Example: Column A Column B Column C 1200 2,3,4,8 4 (i.e. there are four numbers in column B) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| Count the number of specific values in a cell | Excel Worksheet Functions | |||
| How do you count number of characters in a single cell | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions | |||
Linear Mode
