M
Matzon
I have soccer results on my spreadsheet simpified something like: Column A
Date ,Col. B Home Team ,Col. C Visitor Team, Col. D Home goals and Col.
E Visitor goals.
One sheet may have many hundreds of rows. Rows are sorted first by date then
by name of the team. Until now I have managed to solve my problems using
properties in Excel databases and Excel functions.
Now I try to count average of goals for any team. For example , get
average of last four home games for Arsenal. The result should be in same
sheet in a new column, say Column F. I have used laborious method to
sort by team name in a different sheet and copying the results back to my
original sheet. Updating this kind of system is very slow.
Is there any possibilities to use e.g. nested fuctions to pick certain
amount of rows with a certain criteria (like Arsenal) and to make statistical
operations for them? Do I have to make a separate VBA-macro for updating?
Or do I have to change to a real Database? Last alternative is sure to
work, but many other arrengement would take me several months to carry out.
Any kind of suggestions to solve this problem would be great!
Date ,Col. B Home Team ,Col. C Visitor Team, Col. D Home goals and Col.
E Visitor goals.
One sheet may have many hundreds of rows. Rows are sorted first by date then
by name of the team. Until now I have managed to solve my problems using
properties in Excel databases and Excel functions.
Now I try to count average of goals for any team. For example , get
average of last four home games for Arsenal. The result should be in same
sheet in a new column, say Column F. I have used laborious method to
sort by team name in a different sheet and copying the results back to my
original sheet. Updating this kind of system is very slow.
Is there any possibilities to use e.g. nested fuctions to pick certain
amount of rows with a certain criteria (like Arsenal) and to make statistical
operations for them? Do I have to make a separate VBA-macro for updating?
Or do I have to change to a real Database? Last alternative is sure to
work, but many other arrengement would take me several months to carry out.
Any kind of suggestions to solve this problem would be great!