group seach!

[stewart08]

Dear excelers, this could be a difficult one. here it goes:

I want to do a horizontal row search/count to find the highest/lowest Frequency numbers from groups of 0-9 digits (see example PS "10" should be "0" )

Example:

index groups: (0123456789) (0123456789) (0123456789) (0123456789)
num frequency: (1048341421) (1271157911) (1201341001) (1271152311)

need this result:
two highest: 7,4
two lowest: 1,2

[img=http://aycu27.webshots.com/image/50826/2005939380770129427_th.jpg]

[ChemistB]

It's not clear (to me) whether these are individual digits within cells or digits within larger numbers. If they are digits within larger numbers, you'll need to either separate the digits out into separate cells using formulas, or use VBA to calculate this. If they are single digits (or once you have them broken up into single digits), you can use COUNTIF or FREQUENCY functions.

ChemistB