Hi. I want to subtract one time from another, and display the result in minutes. My problem is that sometimes the time crosses over midnight. A ...

How about just using Fill series? Example: Put in B1: 1 Click Edit Fill Series Check "Columns" under "Series in" Put the last figure (say 1000) in the...

I hope I can put my question forth clearly and briefly. Here goes! First of all, I'm working with Excel 2000. - I have a workbook with 3 worksheets. - If...

How do brackets nesting a formula affect the formula? Working on someonelese's spreadsheet found a nested series of IF statements that start and end with...

I am hoping someone can understand this question... I have a worksheet with several columns and rows of data. What I need to do is take one cell at a time...

That is an array-entered formula. Press CTRL-shift-enter when you are done editing it, and if your edits didn't screw it up, it'll still work :) "Mico...

Mico, It sounds like you have an array formula. With these, you don't type the { }, Excel adds them when you enter with Ctrl-Shift-Enter, rather than...

On Fri, 7 Nov 2003 12:31:13 -0800, Art wrote: Hi, I've got a worksheet in which I have a starting sales volume in...

Excel 2000, here's the prob: Column A B C 100 50 200 150 300 250 20 400 ...

I have a graph which compares several pieces of data to one line representing historic sales for one day of the week. The y value in my graph is...

Most nested 7+ IF problems are more often than not lookup problems for which VLOOKUP, LOOKUP, etc. are better suited. "borkot01"...

What I need to do is a bit hard to describe so I'll give an example: A B C D E F 1400 data1 data1 data1 data1 data1 data1 ...

Hello.. can any kind people out there help me find out how to apply global change (or any other way beside doing each hyperlink individually) of address path...

I'm using Microsoft Excel 97 and I have a question regarding the IRR function. I'm trying to do an IRR calculation on a monthly cash flow stream and using...

Hi Sure. Try this: Sub MakeYear() Dim D As Date, L As Long For L = 1 To 52 D = DateSerial(2004, 1, 1 + (L - 1) * 7) Worksheets(1).Copy...

Iam using MS-Office 97 with windows 98 as the Operating System with 40 GB Hard Disk and 128 MB RAM.Iam working with the excel file which carries 58...

Hi, I know this is pretty basic, and yet I'm stumped! I've got a sales volume worksheet. I want to project quarterly sales volume using a MONTHLY growth...

Hi, A frustrating issue someone may have a resolution to ....? I have a PIVOT table created. I am trying to extract information from the PIVOT table, to...

I would like to compare and merge a couple excel workbooks/worksheets, but the compare and merge option is greyed out. Can you tell me what I need to do to...

Marvin, try this, file, page setup, sheet, under print check black & white -- Paul B Always backup your data before trying something new Using Excel 2000 &...