find highest values

Giganews Newsgroups
Subject: find highest values
Posted by:  kevin carter (kevcar…@btinternet.com)
Date: Fri, 18 Jul 2008

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

Replies