Hello,
I'm pasting the date of quarterly earnings from briefing.com and creating charts based on each one--each earnings date has its own chart. Sometimes Briefing doesn't have four quarters listed for every historical year and it messes with how the charts appear, because I line them up by every fourth one (I group them by first quarters, second quarters, etc.). Is there a filter or format I can apply to the row of quarterly earnings dates that would find a "skipped" quarter and insert a blank cell?
In other words, even if some of the charts are blank that'd be more than OK, if it meant all quarters lined up.
Here is a sample row of quarterly earnings where dates are unpredictable. Ideally, each year would have exactly four quarters (or spaces, if one or more is unavailable).
My thanks,
Jamie
I'm pasting the date of quarterly earnings from briefing.com and creating charts based on each one--each earnings date has its own chart. Sometimes Briefing doesn't have four quarters listed for every historical year and it messes with how the charts appear, because I line them up by every fourth one (I group them by first quarters, second quarters, etc.). Is there a filter or format I can apply to the row of quarterly earnings dates that would find a "skipped" quarter and insert a blank cell?
In other words, even if some of the charts are blank that'd be more than OK, if it meant all quarters lined up.
Here is a sample row of quarterly earnings where dates are unpredictable. Ideally, each year would have exactly four quarters (or spaces, if one or more is unavailable).
My thanks,
Jamie
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 26-Apr-07 | |||||
2 | 8-Feb-07 | |||||
3 | 24-Jan-07 | |||||
4 | 20-Apr-06 | |||||
5 | 26-Jan-06 | |||||
6 | 20-Oct-05 | |||||
7 | 21-Jul-05 | |||||
8 | 21-Apr-05 | |||||
9 | 27-Jan-05 | |||||
10 | 21-Oct-04 | |||||
Sheet1 |