General

Excel Add Ins - Funcres.xla and solver.xla for office xp
hi...i m working on a excel sheet. i m facing an error with following library missing while usig macro. 1. funcres.xla 2. solver.xla how can i download this files. i do not have office xp CD. i have searched on net...but not found. i do not have add-ins installed on my computer so....can't unchecked or check... 5 Feb 2006 10:38

Sum of numbers with dependencie on another column
I wasnt sure exactly how to word this question but i have an excel sheet with 2 cullumns |23|34| |24|56| |23|34| |24|56| |23|34| |24|56| |23|34| |24|56| |23|34| |24|56| |23|34| |24|56| now the actual one is more complicated but say i want to sum only the numbers on the right hand size where the number o... 5 Feb 2006 14:17

I need a Treasury Bill calculator
Would anyone share their EXCEL spreadsheet with the T-Bill yield calculations? Thanks you. ... 5 Feb 2006 03:46

REDUCING COLUMN SIZE
i want reduce the column size of a particular selected area but at the same time i don't want reduce the size of the column above or below the selected area i.e. i want to freez that selected area so that any changes to the size of the area don't effect other part of the sheet. can i do this? ... 4 Feb 2006 14:21

How to calculate the difference between two times - custom
I am looking for a formula that can help me calculate hours worked by addiing start and end times. I would like it to calculate the time by quarter hours with 8 minutes being the up or down trigger. Example "Down" Start at 8:30am - End at 9:37am = 1 hour Example "Up" Start at 8:30am - End at 9:38am - 1.25... 9 Mar 2006 00:23

Sort Pivot Table using hidden data field
Is this possible? I'm starting with a pivot table with 2 data fields (Sales and %Change). I have the data sorted by Sales, which is what I want. I don't, however, want the Sales field to be displayed. When I hide the Sales field, my sorting goes away. After further experimentation, I've found that hiding a... 3 Feb 2006 15:34

remove page numbers
How do I remove those large page number across my excel spreadsheet? ... 7 Feb 2006 15:10

How do I count the number of days from 1 date to another?
I need to calculate the number of calander days from one date to another. For example: if the start date is January 1, 2006 and the end date is January 2, 2006, I need the answer to be 2. When I subtract January 1 from January 2 I get an answer of 1. Please help. ... 2 Feb 2006 16:08

Referencing numbers
I have a s/sheet set up where I want to average percentages. I have 3 columns 1 where actual percentages are entered 2 where a number (1-5) is entered - no other numbers should be allowed 3 the total column that works out the overall percentage I can do parts 1 and 3 not a problem. I'm struggling with ... 2 Feb 2006 12:27

How to set Header Row to repeat on each page
Hi folks. Here's my issue: I have a very long spreadsheet with about 5000 rows and about 20 columns. One row at the top of the document is devoted to "header" information, in other words, what each column is, i.e., Name, Title, etc. I'm going to print out this document and would like to have that top row r... 2 Feb 2006 01:59