Sorry, I thought I deleted that message when I realized it didn't work for
your situation. Evidently, I pressed Send by mistake.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)



"Ron Coderre" wrote in message
...
Yup....Try this:

With

A2:B4 containing the below list of range start/end values
Start End
10 15
21 23
30 32

D1: =MIN($A$2:$A$4)

D2:
=IF(MAX($D$1:$D1)=MAX($B$2:$B$4),"",IF(ISNA(MATCH( D1,$B$2:$B$4,0)),D1+1,INDEX($A$2:$A$4,MATCH(D1,$A$ 2:$A$4,1)+1)))
Copy that formula down as far as needed

In this example, the below list is returned in D1:D12
10
11
12
13
14
15
21
22
23
30
31
32

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"ExcelMonkey" wrote in message
...
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