Excel R1C1 referencing
I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls). Within this spread sheet are cells containing formulas with R1C1 referencing. When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office button, formula options, but the [...]

Answer Question   |  September 28, 2010  5:10 PM
Crystal Reports, Crystal Reports Export to Excel, excel, Excel 2000, Excel 2003, Excel 2007, Spreadsheet functions

Match a date to a number
I have a list of dates (A) on the left inside next to each date i have numbers (B). I have another list of dates (C) which is shorter with the same dates. I’m trying to match the numbers to dates (C) based on the first dates (A). 1 0.6 10/20/08 10/20/08 2 1 10/21/08 [...]

Answer Question   |  December 16, 2008  4:32 AM
Spreadsheet functions, Spreadsheets, VLOOKUP function