P
Premachine
Accounting is giving me a Excel spreadsheet file of the issuance of part #'s.
But the file is so big I can not get the data I am looking for out of it.
I can filter the worksheet and get a listing of all the different part #'s
but there is more than 10 thousand of them.
I need a way to sort or filter the part numbers out that would also include
all the row data that is attached to the part #'s.
Example:
A B C D
E F
1- Date - Time - Part# - Secondary# - Text - Text
2- 5/20/09 - 3:45 PM - 1234567890 - 1234567890 - comment - comment
3- 5/18/09 - 1:25 AM - 1234567890 - 1234567890 - comment - comment
4- 5/17/09 - 1:05 AM - 1234567890 - 1234567890 - comment - comment
I need to pull the first and last occurance of each part # by date and time.
For me this is a monster file, +250K of rows that contain the above info.
Is this possible?
HELP would be much appreciated!
Thanks, Mark
But the file is so big I can not get the data I am looking for out of it.
I can filter the worksheet and get a listing of all the different part #'s
but there is more than 10 thousand of them.
I need a way to sort or filter the part numbers out that would also include
all the row data that is attached to the part #'s.
Example:
A B C D
E F
1- Date - Time - Part# - Secondary# - Text - Text
2- 5/20/09 - 3:45 PM - 1234567890 - 1234567890 - comment - comment
3- 5/18/09 - 1:25 AM - 1234567890 - 1234567890 - comment - comment
4- 5/17/09 - 1:05 AM - 1234567890 - 1234567890 - comment - comment
I need to pull the first and last occurance of each part # by date and time.
For me this is a monster file, +250K of rows that contain the above info.
Is this possible?
HELP would be much appreciated!
Thanks, Mark