Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting two columns (again)
Hi all, I searched but couldnt find an answer to this problem.
I have a lot of items that are serial numbered, the portable scanner drops the serial numbers into column A with no problem at all. Then I need pass or fail to show in column F. This is no problem at all either (because I learnt from previous threads). My problem is that the items are scanned numerically randomly and passed or failed, but when I sort column A into ascending numerical value, column F value doesnt move to the new row that the column A value moves to. EG, A B thru E F 2 details Pass 1 details Fail and when I sort it all I end up with A B thru E F 1 details Pass 2 details Fail instead of A B thru E F 1 details Fail 2 details Pass How do I make the result in column F follow/sort with that of column A???? This is the smartest forum I have encountered for a long time, Im sure someone can help. Thankyou -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200604/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting two columns (again)
What formulas do you have in columns B thru F ?
-- AP "outwest via OfficeKB.com" <u19594@uwe a écrit dans le message de news:5ee8c7736fb52@uwe... Hi all, I searched but couldnt find an answer to this problem. I have a lot of items that are serial numbered, the portable scanner drops the serial numbers into column A with no problem at all. Then I need pass or fail to show in column F. This is no problem at all either (because I learnt from previous threads). My problem is that the items are scanned numerically randomly and passed or failed, but when I sort column A into ascending numerical value, column F value doesnt move to the new row that the column A value moves to. EG, A B thru E F 2 details Pass 1 details Fail and when I sort it all I end up with A B thru E F 1 details Pass 2 details Fail instead of A B thru E F 1 details Fail 2 details Pass How do I make the result in column F follow/sort with that of column A???? This is the smartest forum I have encountered for a long time, Im sure someone can help. Thankyou -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200604/1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting two columns (again)
Hi Ardus,
B thru E just has details of size, shape etc that are sourced from another sheet, sheet 2 in this case, it is called editor. The formulas in sheet 1 B thru E read like Column B =editor!(b2) Column C =editor!(c2) etc The results in B thru E will auto sort themselves as Column A is sorted in ascending value. The result in column F (pass or fail) is input by the barcode scanner after the operator scans the serial number and assesses the item. I basically need to "lock" A and F together so they move as one. Thanks for taking an interest outwest wrote: Hi all, I searched but couldnt find an answer to this problem. I have a lot of items that are serial numbered, the portable scanner drops the serial numbers into column A with no problem at all. Then I need pass or fail to show in column F. This is no problem at all either (because I learnt from previous threads). My problem is that the items are scanned numerically randomly and passed or failed, but when I sort column A into ascending numerical value, column F value doesnt move to the new row that the column A value moves to. EG, A B thru E F 2 details Pass 1 details Fail and when I sort it all I end up with A B thru E F 1 details Pass 2 details Fail instead of A B thru E F 1 details Fail 2 details Pass How do I make the result in column F follow/sort with that of column A???? This is the smartest forum I have encountered for a long time, Im sure someone can help. Thankyou -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200604/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting alpha in two columns | Excel Discussion (Misc queries) | |||
Sorting columns with expressions | New Users to Excel | |||
sorting data across multiple columns | Excel Discussion (Misc queries) | |||
Columns | Excel Discussion (Misc queries) | |||
Sorting rows AND columns | Excel Worksheet Functions |