Hello Friends! Hope all is well.
Please open the attachment.
I want your kind help with a formula, that will show the highest month.
1. in G2 (from the range B).
2. G2 result is based on the year choice made in F2.
All the Best and thank you very much in advance.
In G2, try this:
=INDEX(B:B,MATCH(F2,A:A,0)+COUNTIF(A:A,F2)-1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Great, thank you very much!
The formula is working when there are no repetitions, however, I added more data (occurrences).
And the formula is now not working; Can you please help with the formula?
thanks again!
Try
in G2
=INDEX($I$2:$I$13,MAX((MONTH($B$3:$B$29&0)*($A$3:$A$29=$F$2))))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
I2:I13 has list of months (Jan, Feb )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks