I have a list of dates but I only want the pivot table to group them by month, not by day. Ex: Month 11/1/03 11/3/03 11/4/03 12/2/03

When using the IRR function, I am getting a "#NUM" error. The cash flows are for 12 periods and switch between positive and negative a few times. But I think...

put -1 in an empty cell. Copy the cell. Select your column. Choose Edit/Paste Special, selecting the Value and Multiply radio buttons. Click OK. Delete the...

Hello. If I have a macro I just wondered how I can design my own small icon to go in the toolbar, and also how I can install this to work with the particular...

Pop this formula into the top cell of any column and copy it down as far as needed: =INDIRECT(CHAR(65+MOD(ROW()-1,4))&INT((ROW()-1)/4)+1) This assumes your...

Friend I don't know if you found an answer but the same problem is driving me crazy. I'm Looking at a hospital/ER situation where I need average and median...

If the result crosses midnight, add 1 to it, and multiply the whole result by 24 by 60. For instance, =(B1-A1+(--A1B1))*24*60 and format as General

I have made myself a few very handy tool bars. Is there a EASY way to move them from my computer to an other machine(s)-where are they...

I have a two part question. Part One I am trying to filter data within a list. My list contains the following information: LAST NAME FIRST NAME ADDRESS ...

I Need to Force single instances of excel, Don't have a clue but the folks here are killing me with this stuff. We had a shortcut with a /p switch to try it...

Hi all My problem is this... 8o0 I need to sort the information contained within a hidden table (4 rows by 8 columns) and display the results in a second...

look here http://tinyurl.com/ub9t -- Don Guillett SalesAid Software "He4Giv" wrote in...

i'm running office 2000 premium and need to "format the tab color" is there any way to do this with this product?

How do you copy a number to go in numerical order. 1,2,3,...?

I need a formula to caluclate in hours(military) a starting date/time to ending date/time. example: 12/01/01 01:30(same cell)12/02/01 14:00(same cell)= hours

What I did: I Saved my workdbook as a HTM file and added interactivity with pivot table funstionality. 1. The colors I choose in the spread sheet do not...

Is there a way to get the user's name or profile name being used on the PC as sort of a way of signing the document?

Hi, i am trying to create a formula that has the What If Function (maybe?). So I am strugling with trying to link a single cell to import data from another...

When I obtain an EXCEL 2000 (created in EXCEL 2000) spreadsheet in an EXCEL XP environment, I receive #Value# error after I get passed the "Update Automatic...

Fairly large Excel Workbook has 60 Sheets, 10Meg size, 1500 Rangenames. Macro (VBA) adds a sheet backgound when entering a sheet, if sheetname.gif exists in...