find highest values

[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

 

[Bob Phillips]

=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)

 

[kevin carter]

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

 

[kevin carter]

sorted problem 1 , i sorted them in the access dbase