picks largest value

[andre1986]

Hi,

I want to write a sub that matches the largest value with a name and presents the name and value in a message.

I have values in M5:M15 and Names in I5:I15

How would I do this?

Best regards,
André

[XOR LX]

Hi.

Please Login or Register  to view this content.

though you don't say which return should be preferred if the maximum value occurs more than once.

Regards

[andre1986]

Hi, thanks!

Can it pick both the largest values and the names in that case?

[XOR LX]

What if there're more than 2?

Regards

[andre1986]

haha, you are right. All the largest values if they are the same

[XOR LX]

Please Login or Register  to view this content.

Regards