Skip

2 posts tagged with excel by Lucubrator.
Displaying 1 through 2 of 2.

The extract range has a missing or illegal field name.

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]
posted by Lucubrator on May 17, 2011 - 0 answers

Excel Subtotals

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]
posted by Lucubrator on Apr 21, 2009 - 6 answers

Page: 1
Posts