Using 2007 on Vista If I've got text data which in some columns either has data or there is a blank, what formula do I use to count how many cells have text...

Hi, I have two columns of data, 5 students and their grades in columns, say B (name) and C (Grade). How can I reproduce the highest grade and corresponding...

There is a charge of £55.75, to which a handling fee of 2.95% is to be added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any...

I have a task, in which I import a file which has almost no standardization, other than name|email, and I clean it up doing a lot of global replace(s). I...

I have a little database which arrives periodically, and I would like to chart the number of members by nation. I can't recall ever having this opportunity...

I was using a Microsoft template called Dinner Menu with Guests, and had filled out several rows and columns. I have Office Standard 2007. When I opened it...

Awhile back I could hold down the right mouse button and select a group of numbers. The sum of these numbers would show on the bottom of the page. I have...

I am new to access and need someone to help me build an expression. I need to update the "expiry date" field in certain records so that when I run the query...

In cell A10 I have the value of my shares at close yesterday (£1000 -cell formatted in £). In cell B10 have the value of my shares at close today (£1050 -cell...

Hello, I have Excel 2007 I am developing a spreadsheet in which it might (repeat might) be helpful to put 2 integers into a single cell, and to access them...

Hello, I have Excel 2007 If I want to delete a row I can select the row, right-click, then select Delete from the drop-down menu. No problem. I notice that...

i am attempting to e-mail one page of a workbook and can not figure out how. i do not wish to attatch the complete workbook.

within my macro i wqant a message box to come up requesting the user to either type in a file name or paste it and then use that file name to open the file...

Pls let me know where I can get free practice questions/answers for MOS Excel Expert 2003 exam from the web.

I'm trying to track employee's hours weekly and then need a year to date report. How do I do this?

I am taking an on line course, the instructor needs us to use the grapyhs in excell 2003 & earlier versions-screen shots, he says the follow instruction 3...

I have a workbook in Excel 2007 that contains cells which are external references of another source. This is a monthly workbook that I now wish to save and...

Hi all please help me out. I am new at excel. I need to create a sheet to log in our inventory and be able to add to it when we get parts in and subtract...

How do I get a "confidential" or other message to appear across a worksheet to prevent usage, copying, etc.

It's easy to invalidate an Excel 2002 workbook, putting it into a recalc-required state, yet Excel fails to do it. For example, I have a worksheet with...