I am working in a spreadsheet in 2007 and all of the features in the data tab have become unavailable. I need to use the What If feature. What can I do to...

I am needing to create a formula that will give me ....... If (cell number) is greater then 48 then what is the difference. If it is 48 or less then...

What would the calculation be if I needed the % of the type of following situation: 5 patients discharged, 2 of which needed charge corrections. What is the...

I need help creating a spreadsheet in excel that would give me the following total percent for the following information: If there is a total of 3 dogs and 2...

Can anyone help with the following vloopup...

I am currently using the OFFSET command to jump from one column to the next if I increase the number in Cell A2:- =OFFSET('Act 05'!$D$57,0,$A$2-1) What...

A row contains a series of diminishing numbers. I am looking for a formula to identify the first zero occuring in the row and return the date contained in the...

Hello all i have a couple of workbooks that are copies of each other. i need to merge them. it seems that you have to share the workbook before this function...

i have a quick question when using this set of formulas in the conditional formatting does it work on text? i am trying to alternately highlighting groups...

I have 6 columns of yes and no answers I need to group the columns in two and if both columns have a yes I need that statement to be true but I would like to...

Hi Can anyone help I need to complete a time sheet so that I can add up the number of hours worked in a month - but every time it goes over 23 hours it goes...

is it possible and how do i link a range of cells on one worksheet, to a range of cells on another worksheet, in the same workbook. but only if a certain...

hi there Is there a way to 'turn off' the prompt "Do you want to save your changes?" when you close excel? Many thanks for any help! Dawnyanne

Hi - How do I make a formula in a pivot table based on the value of a column? I have a pivot table with the results of totals by employee number of 4 types...

Can someone please help with a formula? In Column A I have names formatted as SMITH, John. In Column B I need John Smith. Would someone please help with a...

I'm hoping someone can help me write a function, please, please, please. What I have: I have a spreadsheet ($surveys) with one record per line. The...

I'm hoping this is easy but could someone please help me with a formula? I'm trying to compare a date with today's date and if the dates are more than 90...

I have a formula that pulls info from another page. The formula is: {=INDEX('Patient Count'!$J2:$J5000,MATCH(1,('Patient Count'!$C$2:$C$5000=A2)*('Patient...

I'm hoping someone can help. I'm working on a worksheet (Rollup!) that gives me a count of days that a person is present in a given month from information...