2 posts tagged with excel by Lucubrator.
Displaying 1 through 2 of 2.
Does anyone have a handly list of reasons why one would get the error "The extract range has a missing or illegal field name." when using advanced auto-filter? [more inside]
So I have an array of data in Excel. Specifically, weekly repos outstanding (dollar amounts) since 2001. Is there any way to find monthly rate [(last date of month-first date of month)/first date of month] of change for it? What I have in mind is something like subtotals function except it shows rate of change rather than sum or average. Does anybody have any ideas? [more inside]