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