User

Welcome, Guest. Please login or register.
Did you miss your activation email?
March 04, 2026, 07:13:27 pm

Login with username, password and session length

Links


Join the VSC


FSA logo

Shortcuts
« previous next »
Pages: [1]   Go Down

Author Topic: Any MS Excel wizards on here?  (Read 972 times)

0 Members and 1 Guest are viewing this topic.

GazLaz

  • Forum Member
  • Posts: 15257
Any MS Excel wizards on here?
« on January 10, 2020, 08:25:50 am by GazLaz »
I am wanting to draw information from a list of football results. The games are listed under the headings DATE HOME GOALS AWAY GOALS. I know the formula to sum total goals of a selected team under certain criteria BUT I don’t know how to set the criteria as the last X amount of games using the date as a reference.

Anyone any idea how to do this?
Logged


(want to hide these ads? Join the VSC today!)

Ldr

  • Forum Member
  • Posts: 3556
Re: Any MS Excel wizards on here?
« Reply #1 on January 10, 2020, 08:51:13 am by Ldr »
You need to use an Offset formula. Google offset and mr excel
Logged

GazLaz

  • Forum Member
  • Posts: 15257
Re: Any MS Excel wizards on here?
« Reply #2 on January 10, 2020, 09:32:33 am by GazLaz »
Quote from: Ldr on January 10, 2020, 08:51:13 am
You need to use an Offset formula. Google offset and mr excel

Thanks for the advice!
Logged
Pages: [1]   Go Up
« previous next »
 
TinyPortal © 2005-2012