Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COMPARE DATA AND LIST SMALLEST AND LARGEST ENTRY BY UNIT
I have a large equipment database containing the equipment ID, the
odometer/hour reading, and the date it was taken. The list contains multiple entries for each piece of equipment. I wish to sort through the list and extract the lowest odometer/hour reading and extract the highest odometer/hour reading for each piece of equipment. Any assistantance will be appreciated. |
#2
|
|||
|
|||
hi,
use formulas. Max and Min =MAX(A1:A2000) and =MIN(A1:A2000) Adjust the the range to fit your data. Regards FSt1 "Dwain A, louisiana" wrote: I have a large equipment database containing the equipment ID, the odometer/hour reading, and the date it was taken. The list contains multiple entries for each piece of equipment. I wish to sort through the list and extract the lowest odometer/hour reading and extract the highest odometer/hour reading for each piece of equipment. Any assistantance will be appreciated. |
#3
|
|||
|
|||
Let me be more specific. I want to extract from that list the equipment
ID(only once for each piece) and then the only lowest meter odometer reading and highest reading for all of the entries made for each piece. "FSt1" wrote: hi, use formulas. Max and Min =MAX(A1:A2000) and =MIN(A1:A2000) Adjust the the range to fit your data. Regards FSt1 "Dwain A, louisiana" wrote: I have a large equipment database containing the equipment ID, the odometer/hour reading, and the date it was taken. The list contains multiple entries for each piece of equipment. I wish to sort through the list and extract the lowest odometer/hour reading and extract the highest odometer/hour reading for each piece of equipment. Any assistantance will be appreciated. |
#4
|
|||
|
|||
Dwain,
Try: =SUMPRODUCT( MAX( (idrange=productid) *(odrange) ) ) =1 / SUMPRODUCT( MAX( (idrange=productid) * 1/(odrange) ) ) where "idrange" is the range of cells with the product IDs, "odrange" is the corresponding range with the odometer readings, and "productid" is the ID you want to look up. Eric "Dwain A, louisiana" wrote: Let me be more specific. I want to extract from that list the equipment ID(only once for each piece) and then the only lowest meter odometer reading and highest reading for all of the entries made for each piece. "FSt1" wrote: hi, use formulas. Max and Min =MAX(A1:A2000) and =MIN(A1:A2000) Adjust the the range to fit your data. Regards FSt1 "Dwain A, louisiana" wrote: I have a large equipment database containing the equipment ID, the odometer/hour reading, and the date it was taken. The list contains multiple entries for each piece of equipment. I wish to sort through the list and extract the lowest odometer/hour reading and extract the highest odometer/hour reading for each piece of equipment. Any assistantance will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking cells largest to smallest | Excel Discussion (Misc queries) |