I'm interested, for instance, allways to get the last 30 values of a series of values from one column. Everyday, there are more and more records, no constant...

In my workbook it was password protected and able to be unlocked, now when trying to unprotect it the option to unprotect is grayed out 3 other clients are...

Hello, I use Office 2007; i made a combination between an Excel file and a Word one. My problem: After i realised this joining, in Word, the numbers appear...

Hello, I have 2 tabels in Excel, each of them with names of societies. Certain companies appear in both tabels, others of them appear only in one tabel. I...

I'm trying to get excel to calculate the difference between a current date and a pervious date. I want the current date to update automatically. Can this be...

Hello I have two seperate workbooks that need to have the same data in them. Is it possible to enter the numbers in one workbook and have them...

Hi i am having a SUMPRODUCT COUNTIF problem. Previously the formula was missing a single quotation mark between the double quotation marks. Once this was...

I am having some problems getting an Excel function to work properly. I have tried this in Excel 2003 and 2007 so it is not the version that is the...

Hello, Attempting to allocate usage across aging buckets. Below are three invoices for billed consumption with unique period of coverage dates. I am...

I have a spreadsheet that requires someone to input data into certain cells within the sheet. How can I set up the sheet so that when I hit the TAB key it...

I have a form with a few different cells that users enter numbers and other info. Right after they enter these numbers this info should automatically be...

I have a drop down list in cell A1 and I need to copy and paste that list all the way down to A200. Copying and pasting is not working nor is dragging down...

How to l get the properties to show the "previous versions" tab? It was available as an option, which was invaluable as a number of us work on the same...

How to l get the properties of my Microsoft Excel Workbooks to show the "previous versions" tab? It was available as an option, which was invaluable as a...

Business hours is defined as Monday to Friday, 8:00am - 4:30pm. I want to add 12 business hours to the current time (09/05/2006 9:13pm) and return the due...

It might be asking a lot but heres the plan: I want my cell to tell me 2 things (part name and number). When i click on a cell containing a part number is it...

Does anyone know how to use the 'forecast' funcion in Excel 2003? How do you enter the information in order to get an answer?

I have 20 columns which I am using top 10 conditional formatting. When I copy this (B3:T3) down to the bottom of my spreadsheet, the range changes to...

Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?

How do I format part of a cell bold that combined other cells? I have combined strings from various cells into one cell. I jsut want one of the strings...