Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract single occurence of order number from list
I have a 5000+ number list within a spreadsheet made up of 6 digit order
numbers, if an order numbers 'order' contained multiple items then the number appears x times in the list, once per item. I want to pivot the data, but need to extract a list of order numbers with their relevant data from the other columns, at the moment the only way (to me) seems to be to sort by order number and manually delete the duplicate occurences. example of data below, actual is 20+ columns wide 246335 14/06/2007 F170656 246341 14/06/2007 F170925 246526 15/06/2007 F170770 246551 15/06/2007 F170785 246620 18/06/2007 F170993 246627 18/06/2007 F171022 246628 18/06/2007 F171023 246637 18/06/2007 F170699 246689 18/06/2007 F170785 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 246690 18/06/2007 F171105 ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create and extract a random order from list in Excel? | Excel Discussion (Misc queries) | |||
Assign a number each letter on list compounding occurence @ each e | Excel Worksheet Functions | |||
List all contracts that relate to a single part number | Excel Discussion (Misc queries) | |||
Build a single order sheet from a multiple page material list. | Excel Discussion (Misc queries) | |||
how to count occurence of numbers separated by , in a single cell | Excel Worksheet Functions |