Can someone explain to me why when I try to sort Column 9 from Newest to Oldest (or any type of sort) it causes the values to become mixed up. For example Column 1 is a lot # and Column 2 is the manufacture date. Column 9 is a completion date. When I sort them by column 9 values that are supposed to correspond to each other get mixed up. I have included an example of that as well. Why does this happen?
BEFORE SORT
AFTER SORT
BEFORE SORT
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
41 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | ||
42 | 147 | 26-May | Salamini | * | 10507 | 6514 | 20 | 10 | 7-Jun | ||
43 | 140 | 19-May | Col Reg It Dry | * | 64253 | 42407 | 69 | 35 | 9-Jun | ||
44 | 147 | 26-May | Col Lite | * | 15334 | 10427 | 13 | 7 | 13-Jun | ||
45 | 147 | 26-May | Prem Genoa | * | 9410 | 6022 | 9 | 5 | 23-Jun | ||
46 | 147 | 26-May | PG Bulk | * | 1171 | 749 | 2 | 1 | 23-Jun | ||
47 | 153 | 1-Jun | Salamini | * | 22346 | 13855 | 39 | 20 | 13-Jun | ||
48 | 154 | 2-Jun | Col Reg It Dry | * | 64136 | 42330 | 68 | 34 | 23-Jun | ||
49 | 155 | 3-Jun | Col Lite | * | 15423 | 10488 | 16 | 8 | 21-Jun | ||
50 | 155 | 3-Jun | Buss Lite | * | 21425 | 14569 | 22 | 11 | 21-Jun | ||
Sheet |
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
41 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | ||
42 | 147 | 26-May | Salamini | * | 10507 | 6514 | 20 | 10 | 7-Jun | ||
43 | 140 | 19-May | Col Reg It Dry | * | 64253 | 42407 | 69 | 35 | 9-Jun | ||
44 | 147 | 26-May | Col Lite | * | 15334 | 10427 | 13 | 7 | 13-Jun | ||
45 | 153 | 3-Jun | Salamini | * | 22346 | 13855 | 39 | 20 | 21-Jun | ||
46 | 155 | 26-May | Col Lite | * | 15423 | 10488 | 16 | 8 | 23-Jun | ||
47 | 155 | 2-Jun | Buss Lite | * | 21425 | 14569 | 22 | 11 | 23-Jun | ||
48 | 147 | 1-Jun | Prem Genoa | * | 9410 | 6022 | 9 | 5 | 13-Jun | ||
49 | 147 | 3-Jun | PG Bulk | * | 1171 | 749 | 2 | 1 | 21-Jun | ||
50 | 154 | 26-May | Col Reg It Dry | * | 64136 | 42330 | 68 | 34 | 23-Jun | ||
Sheet |