I am using the below formula in D195 to look up an employee's hours. B195 is Doe, Jane from the search array, Doe, Jane is in B139 and Doe, Jack is in B138....

I have received an Excel 2007 spreadsheet in which selected rows have been hidden. When I try to unhide them using the normal methods, nothing happens. The...

I am creating sales confirmation documents in html. There are three sections to each document (Header, Body, Footer). If you open the html document in a...

I am in charge of a list containing license plates and fuel card numbers. Once a month i'm sent an updated list. It takes me forever to compair all this...

1 A B (30) C (25) D (40) (100) is a balance. I want the balance to be distributed amongst the

I have a template that is used as a quote sheet. We would like to have it create a quote number automatically when the file is saved and not change when the...

Ctrl-C, Ctrl-X and Ctrl-V do not work in the "Edit Series" dialog box. In Excel 2007, create a simple chart. Now go to the "Select Data..." dialog box. Click...

I have a date in a1 as 13/04/2009. Can I get a formula to return total no of Sundays in this month of the date? Also Can I get total no of days except...

How to scan 2 areas with text? if some of the cells are with the same text to show third cell. For example: if some cell in area A3:A20 is the same with some...

How would I place a cell reference within a narrative comment in another cell? For example, "Family Practice workload in Jan increased by X%". (This is in...

Is there a way to insert more than 3 conditions in the conditional formating in excel? -- dani

I set up links within a number of cells from worksheet 1 to various cells in worksheet 2. The cells, on worksheet 2, instead of being blank are showing "0"....

Can you include a named range in a custom header?

Is it possible to create a chart giving me a count and/or percentage from one column with different entries. I need to create a chart that tells me 20% of...

Hey Guys, i Want to use COUNTIF function liek this.. (Range, Criteria, when you use count if, it will just let you do one if statement, (range,...

Try this User Defined Function: Function username() As String username = Environ("username") End Function UDFs are very easy to install and use: 1. ALT-F11...

Hello all, I need to add USD to a dollar amount. Could someone tell me what I would need to add. I thought this would work but it gave me an...

I want to use a formula for addition and subtraction which will be repeated on the whole sheet. example C2=C1+A2-A2.This will be repeated in every cell. How...

Hi. Suppose I have a series of observations. 1 3 5 7 9 My objective is that I want to have the following matrix. 1 3 5

(Excel 2003) I want to count 120 days forward from a certain date. Is there a formula to return a new date?