mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
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)
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)