Prev: Combo Bar-Line Graph with single list of data
Next: Can't open Excel 2007
From: karenb on 15 Jan 2010 10:32
I need to completely flip an address data record. Sorting does not work
because it only works by ascending or descending by fields. Is there some
way of flipping rows?
From: Yanick on 15 Jan 2010 10:37
On Jan 15, 10:32 am, karenb <kar...(a)discussions.microsoft.com> wrote:
> I need to completely flip an address data record.  Sorting does not work
> because it only works by ascending or descending by fields.  Is there some
> way of flipping rows?

Add a column and put number from 1 to ...

Then sort that column as you need.
From: Gord Dibben on 15 Jan 2010 13:50
Records are across a row?

Enter 1 through x across a helper row.

Sort that helper row "left to right" descending.

Same if records are down a column.


Gord Dibben MS Excel MVP


On Fri, 15 Jan 2010 07:32:01 -0800, karenb
<karenb(a)discussions.microsoft.com> wrote:

>I need to completely flip an address data record. Sorting does not work
>because it only works by ascending or descending by fields. Is there some
>way of flipping rows?

 | 
Pages: 1
Prev: Combo Bar-Line Graph with single list of data
Next: Can't open Excel 2007