We have a spreadsheet that was created in 2003 and has been saved now as 2007 (*.xlsx). In 2003, we were able to request the spreadsheet to be opened as...

I work for an accounting firm and we have spreadsheets for everyday usage. We would like to freeze only the cells in which formulas have been entered, so...

How can i track changes by column made to a worksheet. I have list of data like A B C ...

Is there an IF statement I could use so that if the word "Level" is displayed in cell A1 on sheet 1 then a table from Sheet 2 that is in the cells B2:C3 is...

I have taken over a workbook from a former work colleague. The workbook has a spreadsheet with array formulas in it. I have never used array formulas before...

I use Excel 2003. In a single Excel File, I have similar data in 2 different worksheets & I need to combine them in a single Pivot Table. I cannot paste them...

Let's say one colomn is a list of different gender types (man, woman, man, woman and so on) and another colomn a a list og ages (25, 35, 40, 35 and so on)....

I am trying to do a time sheet using the 24-hour clock. Here is a snapshot of one day: IN 8:00 OUT 17:30 LT 1:00 TT 8:30 ST 00:00 OT 00:00

using Excel 2007, I am having difficulty trying to dsum values where the criteria is for greater than one alpha numeric code and less than another alpha...

I need help and appreciate any provided. I need to run a ‘what-if’ and/or a pivot table to find out the number of personnel needing to be hired based on...

I have a worksheet that I have protected but allow users to edit some cells. In the protected mode the tab key doesn't function; only the arrow keys and...

How can I write a formula to calculate the average for the last 10 positive/negative numbers in a row eg. B4:BX4 if: 1. Row B4:BX4 has both positive and...

I have 6 columns with headings that repeat in a row. Users should make a check under a maximum of 3 out of the 6 heading choices--is there a way to restrict...

If your up for a challenge please have a go at this formula as I'm stumped :eek: If you can imagine there are a bunch of sports games played during the week,...

Hi, I have large ecxel-sheet and I try to find not selected data (not mach). I mean if I have columns where is (A1)=A, (A2)=B and (A3)=C. I need to find A...

Hello, I am importing data into a worksheet (Excel 2002 SP3) that is minutes and seconds. If the data is for one minute 27 seconds, it imports as 1:27. If it...

So hopefully this makes sense! :) I'm working on a sheet for a friend, and he has given me a list of 28 specific numbers with the ultimate goal being...

I'll try my best to explain. I have a master sheet followed by 4 others. There is a drop down on the 4 sheets with 3 choices: Recommend, Discuss and Not...

Excel 2007. I do weekly reports including charts from an established four page spreadsheet. It is very tedious to update the data ranges each week for the...

How can I use Countif to allow me to reference a cell that contains the area codes of phone numbers to be counted? Below is my feble...