I am using Excel 2003. Sometimes we use conditional formatting and make some rows invisible which are not matching the criteria by setting their colour white....

Does anyone know how you calculate the nth root of a number in Excel 2003? I want to calculate the annalized percentage rate of return from a table...

This is a "repost"... I didn't get any replies a few days ago... maybe I'm luckier this time. I use a validation list that brings up combo boxes in a cell...

JUST TO LET YOU KNOW THAT I HAVE 17 SPREADSHEET FILES AVAILABLE FOR YOU TO DOWNLOAD FREE TO YOUR COMPUTER! THESE INCLUDE A COMPOUND INTEREST CALCULATING SHEET...

What type of formula would I use for this calculation? 8/1/2001-5/4/2004 if the dates are between 7/1/2001-6/30/2002 count all the days and multiply by 40 if...

I have a spreadsheet with two columns detailing hours worked, (i.e. from and to) and I have then two columns that convert the hours into a number format, and...

Hi, I am having a really hard time here with this. What I have is data on sheet 1 being an employees number, and a score they got on a training quiz. (Columns...

I need formulas to calculate a dividend when it occurs between 2 dates. I’ve tried a few options & looked through the group but I don’t have the skill to...

I am a beginner with Excel, and a little lost. When creating a formula, is it possible to use the content of a cell, without creating labels, to refer to the...

I want to import data in a cell from an external spreadsheet located at 'C:\Data\MySheet!$H$5. I want to build it using cells from the current worksheet such...

Hi The result of a formula gives me ##### for a negative number. Is there a way to get the actual negative number (i.e. for example -9 instead of...

For those using Excel 2003, there is a bug in the SLOPE/INTERCEPT formulas. If a y data point is deleted at the first or last position of the data set, these...

I am sharing with an outside company an excel file that has links to other excel files on our network. I need to send this file back and forth and keep the...

I know I can use "Advanced Filter" to copy Unique Records to another location of spread sheet. Question is ... can this be achieved with a formula? Something...

I have 5 columns, the first 4 containing lookup functions that return either #N/A or a value of N44255 XX X XXXX where X can be any combination of digits. In...

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...

this is drvng me crazy! :) okay...thanks to roger for helping on "vlookup" .now..i have a lists of plants with costs ..I was hoping to be able to copy the...

Hi I am trying to get the vlookup function in excel to work. unfortunately I am using a german excel 2002 which doesn't now the name "vlookup". Does any body...

I need to use 10 IF functions but if I try more than 7 functions, I get the error message below "Up to seven IF functions can be nested as value_if_true and...

I want to use the INDIRECT function to capture a reference that is 2 columns to the left of the one in which I'm writing the equation. Unfortunately, if I use...