COMPARE DATA AND LIST SMALLEST AND LARGEST ENTRY BY UNIT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
hi,
use formulas. Max and Min

=MAX(A1:A2000) and =MIN(A1:A2000)

Adjust the the range to fit your data.

Regards
FSt1
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to figure difference in odometers 1
Index/Match for the largest value that matches 1
date in merged cells 4
Formula Field or Query Field 4
Select list box entries in multiple rows? 2
List Bldg # according to sum of hours and bldg rank.... 3
Newb looking for data binding help 3
Filling in a column with text 3

Back
Top