# Counting data in a cell

#### bdonohue

##### New Member
I have a spreadsheet where I've entered multiple numbers in a cell. I've entered this in about 500 or more cells and now I need to figure how many separate items there are. For example, in one there will be 5 different numbers. In another cell there's 4 different numbers. The total here is 9 different items. Is there something I can enter to figure how many different items there are total in all of the cells. I don't want to total the numbers and I don't want to hand count.
Thanks,
Bdonohue
Thanks for any help anyone can offer. bdonohue

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
You may need to post some examples???

Are you trying to count for example if a cell has: 1234
the instances of 1
the instances of 2
the instances of 3
the instances of 4
?????
or something else???

texasalynn

On 2002-09-06 06:59, Jim North wrote:
Check this post out as a starting point:

http://www.mrexcel.com/board/viewtopic.php?topic=18588&forum=2&1

Yes. If the separator between the values stuffed into a single cell is CHAR(10), assuming that multiple-value cells are in A from A1 on, apply:

=1+LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(10),""))

to column B from B1 on. To get the desired count, use:

=SUM(B-range)

[No message]

Wow! Thanks for your help. This worked perfectly.
Brandon D.

Replies
2
Views
176
Replies
3
Views
147
Replies
7
Views
172
Replies
12
Views
394
Replies
5
Views
241

1,221,523
Messages
6,160,321
Members
451,637
Latest member
hvp2262

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back