View Single Post
  #3   Report Post  
Lori
 
Posts: n/a
Default

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