Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 23rd 09, 07:49 AM posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 12
Default 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   Report Post  
Old December 23rd 09, 06:37 PM posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,998
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting part numbers fitzsociety Excel Discussion (Misc queries) 2 June 27th 08 11:59 PM
Formula For Labeling Part Numbers tb Excel Worksheet Functions 3 November 7th 07 06:27 AM
Replace Old Part Numbers with New Part Numbers in a Macro. Jeffery Keown Excel Discussion (Misc queries) 5 October 17th 06 03:45 PM
Sorting Alpha Numeric Part 2 CS Project Man Excel Discussion (Misc queries) 3 December 21st 05 06:56 PM
FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS ANDY CALLAGHAN Excel Discussion (Misc queries) 1 March 6th 05 10:35 PM


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017