Log In
Register
Home
June 26, 2016
Offline
Hello everyone My name is Maurizio and my problem is this:
on the Excel sheet called (Calculations) I have some results that I have inserted at the hands of the football league matches (English)
Now I would like to: for example, in columns J3: L500 you have to enter a formula that tells me how many games you have won, tied and lost the team that plays at home in the last 5 games played.
Bearing in mind that the data must be taken from the sheet (Database_Results)
that I manually enter All
post thanks Greetings from A.Maurizio
VIP
Trusted Members
June 25, 2016
Offline
Hi Maurizio
I have added a helper column to your data to get the reverse sequence and count only those between 1 and 5 (last 5 games).
You will need to modify it to suit your Calcoli sheet.
Hope this helps.
Sunny
June 26, 2016
Offline
Hi SunnyKow
You're nothing short of Fantastic!
I do not deny that I tried and tried again to even try to get close to your work, but without success.
For so many So many Congratulations on my part.
Ahora, that works great!
Greetings Sinceri from A.Maurizio
VIP
Trusted Members
June 25, 2016
Offline
Hi Maurizio
You are welcome
Sunny
VIP
Trusted Members
June 25, 2016
Offline
Hi Maurizio
Attached is another method using PivotTable.
Sunny
June 26, 2016
Offline
Hi SunnyKow
Like Sepre Good blood Never mind!
As this your work is fantastic
I would like to be able to work like this with Pivot tables, but I never understood sincerely speaking, how to create all of this:
In Practice I miss the whole theoretical part of how to develop this type of mask.
Anyway, thank you, Infinite Veramente
(p.S) I reiterate the fact that: "If there were no I would have to invent you"
Again Thank you and Happy Weekend from A.Maurizio
VIP
Trusted Members
June 25, 2016
Offline
Hi Maurizio
Thanks for your kind words.
I would highly recommend that you learn Pivot Table as it is incredibly powerful and versatile tool.
There are a lot of tutorials on Pivot Tables here at MOTH. https://www.myonlinetraininghu.....ivot-table
You can start from there and then later maybe take up a course in Pivot Table. It will be worth your while.
Sunny
1 Guest(s)
