This formula should work: =AVERAGE(OFFSET($B$2,(ROW(A1)-1)*3,,4)) this averages range B2:B5 copying down will automatically change it...

After entering data into the active cell, pressing the tab key moves the selection to the right, but pressing the enter key does not move the selection at...

How do I reconcile two sheets with in a .xls book?

One worksheet has 600 + lines with a lot of expenses, including SOME of the local expenses. This is a check register.. Another worksheet has 300 + lines with...

Is there any way to "tone down" the code that Excel 2002 creates when saving a worksheet as a web page? We converted to Excel 2002 this past year at work and...

In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how...

How can we hide pre-selected groups of graphics elements with the touch of a cell or control? We have two distinct groups of rectangles with gradient fills. ...

Hi! I could use some help with filters. I have a spreadsheet I distributed to others to complete and return to me. Once I got the copies back I combined...

I've exported a load of data into excel but the info in the columns I want in rows and vice versa. I'm sure there must be an easy way to flip them.. Can...

How can I write a formula for a column of colors, (some have numbers, some don't) that will go down the column and look for Interior.ColorIndex 36 (light...

When a user selects the 14-Mar-01 standard date format in Excel 2007, then selects the custom format option, this is the standard format that...

XP now has the ability to do a find & replace based on formatting, but i ran across an issue. If I type the word accountant in cell A1 and "accountants are...

Is there a formula to obtain a total for each quarter which excludes including the year? Thus avoiding having to change to year on a yearly basis. Your...

We have a large number of files used in product costing, which have been created in Quatro Pro 7. We would like to begin using Excel, instead of Quatro Pro. ...

Hello, I want to find the maximum value in a column, but I want to ignore the negative and positive part of the value. Basically, the maximum difference from...

Hello there, I am using IF function to return values as digits. Now I need the sum of such digits in a coloumn. Pease help me to do this. Thank you Jeevan

I created a hyperlink to a pdf file ,it flashes and closes whats wrong??? \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make...

Excel 2002 SP3, CSV File, Format Cell 'Special' for Zip Code Leading Zero does not work. Is there any way to maintain the Zip Code Leading Zero (New England...

why would a value in a cell as shown here 8212.0011( return a value of 8212.00110000.00 when the ( character was deleted from the cell? The version of excel...