Array/Largest value, help!

[gbrian]

Hello,

I have two columns, description and count.

I need to search for the largest count value where description contains a specified string.

Example, the largest count (column B) where column A contains 'Testing 1'

Seems somewhat simple but I am having excel block!

Thanks.

 

[gbrian]

Sorry I forgot to add, I want to return the description and not the count value.

 

[xlbo]

You may have a problem here. Whilst it is relatively easy to get the max amount for a specified escription, what if other descriptions have the same count ?

You will need to use the count to identify the row to return but you could have multiple rows with the same no. but a different description

I would be tempted to write a custom function in VBA for this...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question