In excel.... When I try to use the "spilled paint bucket" icon to color the cell backgroud nothing happens. It stays white.

Code: -------------------- A B C D E F G Jan-05 Info Date IF EB IF2 EB2 January A Jan 01, 2005 1 1 1 1 B Jan 01, 2005 3 4 3 4 A Jan 02,...

Hi All I have a formula that gives me year-to-date on an incomplete range A to L.. =SUM(OFFSET(A2:AL,0,0,1,MATCH(M1,A1:L1,0))) So incoming data A3 = 3 B3 =...

Hello Users I am trying to apply conditional formatting to a set of dates. I have a calendar set-up with days of the year in columns. I have a list...

I have another problem, I am sure this one is easy to work out, but my mind seems to have gone blank, so hopefully someone can help. I have a worksheet which...

Loan amount = $100,000 Annual interest = 6% Tenure = 30yrs Monthly rest instalment =PMT(6%/12,30*12,100000) =$599.55 What is the formula for Daily rest...

hi guys, this is my problem: in column A: vehicle no ( there are 10 vehicles) column B: start km column c : end km clm D: km travelled in clumn e: date in...

{=SUM(IF((LEFT(TEXT($A6,"mm"),2))=((LEFT(TEXT('Weekly Total - 2005'!$B$4:$B$123,"mm"),2))),'Weekly Total - 2005'!E$4:E$123,"-"))} Can this be simplified...

I have downloaded the xlmacro.exe file in order to be able to keep my old macros update, or to write new .xlm macros. xlmacro.exe won't install, because it...

How do I sum a large column of numbers when some of the cells within the column contain... #N/A in it. Thanks, FLKULCHAR

Hello Is there a function NameOfFunctionAnalogOfLookup(lookup_valueInFirstColumn,lookup_valueInFirstRo w,table_array) or an analog...

I'm just learning Excel and I did not find a tool bar that my friend showed me on her computer that will allow me to tell the columns what function I want them...

I'm trying to create a formula that will count the values that are more than 0 in a range across multiple worksheets. COUNTIF('1:17'!D3:D9,"0") is what the...

Hi all- I'm new here and hope that someone will be able to help me with this. I am having an excel link problem. Here is the scenario in basic terms. I have...

Hi all, Is there anyway to incorporate a wildcard funtion into an IF function? What I was planning on doing is something along the lines of a ...

I started a formula that I thought was fairly simple. However, I cant seem to make it work. Basically, I have a spreadsheet that gives me the rate of return...

where can i find Cursor Shapes for Excel 2003

Hi I receive a data feed in the format of a workbook and the data that is supplied has different data sources and as a result the time and date field are in...

Hi there I am working on a spreadsheet to measure agent performance. I want to rank agents on the time they spend in "wrap up" after each call. I've tried...

I am running SUMPRODUCT with 3 criteria, 2 are on another sheet and one of those two is searching for a portion of the cell content. I am getting #N/A as the...