Repeating numbers in same cell
This would work if the worksheet wasn't so big. I have numerous cells that
have repeating numbers in them. The problem is that the numbers are
different for each cell.
Using Text to Columns wouldn't work. There are up to 80 numbers in any
given cell.
Thanks for your quick response though.
"Gary''s Student" wrote:
1. Use Text to Columns to move the numbers to individual cells
2. Copy the row to a column using Paste/Special/Transpose
3. create Pivot Table listing the count of values by value.
--
Gary''s Student - gsnu200777
"Tabby" wrote:
I have a worksheet that has repeating numbers in one cell.
Example: 1204,1205,1206,1205,1204
Is there a formula that will total the repeating numbers? i.e. (2) 1204,
(2) 1205?
|