1

I have a column (say A) that has numeric values, but not sorted.

Now, I have a some more columns, (say B, C and D); and column B has all the data in column A but in a different order. The values in columns C and D correspond to the values in B.

My question is, how can I order columns B, C and D in same the order as A? I've tried VLOOKUP but it doesn't seem to help.

P.S. I've looked at Excel: Order a column based on another column which is similar but the VBA code in the accepted answer is not what I'm looking for.

Community
  • 1
  • 1
Gokul
  • 244
  • 1
  • 9
  • 1
    Did you just try using tables? http://office.microsoft.com/en-us/excel-help/overview-of-excel-tables-HA010048546.aspx – smagnan Aug 04 '14 at 06:24

1 Answers1

1

Sort B:D (say A>Z). Add a column, say A, with a sequential counter (1, 2, 3 ....) and sort the ColumnsA:B on ColumnB A>Z. Sort A:E on ColumnA ascending.

pnuts
  • 58,317
  • 11
  • 87
  • 139