Reverse Order of Data Set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bekah1st - 30 Apr 2007 23:58 GMT

How do you reverse the order of a large set of data without having to retype
each cell? For example if I had data in the following order: A1: 10, A2: 12,
A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
make this happen for a large set of data?

Reply to this Message

JMB - 01 May 2007 00:10 GMT

Use a helper column. In B1:B14 enter 1,2,3,....14. Then sort column A and B
using Column B, sort descending.

> How do you reverse the order of a large set of data without having to retype
> each cell? For example if I had data in the following order: A1: 10, A2: 12,
> A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
> make this happen for a large set of data?

Reply to this Message

Bekah1st - 01 May 2007 00:17 GMT

so clever! thank you! it worked like a dream!

> Use a helper column. In B1:B14 enter 1,2,3,....14. Then sort column A and B
> using Column B, sort descending.
[quoted text clipped - 3 lines]
> > A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
> > make this happen for a large set of data?

Reply to this Message

Gord Dibben - 01 May 2007 00:34 GMT

Data>Sort>Descending

Gord Dibben MS Excel MVP

>How do you reverse the order of a large set of data without having to retype
>each cell? For example if I had data in the following order: A1: 10, A2: 12,
>A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
>make this happen for a large set of data?

Reply to this Message