B
bamboo
i have to like invert several colums... i dont know how to do that
without retyping the whole thing, is there another way?
without retyping the whole thing, is there another way?
S
Sandy Mann
If the columns are all contiguous then, insert another colum enter 1 in the
first cell, 2 in the second, highlight both cells and hover the cursor over
the "fill Handle" in the bottom right-hand corner whereupon the cursor will
turn into a cross-hair and left click which will fill the series in the
length of the adjacent column.
Now highlight all the columns that you want to invert and sort in decending
order using the inserted column as the sort column.
--
HTH
Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
first cell, 2 in the second, highlight both cells and hover the cursor over
the "fill Handle" in the bottom right-hand corner whereupon the cursor will
turn into a cross-hair and left click which will fill the series in the
length of the adjacent column.
Now highlight all the columns that you want to invert and sort in decending
order using the inserted column as the sort column.
--
HTH
Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
B
Biff
Hi!
Suppose you want to invert A1:C10
In D1 enter this formula:
=ROW()
Double click the fill handle to copy the formula through D10
Select the range, A1
10 then sort on column D descending.
After your done delete he formulas in column D.
Biff
Suppose you want to invert A1:C10
In D1 enter this formula:
=ROW()
Double click the fill handle to copy the formula through D10
Select the range, A1
10 then sort on column D descending.After your done delete he formulas in column D.
Biff