Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting cells according to all cells in column A
Let us say I have a list of over 4000 case numbers in column A. In the other
columns I also have case numbers but much less than in the column A, an average of 700 and a maximum of 2000. The idea is to sort the cell values according to the values in the first column. So what I want in my spreadsheet is to sort the cell values in colums B, C, D etc according to the list and case numbers in column A. I have tried to make a custom list, but it only reads about 180 cell values in a column. I also dont want to sort the whole sheet column by column. I tried several things in VBE but it doesnt seem to do the trick. Is it possible that I am overlooking something or is it just not possible. |
#2
|
|||
|
|||
Go to: Data - Sort, make sure columns A through D are selected and sort on
column A. -- Regards, David Billigmeier "Jootje" wrote: Let us say I have a list of over 4000 case numbers in column A. In the other columns I also have case numbers but much less than in the column A, an average of 700 and a maximum of 2000. The idea is to sort the cell values according to the values in the first column. So what I want in my spreadsheet is to sort the cell values in colums B, C, D etc according to the list and case numbers in column A. I have tried to make a custom list, but it only reads about 180 cell values in a column. I also dont want to sort the whole sheet column by column. I tried several things in VBE but it doesnt seem to do the trick. Is it possible that I am overlooking something or is it just not possible. |
#3
|
|||
|
|||
Ehh, yes figured that out already, but I want the cell values in column B
through D to match with the cell value or rownumber in column A. Like this: BEGIN RESULT A B C D A B C D 1 2 1 3 1 1 2 3 2 4 2 2 2 3 5 4 5 3 3 3 4 4 4 4 5 5 5 5 So column A has the 'reference' data. Tried Lookup function, which didn't work. "David Billigmeier" wrote: Go to: Data - Sort, make sure columns A through D are selected and sort on column A. -- Regards, David Billigmeier "Jootje" wrote: Let us say I have a list of over 4000 case numbers in column A. In the other columns I also have case numbers but much less than in the column A, an average of 700 and a maximum of 2000. The idea is to sort the cell values according to the values in the first column. So what I want in my spreadsheet is to sort the cell values in colums B, C, D etc according to the list and case numbers in column A. I have tried to make a custom list, but it only reads about 180 cell values in a column. I also dont want to sort the whole sheet column by column. I tried several things in VBE but it doesnt seem to do the trick. Is it possible that I am overlooking something or is it just not possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
removing blank cells from a column | Excel Discussion (Misc queries) | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |