Count group of data

  • Thread starter Thread starter mon.bannister
  • Start date Start date
M

mon.bannister

Hi,

Hope someone can help!

I'm looking for a formula to produce the following result from data
below:

Data can be in text, colour or numeric format


Results DATA
8 4 2 3 1 11111111 1111 11 111 1
2 4 1 3 11 1111 1
111
2 1 3 1 2 11 1 111 1 11

Thanks!
 
That is a really confusing post. I for one have no idea what you are trying
to count, or the expected results. And what do you mean by ... can be in ...
colour ...?
 
Back
Top