Hi,
I have a spreadsheet with daily share prices on (automatically pulled in). See pic below (there are obviously more data entires, I've just hidden rows to make the pic easier to read). Let's call this Table 1.
This is just a continually running entry, I just extend the table by 100 or so rows every time I need it to carry on (and hide rows via a filter based on length of time).
Now at the moment I have a separate table (Table 2) that I enter the average share price in for each month. Picture below (values removed)
I was wondering if someone could help me work out a formula that would pull in the average share price for each month, and that would run automatically?
I'm guessing it would need to use something along the lines of if Table1 A Month / Table 1 A Year = Table 2 A Month / Table 2 A Year, then some how pull the average share price for the 30 or so shares that had the same Month and Year…
Thanks in advance
I have a spreadsheet with daily share prices on (automatically pulled in). See pic below (there are obviously more data entires, I've just hidden rows to make the pic easier to read). Let's call this Table 1.
This is just a continually running entry, I just extend the table by 100 or so rows every time I need it to carry on (and hide rows via a filter based on length of time).
Now at the moment I have a separate table (Table 2) that I enter the average share price in for each month. Picture below (values removed)
I was wondering if someone could help me work out a formula that would pull in the average share price for each month, and that would run automatically?
I'm guessing it would need to use something along the lines of if Table1 A Month / Table 1 A Year = Table 2 A Month / Table 2 A Year, then some how pull the average share price for the 30 or so shares that had the same Month and Year…
Thanks in advance