ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Same Question with one more addition of a dash to count (https://www.excelbanter.com/excel-discussion-misc-queries/38826-same-question-one-more-addition-dash-count.html)

Mahendra

Same Question with one more addition of a dash to count
 
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 (there are four numbers in col.B)
1300 1, 12-15 5 (there are five numbers in col.B, notice
the range has a dash between 12 and 15 in Col.B - this is an addition to
previous question which was answered very well and I appreciate that)


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com