Hello all you wonderfulhelp, Is it possible to avoid "NA" when using "vlookup" function. I need info only where it brings results. Thank you -- smile

Hi, I have data with decimals. I need them to be whole numbers in a pivot table and then be the columns. Currently I have formatted the original data to be...

Could someone please tell me how to find the absolute value of the differences in a number series residing in a column? I know the abs value function. I...

Hi All, It has been over 10 years since I did my Excel studies and I've unfortunately forgotten everything I haven't used regularly. My office has recently...

I have Office Home and Student 2007 which has a Football pool and a Medication Recording sheet. A friend has Excell and she has a sheet on it that can be...

I´ve tried to make a bubble chart that displays profit/losses for a day trader in the forex market. But I cant get it rigt. The chart gets all wrong. What I...

Hi I have a range of cells P6:P19 that have no data in them and a formula in cell P20 that is =AVERAGE(P6:P19). This returns a #DIV/0! error This of course...

Hi I run Excel 2K I have a table on a wroksheet called SUPPORT SHEET. I use the sheet for various purposes. eg, validation tables, lookup tables etc On a...

I'm sure this is easy as pie for you guys - I'm creating a boxing scorecard and I’ve hit the wall. Cells b2:b13 and c2:c13 are where the scores go. I...

I have copied the makro from microsoft site: http://support.microsoft.com/kb/291320/sv But when i tried to start it this message shows: Run error number...

I just made the transition from Excel97 to Excel 2007 and am struggling with the usage of the home key. For years I have been using a bank balance journal...

In Word I'm able to attach a calendar as a drop down menu...then a person who clicks on that drop down menu will see the calendar and then can click a date...

Hi I run Excel 2K I would like to have a situation where in one cell (lets say S4 I have the letter "A") and in another cell (lets say T4, I have the number...

I would like to create an online form that will be printed on existing pre-printed forms (Purchase Orders). I want to be able to display column headings,...

I know how to add gridlines for Excel 2003. However, someone in their infinite wisdom (yeah?!) decided to make Office 2007 products difficult to use, hard...

I have a sumif question. I have several columns of data. I want to sum one column based on another column's criteria but only to want to sum the data of...

Hi, I am trying to create a nested if .. I'm guessing this is what I need but it's not working I am trying to categorize total fees $1,000,000 = A -...

I was sent an Excel spread sheet that used to be in PDF format, now they have converted to Excel and i can open it but get this error when it first opens up....

I have numbers spread thruout col A, with many blank cells in between the data. As time goes on I will add numbers in col B. In most cases there could be a...

When you save an Excel file which has several worksheets in it, are all worksheets saved? Or do you have to save each worksheet one by one? Thank you.