-1

I receive a fuel consumption report each month. The report contains up to 600 vehicles, during the reporting period the same vehicle could fill up only once or multiple times resulting in duplicate entries with assending odometer readings.

I need to generate a list with two columns as below but I want remove duplicate vehicles (Rego No) and display the highest ODO/KM reading.

REGO NO   ODO/KMS          result
ccd500    58000            ccd500   60000
hhg900    34000            hhg900   36000
ccd500    58500            ccd800   58000
hhg900    34500            ccd900   35000
ccd800    58000
ccd900    35000
ccd500    60000
hhg900    36000
user3474533
  • 13
  • 1

1 Answers1

0

With data in A2 thru B9 use array formulas like:

=MAX(IF($A$2:$A$9="ccd500",$B$2:$B$9,))

Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key.

Gary's Student
  • 95,722
  • 10
  • 59
  • 99