Functions

hyperlink problem
i have three columns that make up my pdf file names i.e. example: columnA=2010, columnB=03, columnC=33 (my file name is 20100333.pdf). i want to have a column that opens corresponding pdf files. moreover i would like the function to look up for the files in the same drive that my excel files relies on. i h... 1 Mar 2010 12:34

How do you change seconds to cycles?
How do you change seconds to cycles? ... 1 Mar 2010 17:38

Sorting amounts in columns by due dates
Wouldn't ya know after I built all of this the stupid columns are coming out as: 120, 120, 30, 60, 90 I need: 30, 60, 90, 120,>120 I know i've seen a post around here about this but I just couldn't find it again. Joe comptrtoy1(a)yahoo.com PS anybody seen a good course online for advanced pivot table tra... 1 Mar 2010 10:17

Excel 2003 query from Access 2000 database
I have been using Excel 2003 workbook to query a database created in Access 2000 for several years. This is for tracking appraisal information, who has paid, who owes, and subcontractors that we owe for a given time frame. Recently, one of the spreadsheets within the workbook generates the following error, upon try... 1 Mar 2010 10:17

Dividing zero by zero
Mike, I'm having a similar problem, I have two columns of numbers where either or both arguments can be zero. I want to turn this into a percentage, returning 0 if appropriate. How do you add to the formula you've recommended to cover both arguments - e.g. if I want to calculate A5/A10 and A5 and A10 are both ... 1 Mar 2010 09:11

excel - rows repeat on top
i use rows to repeat at top in page set-up. but it adds pages to my worksheet. Instead of having only 17 pages without the "rows to repeat at top" it becomes 34 pages, the addition having no entries (blank). ... 1 Mar 2010 03:43

Countif Help
Hi, I have a list of 8 intitials in a row (C7 : J7), such as AR, IR, CS, RP etc. These are 4 golfing pairs. How do I count the number of times "AR" AND "IR" appear anywhere on row C7..J7? E.g. if both "AR and "IR" appear in range C7 : J7, the result of "1" would be returned in K7. if just "AR" appears,... 1 Mar 2010 09:11

Formula to estimate value
I have a chart on a worksheet, that is created by data in another worksheet. Basically the chart will be an area chart with readings that will decrease in value after easch test date. eg. A B C D E F ... 1 Mar 2010 00:28

If formula current/expired/blank
I'm using this formula to return a 'current' or 'expired' value depending on the date in column B (expiry after one year). Because I want to autofill rows that don't yet have data, I require some extra criteria so that no value is returned if B is still blank. Comprehend?? =IF((TODAY()-B4>365), "EXPIRED", "C... 1 Mar 2010 08:05

need excel worksheet help, running total based on date
I am trying to add a series of numbers in different worksheets(same spreadsheet) based upon the date. I don't want the future numbers in the total until the date they are associated with is passed. i.e. in A1 of each worksheet is 200. Each worksheet is titled by date (Mar 5, Mar 19, etc) I want the running... 28 Feb 2010 21:11