Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
and calculate an average for each field (ROE, ROA, etc quarterly going
back 3 years).
Not all of the data sets include the same quarters depending on
whether they have reported yet. For example one set starts with Q2
2005 and another starts with Q1 2005.
If I run a VLOOKUP to pull the data I get it only for the quarter
specified--I could manually input a range two quarters above and below
but then I would have to adjust this.
Is there a way to aggregate a list of all quarters showing data? And
then to count how many data points appear in each so that I can divide
by the proper number? Read More