gosh, you are absolutely amazing. Thank you so so much. I really appreciate the help!
hey, when you have time could you please let me know how I can modify the formula to fit a smaller range.. It's not picking up the maximums for some of the other data series =[
I adjusted the filter length. I have no further suggestions.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
thank you thank you!
it's perfect =)
The formula in F8 and down can be (should be) simplified to
=IF(AND(SUMPRODUCT(Filter*E4:E12)>F$2, E8=MAX(E6:E10), E8>E7), E8, NA())
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks