Hello all,
I'm fairly new to excel and need some assistance. I'm working on something that will analyze prices of players in Fifa Ultimate Team over time (for fun). Where I am stuck is how I get the avg price to update on the date that is specified by the date column. So, I have a query pulling price data off of a website once a day for various players, then I have a single cell that takes those prices and averages them. I want to have that average then fill a cell for price in a table that has Player Name, Date, and then price. How would I do that and not have the previous days value update as well?
I would have searched for other threads with people having this same problem, but am uncertain of what I would search.
Any help would be greatly appreciated. I'll go ahead and upload the sheet I'm working from to give you a better idea.
Thanks.What I need help with.xlsxWhat I need help with.xlsx
Bookmarks