find highest values

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

hi,
i have 2 sets of data on a spreadsheet both contain data about the
number of occurrence a machine went into fault

ie.
grid 1
OP Occurr
op 10 7
Op 30 9
Op 40 3

grid 2
OP Occurr
op 10 9
Op 30 4
Op 40 14

what i want to do is compare the two sets of data and which ever is
the greater place in another grid

Result
OP Occurr
op 10 9
Op 30 9
Op 40 14

what the best way of doing this ?


thanks

kevin
 
=MAX(VLOOKUP(J2,grid1,2,FALSE),VLOOKUP(J2,grid2,2,FALSE))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks for reply Bob

I have a problem though

1. the order the faults are reported in grid 1 may not be the same as
grid 2

2 due to the fact that grid1 is imported from access there may not be
the same number of reported ops
so targeting one cell for the op is failing
 
Back
Top