Hello i have some month names across A:E January (merged a1:b1) February (c1:d1) etc now i need a code that will look in b:d:f etc row 2 to 100 and see which is the largest value found and then give the month of the largest value found and if there is a tie then give me that month also this should be displayed in a msgbox with the value If i had 60 as the largest value found for feb and may then msgbox (Largest amount (value) to be given in feb and may)
This question generated 16 answers. To proceed to the answers, click here.
This thread is current as of October 12, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel