Hello, I am trying to find a reasonable way of calculating a median. I have a data set that is about 20,000 lines long and it contains Quantity Sold and Unit...

I am trying to make a fill in the blank worksheet for my boss. I've locked out the cells he does not have access to and have protected the worksheet. Now...

Hi everyone, I am trying to creata a formula that will return a value depending on 3 criteria. With Vlookup I could only find the formula retrieving a value...

I posted a question on Excel yesterday called returning data and I never received any response can anyone help me??????????????????????? -- Newfie

I have a workbook with 10 or more worksheets. At the end I would like to have a list of the Employees there FTE and their location etc. My formula to...

Can somebody tell me how (where) I can change the comment standard? -- JBJoost

Worksheet 1 is called All Staff Worksheet 2 is called TEAM 1 Worksheet 3 is called TEAM 2 All Staff A B ...

I want to be able to add an option of adjusting a spreadsheet in Excel 2003by clicking on an arrow at the top of each column that will change the entire...

How do you sync scroll bars when viewing two or more workbooks in excel??

I want to highlight an entire column based on the value of one cell in the column. The column is B. The cell is B2. If the value of B2 is Y, I want the...

Is there a function that can figure out today's date and then subtract someone's birthdate and then have the result be their age as of today's date? For...

I’ve been asked to figure out how early an employee typically punches in for work. They want to give her some sort of bonus. I have the punchclock data...

Hi, Can someone tell me what is wrong with my formula? It seems that the "OR" function in this formula is not working. It is bringing back a zero when there...

I need to use sumif but only count the cells that are shaded blue. The blue cells are subtotals that I don't want re-counted. Thank you, Chuck

Hi I need a funtion to convert Number to words literally, I mean 1241 (One Two four one) I found many examples for currency but I need literal every number...

A couple of folks helped me yesterday and I am very grateful. Now I have another issue. The problem now is that I am merging two different worksheets that...

I have split up my worksheet so the first 6 mos is on one sheet and the last 6 months is on a second sheet. I need to bring over my YTD Average and...

I have A summary Sheet, and a few tabs, and i want a macro to collate all this information. So far i have; -------------------------- Dim rng As Range ...

I need to know how to number worksheets so everytime I save as and open a new one the next number automatically comes up. For example: I want to star the...