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

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

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

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

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

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

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

I am trying to make my daily cost report form into a functional excel spreadsheet, but i am having trouble with embedding the functions. Please help. Thank...

My question revolves around summing particular items in a column based upon the number meeting 2 criteria. I have done this before with the sumif function for...

I made and invoice excel template and a shipper excel template. Each time I open the worksheet to make an invoice, I want the number to change in the cell on...

I need to compare data on 3 separate worksheets but all in same column to see what data is identical. What is the best technique to use?

Hi there, I have a slight problem that I hope you may be able to help me with. I am trying to perform date validation to some cells in a worksheet, so it...

I have created a spreadsheet that mirrors my paystubs, ie salary and deductions in column A and the dates of each payperiod listed B2:AA2. The dates are...

I wish to use a formula or to format a cell value so as to only display certain characters of the actual value. For example in the case of a...

Is there a way to change the tab color of a worksheet if a certain cell has one value or another? "If cell value is more than zero then tab color is green"...

I would like to do the next: If the value of a range of cells (e.g. b1:x1) exceed the value of a single cell (e.g. A1), cell A2 has to be marked by a color....

I have tried using PULL from Harlan Grove's posts to workaround this but am coming up with #VALUE errors. Here's what I have: Column B contains the acct #...

a cell contains "123 a b". i want to unstring it into three cells in the same row.

How can I sort dates by the month instead of the year?