I would appriciate some help writing a function, to measure several interval along a timeline. however not every interval applies to every record. what I...

I have 5 times fields the start times are in columns A & B and the end times are in Columns C, D & E. They are not in order, but cols A or B are always C,...

Hi, I am need to convert numbers from my excel file to a text file where the number needs to show up as follows: ###############.## So for $401.11 the amount...

I wish to back up my xls files to dvd. I keep getting "You do not have access to folder 'E:\'. See your administrator for access to this folder." I am using XP...

This is my problem: I have a spreadsheet with three separate cells, call them A, B, and C, that I am using for inputs. These three input values create a table...

Hi, I've been struggling with this for a couple of days... I'm trying to save an Excel 2007 worksheet as a web page, not a static web page - I can do that -...

When I select rows and columns in Excel, the selected cells are too feint to see clearly (much darker in previous releases). Is there a way of darkening the...

I have been trying to create a monthly loan/lease calculation where there is a residual at the end of a 5 year term. I am happy with each month (using IPMT),...

I have a large list which I want to use two different criteria to find one unique row. I was able to achieve this using the Autofilter command (perfect with...

Hi Everyone, Is there a way I can easily change the year in a list of randon dates?? I have a table in excel, with date in the first column. I need to...

I created some Macros to do some simple functions (sort/filter/text to columns/create a new worksheet) on some fairly small data samples (max 200 rows and 8...

I'm looking for a function that will lookup a value and return the value of the cell directly below the cell in which the looked up value is found. In this...

I would like to rank a group based on two Criteria, and i can't figure it out. I've got a list of 10 teams and I want to rank them based first on winning %...

I want use bullet in the excel cell with indent text. Could you please help me, thatnks. Waiting positive response.

Try this with: = date of birth; = Date of death; =DATEDIF(A1,B1,"y")&"y,"&DATEDIF(A1,B1,"ym")&"m,"&DATEDIF(A1,B1,"md")&"d" Should work OK Regards

I have been using the function =IF(COUNTIF(H:H,"Rory")0,I21,"") It will return the value of cell of I21 if the name "Rory" is in column H. I need to know if...

I need to return the position of a cell in a list. For example, I have the list: A B C D E F

how do you format a cell so that when you enter 1254 the number is displayed as 1,254,000

i need to input data into an invoice template. when i put in item number i want it to call item info and price from a list of inventory items so i can print...

Need to know the Function to calculate the reducing balance depriciation.