Re: VLOOKUP question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I should have told you that it didn't work with full columns.

--
Don Guillett
SalesAid Software
donaldb@xxxxxxx
"rmellison" <rmellison@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E522414D-0931-4F73-8B4A-BAA1932C5553@xxxxxxxxxxxxxxxx
>I had tried that previously, array-entered too, but had got #NUM as my
>error
> message. Problem was that I was using the entire column as the reference
> (B:B
> etc) so it was including the header (which is a charater string). Changed
> the
> reference and hey presto! Many thanks for your help.
>
> "Don Guillett" wrote:
>
>> 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.
>>
>>
>>


.

Quantcast