I am trying to find a formula that will show the individual ranges shown in
column A. The first number in the range will appear in column B and the last
number in the range will appear in the adjacent cell in column C. Is this
even possible?

A B C

1500 1500 1502
1501
1502

1505 1505 1507
1506
1507

1509 1509 1510
1510

try
=min(range1) in column B
and
=max(range1) in column C

"Lori" wrote:

I am trying to find a formula that will show the individual ranges shown in
column A. The first number in the range will appear in column B and the last
number in the range will appear in the adjacent cell in column C. Is this
even possible?

A B C

1500 1500 1502
1501
1502

1505 1505 1507
1506
1507

1509 1509 1510
1510

Thank you, but that doesn't seem to work because there are 1000s of numbers
in column A with numerous individual ranges, and I want all the individual
ranges to be shown in columns B and C.

"bj" wrote:

try
=min(range1) in column B
and
=max(range1) in column C

"Lori" wrote:

I am trying to find a formula that will show the individual ranges shown in
column A. The first number in the range will appear in column B and the last
number in the range will appear in the adjacent cell in column C. Is this
even possible?

A B C

1500 1500 1502
1501
1502

1505 1505 1507
1506
1507

1509 1509 1510
1510

How do you differencialte the different individual ranges?

"Lori" wrote:

Thank you, but that doesn't seem to work because there are 1000s of numbers
in column A with numerous individual ranges, and I want all the individual
ranges to be shown in columns B and C.

"bj" wrote:

try
=min(range1) in column B
and
=max(range1) in column C

"Lori" wrote:

I am trying to find a formula that will show the individual ranges shown in
column A. The first number in the range will appear in column B and the last
number in the range will appear in the adjacent cell in column C. Is this
even possible?

A B C

1500 1500 1502
1501
1502

1505 1505 1507
1506
1507

1509 1509 1510
1510

It's not set up to differentiate between individual ranges. What would you
suggest?

"bj" wrote:

How do you differencialte the different individual ranges?

"Lori" wrote:

Thank you, but that doesn't seem to work because there are 1000s of numbers
in column A with numerous individual ranges, and I want all the individual
ranges to be shown in columns B and C.

"bj" wrote:

try
=min(range1) in column B
and
=max(range1) in column C

"Lori" wrote:

I am trying to find a formula that will show the individual ranges shown in
column A. The first number in the range will appear in column B and the last
number in the range will appear in the adjacent cell in column C. Is this
even possible?

A B C

1500 1500 1502
1501
1502

1505 1505 1507
1506
1507

1509 1509 1510
1510

from your first example are all of them in groups of three separated by one
row.
if this is the case you could use in B3
=if(A2="",min(A3:A5),"")
and in C3
=if(A2="",max(A3:A5),"")
If I understand what you are doing, you will need either a pattern or a
identifier of some type which will identify the different grouping you wish
to get the range for.

If it is not three numbers per group, and you use a blank line between the
groups what is the max and minimum number of data ppoints you want to get the
range for?
Also in your example the trios were in order. Is this always the case.
(there are some short cuts which can be used if it is always the case.)


"Lori" wrote:

It's not set up to differentiate between individual ranges. What would you
suggest?

"bj" wrote:

How do you differencialte the different individual ranges?

"Lori" wrote:

Thank you, but that doesn't seem to work because there are 1000s of numbers
in column A with numerous individual ranges, and I want all the individual
ranges to be shown in columns B and C.

"bj" wrote:

try
=min(range1) in column B
and
=max(range1) in column C

"Lori" wrote:

I am trying to find a formula that will show the individual ranges shown in
column A. The first number in the range will appear in column B and the last
number in the range will appear in the adjacent cell in column C. Is this
even possible?

A B C

1500 1500 1502
1501
1502

1505 1505 1507
1506
1507

1509 1509 1510
1510