ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula For Sorting Part Numbers (https://www.excelbanter.com/excel-worksheet-functions/251726-formula-sorting-part-numbers.html)

tb

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



CLR

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