Count group of data

Giganews Newsgroups
Subject: Count group of data
Posted by:  mon.bannist…@suncorp.com.au
Date: Tue, 29 Jul 2008

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!

Replies