These two teams here are a forthcoming fixture, I´d like to search the range (Range A78:L2000) to find every time they have played each other and then in the columns R to V enter the data for each previous meeting of
home team score
away team score
Note I require all instances for
Ravenna v Valentia and
Valentia v Ravenna
In Range W4:Y6 I require the last three times that Ravenna have played at home (Range A78:L2000) , all i require is the same row data from Col L "Std Dev" and the Data from Col N.
In Range W7:Y9 I require the last three time that Ravenna have played away from home, again all i require is the data from Col L "Std dev" and the Data from Col M.
I would like the above repeating for Valentia in the ranges W10:Y12 and W13:Y15.
Please not that the Range A78:L2000 is in date order, oldest first and that the data I require will be at the bottom of the range (some of which is unpopulated at the moment but won´t always be)
12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön
Hi Sir! **Your file IS FINISHED!!!** See PM. Highly experienced in Excel macros, formulas and gambling! Please Check my credentials. Let me help. Thanks in advance!