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


.