Hi. I am a big rugby league fan here in the UK and I have an Excel workbook of all the Super League results since 1996. On a seperate worksheet I have some formulas that work out how many times 2 teams have played each other home and away and how many wins each etc.
My problem is on the max and min attendance. I cannot figure out the corrent way to do the formula. I am not sure if i have to join 2 maxifs together. I did try but got a weird result.
My maxifs is correct if team 1 is home and team 2 is away but i need to add when team 2 is the home team and team 1 is the away team.
I have created a very basic sample cut down excel file to attach as my main file has nearly 5,000 rows on the main sheet.
Thank you in advance for any help given.
Dave
I believe you need the MAX of two MAXIFS and the MIN of two MINIFS. I've added them to your file. Note that I prefer to work with structured tables (also added). It avoids the need to create/maintain named ranges. I trust you can adapt the formulas in case you prefer to keep your own set-up.
Please see attached. If this is not what you meant, please come back here and indicate what the answers should be.
@Riny van Eekelen
Thank you for the reply. I did forget to say that my original file is in a table format with named ranges.
I will have a look at your solution and keep you updated
Dave
Have sorted the solution. Your solution wasnt exactly what i needed but it did help to alert me to a basic error. I never thought of putting the 2 MAXifs in a MAX but my error was i seperated the 2 MAXIFS with a * instead of a , (comma)
Thank you again for your help
Dave
