Sorting Problem

kishorkhanal

Active Member
Joined
Mar 23, 2006
Messages
434
I have random values in column A. It is all numbers and texts mixed. From columns B to E I have values for the corresponding value in Column A. I want the values in column A sorted in some other order and rest of the values should also get sorted accordingly.

In column F I have same values in Column A but in the order I want other values from cells B to E to cells G to J corresponding to value in column A. I used Lookup function but didn't work.

This is an example. I come accross lot of values to be sorted. I want to automate to certain extent. I want formula in cells G to J so that whenever I enter values in order in cell F, all other corresponding values should show automatically, provided I have all the values already entered in cells A to E.

Any suggestions please.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

kishorkhanal

Active Member
Joined
Mar 23, 2006
Messages
434
I guess my question was not clear to anybody.

As I said I have values in column A to E. If the order of values in column A is changed I want to sort other numbers accordingly. Any idea?
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
WoW! This is soo confusing. Can you provide a small example of what you have and what you want to achieve after sorting?

Michael
 

kishorkhanal

Active Member
Joined
Mar 23, 2006
Messages
434
I work with pressure vessels(tubes). Column A has tube numbers. Column B has Pressure, column C has manufacturing date and so on till E.

On column F, I have same tube numbers in column A but in a different order. Now, from column G to J, I want to the values from columns B to E but sorted based on column F.

The purpose of sorting is to give the proper loading sequence of the tubes to our customers. Column F has the required loading sequence in this case.

I hope it is clear now.
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587

ADVERTISEMENT

From the Help file, here's how you would sort with more than 3 criteria:
Sort rows by four criteria (columns)

Click a cell in the range you want to sort.
On the Data menu, click Sort.
In the first Sort by box click the column of least importance.
Click OK.
On the Data menu, click Sort.
In the Sort by and Then by boxes, click the other three columns you want to sort, starting with the most important.
Select any other sort options you want, and then click OK.
 

kishorkhanal

Active Member
Joined
Mar 23, 2006
Messages
434
I dont' have criteria to sort. I have values which are text and numbers mixed. I want to go by sequence in column F and sort other values accordingly. I need to manually type values in column F and in columns A to E as well.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,309
Messages
5,641,448
Members
417,209
Latest member
Agbarker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top