Highest Value

[sasuke]

How to determine where is the highest value in this example using vba?
The answer must be a = 50 and b = 45

a 2
b 4
a 1
a 3
a 10
a 0
a 50
b 45

 

[Nebu]

Hi:

As I said before use Google search its not that difficult trust me

http://www.globaliconnect.com/excel...e-in-range-with-vba-excel&catid=79&Itemid=475

Thanks

 

[sasuke]

Hi:

As I said before use Google search its not that difficult trust me

http://www.globaliconnect.com/excel...e-in-range-with-vba-excel&catid=79&Itemid=475

Thanks

This only give the highest number in the entire range, what if i just want to see the highest number of A and B?

 

[Nebu]

Hi:

As suggested use the Google to search what you are looking for. The code you are asking for is not a unique one there are lot of results available on web. Do not expect forum members to conduct search for you an "spoon-feed" you the solution.
Thanks

 

[sasuke]

Hi:

As suggested use the Google to search what you are looking for. The code you are asking for is not a unique one there are lot of results available on web. Do not expect forum members to conduct search for you an "spoon-feed" you the solution.
Thanks

Ill already use the google but i cant find any solution for this, But thanks for the help

 

[Nebu]

Hi:

A simple search gave me these

http://answers.microsoft.com/en-us/...a/8c0fd210-6ef7-4607-aca2-f886eaf94cc7?auth=1

http://stackoverflow.com/questions/2497411/excel-maxif-function-or-emulation

http://www.vbaexpress.com/forum/archive/index.php/t-12754.html

Do the same for MINIF.
But I am not sure why you want a VBA solution here when excel can already calculate it using formulas.

Thanks

 

[sasuke]

Hi:

A simple search gave me these

http://answers.microsoft.com/en-us/...a/8c0fd210-6ef7-4607-aca2-f886eaf94cc7?auth=1

http://stackoverflow.com/questions/2497411/excel-maxif-function-or-emulation

http://www.vbaexpress.com/forum/archive/index.php/t-12754.html

Do the same for MINIF.
But I am not sure why you want a VBA solution here when excel can already calculate it using formulas.

Thanks

Thanks for this Mam, but i want in vba code to do this

 

[sasuke]

Hi:

As I said before use Google search its not that difficult trust me

http://www.globaliconnect.com/excel...e-in-range-with-vba-excel&catid=79&Itemid=475

Thanks

Ill Already knew the codes. thanks for the help Nebu