How to find the last six football results for any team from previous results?
Hello,
Would you mind helping me, how to find last six mach results from data.say Arsenal and Astonvilla playing next week and I would like to find the previous results for both team that include Home and away matches,how can I do it? Is there any excel function to get results?
See attached file for more information,thank you.
its not exactly what your after but its easy to replicate and manage
using a helper column and autofilter
you select 2 teams you are after in the drop down menu and then hit reapply (keyboard shortcut Ctrl+Alt+L)
will give you the team you want to look at
Attachment 253621
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Using your posted workbook...
Just to make my proposed solution more transparent, I used helper columns.
These regular formulas begin the list of matching row numbers for the last 6 rows containing Arsenal and Aston Villa
Formula:
Please Login or Register to view this content.
Copy those formulas down through Row_11
This formula begins the list of HOME, VISITOR, Home score, and Visitor score for Arsenal
Formula:Please Login or Register to view this content.
Copy that formula across and down through N11
This formula begins the list of HOME, VISITOR, Home score, and Visitor score for Aston Villa
Formula:Please Login or Register to view this content.
Copy that formula across and down through R11
Is that something you can work with?
hi Ron,
thanks for your help, unless someone else improve it, that is nearest to my solution.by the way i changed your last formula
from "INDEX(B:B,$S6)to INDEX(a:a,$S6)" otherwise does not give the second team.any how thanks a millon for your help.
sem
Humdingaling,
sorry for not replying earlier but i prefer Ron's solution, because more dynamic .I created drop down list in "M2 and N2" when you change the teams names the result change with it,
and thats how i want it.Anyhow thanks for your time very much appreciated.
hi RON...great code working fine...but lets say...the code is bringing up the last 5 games but they may not have been played yet with no results...how can we fix this? because if deleting the results of column "C" and "D" the last 5 games remain the same and we only want the las 5 played...IF coluns "C" and "D" have no result yet dont show in last 5.
many thanks.
Last edited by paroduso33; 02-25-2023 at 02:36 PM.
Originally Posted by paroduso33
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Also this thread is 10 years old and Ron has not posted here for 3 years.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks