Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find occurance of a part number?
I have a computer sales program that will output an excel spredsheet that
contans all of my computer generated 10 digit part numbers. Part#'s are generated by options selected at time of order so there are literly thousands of different part#'s The part numbers are listed in two colums depending on if it was bought or sold. Each row transaction is loged with a date and time the order was generated. The row data and colum headers a Date - Time (am/pm) - sold - purchase - customer - vendor 5/20/2009 - 11:00 am - 10digits - 10digits - text - text 5/19/2009 - 3:09 pm - 10digits - 10digits - text - text Is there a function - formula or someway to search this sheet and find the (by Date/Time) first and last time a part number was purchsed and also the first and last time (by Date/Time) it was sold? I would like to pull this info into a seperate worksheet or tab. I would even be happy with somthing as simple as a way get a list that would just pull the entire row data into the worksheet for each of the different part#'s, first and last occurance. Thanks for any help. I am at a total loss! Premachine, (Mark) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find occurance of something from 2 creterion | Excel Discussion (Misc queries) | |||
Find the next occurance | Excel Worksheet Functions | |||
Macro to find last occurance | Excel Discussion (Misc queries) | |||
Find the 1st occurance of a number in a cell | Excel Worksheet Functions | |||
Find next occurance | Excel Discussion (Misc queries) |