I need actual two different formulas 1) The first is to count dates in months for start to current, but to stop counting if an end date is listed. - i.e. c2 =...

My data looks like this: A B C D 24.9 25.9 25 25.8 22.6 23.4 22.5 23.3 Is it possible to use the conditional formating to do the following: If value in ColA...

When I type in a number that is less than a specific number set in conditional formatting I would like a circle to appear around the number. When I type a...

Hi there, Have spent hours trying to work this out! Hope someone can help. My raw data is (A1:B6): A 2 B 0 C 1 D 0 E 0

hi all please can anyone help me.i'm trying to sort 3 weights in lbs ounces grams. all i need help with is for excel to pick the two biggest weights and add...

Ihave a spreadsheet which is comparing the information on the spreadsheet to another spreadsheet via an Array Formula, if the information can not be found I am...

I am using EXCEL to track various activities. How can I get multiple date and time stamps to automatically fill? For example; Cell A2 is filled in with data...

Does the CELL function works with a external file? I want to get the path and file name for a external file, but the CELL function works only the active...

hey a function i have counts a list of names if the logical test is true, but if the logical test is false, how would i get it to keep the result it had from...

Hi, I would like to test a cell and run a formula if the cell is inbetween two values. For example. IF(A1 is inbetween values 1 and 100,"YES", "NO") I can't...

I want to count blank cells in one column where a certain value exists in another column. DCOUNT and COUNTIF don't work for this purpose. For example, I...

Is there a way to do basically a reverse of the conditional formatting - where the certain cells have a pattern assigned to them already, and is there a way to...

Hi All Does anybody know why the IRR formula doesn't appear to calculate when it is one of the output fields under the Scenario Manager Pivot Table option?...

I am using the following: =TEXT((J30/$B$31)/24, "h:mm") to convert hours and hundreths to hours and minutes. Excel is dropping the seconds and not rounding...

I need help with the check boxes on my excel spreadsheet at the top of the sheet I am able to check mark them as I reach the end of the sheet for some reason I...

hi- i have 3 columns (A, B, C) of data with 100 rows in each column. i want to combine my data from A,B, and C into column D. i can place this formula into...

How can I change Euros to U.S. Dollars in Excel 2003? I found how to convert currencies but not Euros to Dollars just Dollars to Euros and other currencies.

Hello, In a sheet a have the following function : Public Function feetAndInchToMeters(feet, inch) As Single Dim sngFeet As Single Dim sngInches As Single Dim...

I've changed the default font for Excel, but it didn't carry into the headers or footers. How do I changed the header and footer default font?

Is there a way to change relative cell refernces in multiple formulas from relative to absolute all at the same time, rather than highlighting refernce and...