Re: find highest values

Giganews Newsgroups
Subject: Re: find highest values
Posted by:  Bob Phillips (bob.N…@somewhere.com)
Date: Fri, 18 Jul 2008

=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" <kevcar…@btinternet.com> wrote in message
news:9e09ab79-e02b-4848-8349-0d58a18b81…@w8g2000prd.googlegroups.com...
> 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

In response to

find highest values posted by kevin carter on Fri, 18 Jul 2008