Reversing rows of information

[lehigh46]

Hi All:

I have a sheet with equipment hours
Each piece of equipment has two rows. (I have over 100 pieces of
equipment)
The first row is "stand by time"
The second row is "operating time"
I have since found that the two rows for each piece of equipment are
reversed.
Is there a way "flip" the two rows on each piece?

Thanks for your help

Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 30+ Days Binary Retention with High Completion
x-- Access to over 1.9 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

 

[Richard Buttrey]

Hi All:

I have a sheet with equipment hours
Each piece of equipment has two rows. (I have over 100 pieces of
equipment)
The first row is "stand by time"
The second row is "operating time"
I have since found that the two rows for each piece of equipment are
reversed.
Is there a way "flip" the two rows on each piece?

Thanks for your help

Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 30+ Days Binary Retention with High Completion
x-- Access to over 1.9 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

Assuming each of your equipment rows are together, i.e. rows 2+3, 4&5,
88&89 etc. then you could use a helper column. If the Equipment number
is in column A and the time in column B, then in C2 put the following:

=IF(A2<>A1,2,1)
and copy down.

Now re-sort your data with A as the first sort and B as the Second
(ascending) sort.

HTH



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________