Massimo Scola
asked on
How do I calculate the max from two arrays with a year value?
Hello
I have asked a similar question before and need some additional help:
As you can see, there are dates in column A and this time, I'd like to display the favourite shop for, lets say, 2011. What do I need to change to the original formula of
Thanks
Massimo
mode-by-year.xlsx
mode-by-year.PNG
I have asked a similar question before and need some additional help:
As you can see, there are dates in column A and this time, I'd like to display the favourite shop for, lets say, 2011. What do I need to change to the original formula of
=INDEX(Shop,MODE(IF(Customer=F2,IF(Shop<>"",MATCH(Shop,Shop,0)*{1,1}))))
Thanks
Massimo
mode-by-year.xlsx
mode-by-year.PNG
ASKER
Hi
I've entered the formula but I get empty cells .. I've attached the spreadsheet.
Did I miss something?
Massimo
mode-by-year-problem.xlsx
I've entered the formula but I get empty cells .. I've attached the spreadsheet.
Did I miss something?
Massimo
mode-by-year-problem.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello and sorry for my late reply<br />Thanks a lot, it works now.<br /><br />Massimo
Open in new window