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 |
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 . |
All times are GMT +1. The time now is 10:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com