Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula For Sorting Part Numbers
I have Excel 2000.
Sheet1 of my workbook has: * Part numbers in column D * Primary bin location in column F * Secondary bin location(s), if any, in columns I, J, K, L * Each part number and corresponding bin location(s) are listed on the same row and there are no duplicate part numbers I need help with a formula (to be inserted in Sheet2) that does the following: * List all the part numbers and bin locations (primary + secondary) if there is an "X" in column AB of any part number listed in Sheet1 * All the information for a part number should be on a single row * The list should be sorted by primary bin location I am hoping that this can be accomplished with a formula rather than with a macro. Thanks in advance for your help. -- tb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula For Sorting Part Numbers
This sounds like a job for the Autofilter, rather than for a formula.....
Just do Data Filter Autofilter and click on the arrow on column AB and select the "X". This will filter all rows that have an X in column AB. You can then copy and paste the data over to your other sheet. Vaya con Dios, Chuck, CABGx3 "tb" wrote: I have Excel 2000. Sheet1 of my workbook has: * Part numbers in column D * Primary bin location in column F * Secondary bin location(s), if any, in columns I, J, K, L * Each part number and corresponding bin location(s) are listed on the same row and there are no duplicate part numbers I need help with a formula (to be inserted in Sheet2) that does the following: * List all the part numbers and bin locations (primary + secondary) if there is an "X" in column AB of any part number listed in Sheet1 * All the information for a part number should be on a single row * The list should be sorted by primary bin location I am hoping that this can be accomplished with a formula rather than with a macro. Thanks in advance for your help. -- tb . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting part numbers | Excel Discussion (Misc queries) | |||
Formula For Labeling Part Numbers | Excel Worksheet Functions | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Sorting Alpha Numeric Part 2 | Excel Discussion (Misc queries) | |||
FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) |