I'm working on a simple tool where a person could return a value base on the intersection of two inputs. For example: (Imagine a mileage array where you)...

How do I program a function key on my keyboard to enter the current time into a cell? In one key press of the function key, the current time should be entered...

Hi Some assumptations (as you didn't give us enough about your diesign): You have your list on some sheet, p.e. MyList (for my example I assume the lists...

hi i try to define criteria for DMIN for the following problem: Sheet 1 contains the source data in two colums: "Milestone ID" and "Data", where "Milestone...

What formula/how do I add up a column containing 1:10 minutes and seconds. Do I do an =sum and format for time???? Can you help, please.

I am trying to use the countif function to do some simple logical addition. My problem is I need to count the number of rows based on two different...

Hi: I have a simple spreadsheet with locations down the right hand side, a date series across the top. In the intersection of the columns and rows I enter...

. Reply (E-mail) Forward (E-mail) Subject: lookup From: "Dave Bigelow" Sent: 9/29/2003 10:10:02 AM Correction of...

I have a complex system modeled on a spreadsheet. n identifiable cells are input parameters, m identifiable cells are output results. I want to plot some of...

I have a complex black-box modeled on a single worksheet. n identifiable cells are input parameters, m identifiable cells are output results. I want to plot...

This is embarrassing; but I want the military time of 22:58:00 minus 19:20:00 to equal 03:38, not 20:22:00. The formula I tried is: J5-J6. Thanks In Advance

When I type 24/6 in my Excel 2000 it does show up as 24/6 in text........maybe you could type an apostrophe or space before the 2 and it would automatically...

I am trying to develop a formula that will pull balances based on a certain location, expense, and month, but I am having problems. Here is what i have so far...

How do I add up a column of minutes & seconds?? Do I use =sum and then format by time??? Please help. Thanks.

HOW MANY WORKSHEETS IN A WORKBOOK?

I am trying to link a worksheet out of one workbook to another workbook. I want to link the entire worksheet, so the second file is always updated with the...

Is it possible to create a mirror image of a worksheet with in different workbooks that automatically update when you make changes?

=SUM(IF((FIXEDm!$F$2:$F$5000="WG1")*OR((LEFT(FIXEDm!$I$2:$I$5000,4)="2q13"),(LEFT(FIXEDm!$I$2:$I$5000,4)="2q15"),(LEFT(FIXEDm!$I$2:$I$5000,4)="2q17")),1,0)) I...

I am trying to figure out a way that I can have a cell or text within a cell change to a certain color once a condition is met. Does anyone know how to do this?

Why do a couple of micros that I was working on start automatically when I start Excel? How can I Delete them so that when I start Excel I get "Excel Book 1"...