Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a string of numbers which represent multiple sets. The string look as
follows below. I need a function which returns an array which outlines: 1) the number of sets of numbers 2) the min number per set 3) the max number per set Based on the data below it would return a 2D array with three columns as follows: Set 1 - Min of 3, Max of 5 Set 2- Min of 2, Max of 5 Set 3- Min of 3, Max of 5 3 4 5 2 3 4 5 3 4 5 Any ideas on how to do this? Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula to add a number to a long string ** | Excel Worksheet Functions | |||
parsing a string for 3 sets of numbers | Excel Programming | |||
Extract sub-string of number from field of long series of numbers | Excel Worksheet Functions | |||
Extract Numbers from Alpha-Numeric String | Excel Worksheet Functions | |||
search to identify duplicate enties in long columns of numbers | Excel Discussion (Misc queries) |