I want to average all the "Total" "ABS Qty" only. The "Total" quantity is a subtotal formula. In other words, (14+2+2+16+10)/5=8.8 ABS...

I am trying to delete all rows where the value of one of the cells equals zero, is there a formula for this?

The formula returns a 0. I need it to return $38,241.51 =SUMPRODUCT((Data!B1:B20000="ABC Company")*(Data!Q1:Q20000="Apr-08")*(L1:L20000))The formula...

Does anyone know of a method of getting tab titles to update automatically to changes in worksheet contents? i.e. if I have a worksheet with a list of words...

I would like to "paste" selected graphic images into the comment box within a cell in an excel spread sheet

Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the...

Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry

Printing multiple pages (2x2) double sided with single sided printer?

How do I freeze two different rows in same sheet. -- Naidu

Hi, I have column D with 24000 rows ( D1 to D24000 ). I need to reduce all the values already entered in that column by 5%. I have 07 Microsoft Office and I...

Hi I am trying to work out a formula where say for example A1 3 B1 2 In a different sheet I have a table that says for this combination it must return a...

I have Excel 2007 with Vista and want to email just a single worksheet, not the entire workbook - How do I do that? Someone suggested I could do it thru...

I want to enter a number in one cell and then in different cells have each number appear. For example, I type 12345 in one cell and then have 1 in a cell, 2...

I have thousand of rows as follow: Sheet1 Product ...

Hi, Can anyone help in doing sum of daily data with respect to weekdays. I want to get the sum of everydays data as week1, week2..etc. for that...

I jumped on the Excel (VBA) bandwagon some years ago. I have dozens of books and reference them constantly. In no book or in my visiting any newsgroup have I...

Anyone else having trouble with the private newsgroups? -- Biff Microsoft Excel MVP

If I have 8,64 and I need to round the number to 8,65? Or if I have 3,21 and round the number to the nearest 5 to 3,25 How can be done?

Hi all, I am learning Excel/VBA via using it in real day-to-day work. Two questions: 1. How to multiple a whole range of cells by 2 all together and all...

I am trying to get a formula which calculates the difference of two dates in dd/mm/yy format. Eg: I have 'Joining Date' and 'Resigned Date' in A1 & B1...