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
|