## Data table sources with multiple pagination

i need to gather data from paginated tables and return them as a feed or something that can be easily pulled as a query into excel.
posted by malcommc on Oct 21, 2010 - 4 answers

## YTD total based on sum of last number in another row that has a value?

YTD total based on sum of last number in another row that has a value? I need to sum up the values in one row based on the matching row below it. For example, if I have a target of \$1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul. I have tried a couple of variations on COUNT, INDEX and OFFSET. Example is here: http://malcommc.com/ytd.xls I am using Excel 2003
posted by malcommc on Jul 12, 2010 - 12 answers

## Need a formula to lookup/match two values and return a third in Excel

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.)
posted by malcommc on Dec 28, 2009 - 5 answers

## How to return every Nth value in a column in Excel?

I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column.
posted by malcommc on Oct 26, 2009 - 13 answers

## Need excel formula to calculate the number of days in a date range, if they end within that range

I need a formula to help calculate the number of days as compared to a range. Importing a CSV for a query to show bookings within the date range of 9/1 to 9/30. Some bookings are booked through the entire month and some are partial. I need to figure out the number of days or percentage for the bookings that don't run all the way through the query range.
posted by malcommc on Oct 1, 2009 - 9 answers

Page: 1