Re: VLOOKUP question
- From: "Don Guillett" <donaldb@xxxxxxx>
- Date: Thu, 17 Nov 2005 11:12:00 -0600
this is an array formula so must be entered/edited with ctrl+shift+enter
=MAX(IF(B1:B7="abc",C1:C7))
--
Don Guillett
SalesAid Software
donaldb@xxxxxxx
"rmellison" <rmellison@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04A996DE-B34B-4C9A-B796-89DD819AA511@xxxxxxxxxxxxxxxx
> Hi there Excel Gurus.
>
> I have a long list of data in two columns, and I want to write a formula
> on
> a different *** that finds the maximum of all values in column 2 that
> correspond to a given character string in column 1. For example.
>
> abc 3
> bcd 5
> cde 7
> abc 2
> def 4
> abc 4
> bcd 8
>
> I need to find the maximum of all values corresponding to abc (ie. 4) or
> to
> bcd (ie. 8) where I can enter the required string in a cell next to my
> formula cell. Have tried filtering but if you use =MAX( ) on the visible
> date
> it still uses the entire range.
>
> Hope you get what I mean. Thanks in advance.
.
- Prev by Date: Re: Rounding
- Next by Date: Re: How do I link cells, *** to ***, to recognize row deletion
- Previous by thread: Wild Characters in "IF" function
- Next by thread: Re: VLOOKUP question
- Index(es):
