We did a survey and put the responses in Excel (2003). Responses to questions 1-3 have a qualifier. In other words, the response either “Yes� or “No�...

Hai, Need a sugestion from you all. I have problem to count my data. For example, I want to count for each Team how many coaching or counseling had been...

We are having a fate Sunday 8th june 2pm. The Official opening will be by Peter Bowling of the Capella Hotel. Their will be Two good prizes given by the hotel....

Hello, I have a spreadsheet which produces a complex chart. Can I 'zoom' in onto a portion of the chart so that I can see the various data points more...

Hi, I have made a macro that runs another macro and copies the results to a new column thus creating a list. I want to make the macro run over a large number...

I would like to be able to enter a formula into a cell and have it not require me to first type the equals sign. For example, when I type 12+12 I would...

Hello, I have a spreadsheet with data from a datebase that list dates with no slashes. How can I add slashes? Current format -7132007 Desired format-...

My issue is: Col A has the airport codes (ABE) and my table array has the airport codes decoded. The formula I used: =VLOOKUP($A$2:$A$2544,'AIRPORT...

I want different colours to be set for track changes i.e first colour by author another colour by reviewer and yet another colour when the author reviews the...

Revisiting an eariler issue. I have an excel document that looks like what I've shown below, in Sheet 1 Column A Column B Column C Column D 1 Origin...

I am a chart virgin and desperately need help!!! I need to build a bar graph with whole numbers for call volumes of differant lines of business and also with...

I have the following columns Apr-2006 Apr 2007 0.00 0.00 0.00 0.00 0.00 331.08 0.00 107.90 0.00 0.00 0.00 970.00 1,134.60 0.00

Hi I have this spreadsheet and want a total at the bottom of the column that totals only 2007 or 2008 2007 WRRE01 WR 0.00 2008...

I have Excel 2007 and want to sum the number of units we sold every 10 days between October 1 and December 31. The date fields from the invoices are formated...

I have a tracking list in an Excel 2003 spreadsheet (posted in Sharepoint) so other folks can add a single row of information to the list. Somehow, the...

Hi I have a spreadsheet that has two sets of figures for 2007 and 2008 split by month and by Sales Person. I now have a formula that calculates the percentage...

Hi I wish to put a logo on say sheet one stored from sheet 2 using an if statement, I have looked at http://www.mcgimpsey.com/excel/lookuppics.html but it...

In Office 2007 how can I view the tabs at the bottom of a worksheet

When I open 2007 files the file opens closes and reopens, is there a way to stop it from doing this? -- Jay

I am new to Office 2007 and the new features in Excel. I am used to using Excel in Office 2003. I'm trying to use a feature that I've always used in Excel...