Please forgive me if I don't use proper Newsgroup protocol. This is my first time. I have developed a comprehensive dealership system using Excel. I...

Hi, anyone who know the solution below ? Start Date End Date 01.01.10~31.12.10 01.01,11~31.12.11 1)01/10/09 31/01/10 ...

Tenho uma tabela de valores acumulados como posso elaborar um grafico de pareto ou diagrama de pareto utilizando o excel 2007 home and student?

How can I insert a drop down calendar to a cell in a worksheet?

Hi Bob, I thought someone might suggest this but I feel the whole workbook will need to be evaluated as it's turned into a rather complicated nightmare. The...

I am looking to set up up some sort of database that will alow me to enter data in Excel on one page and automatically enter this into a certificate which I...

Text aligns in middle of cells even when bottom alignment is chosen in Excel 2007. How can I get text to align on the bottom of the cell?

Is there a way to allow rows to break across a page in Excel 2007?

I have developed a rule for a column of data. =$ak$7:$ak$11 =$ak$4:$ak$6 I want to repeat this same rule to adjacent columns, AL thru AS. Then I want to repeat...

Hey. I have office 2003. Was wondering how do you remove all duplicates? I have a column with the names of the employees, and another column with the names...

I am trying to copy/paste the filtered (subtotals) on my worksheet of about 17,000 rows. I do this every week. Unfortunately, I am getting the following...

I want to wite sample accross my spreadsheet however do not know how to do this

Hi. I have a column where I have names and surnames. I want to put name in one column and surname in anoter column. In order to do this, I use Text to...

Hi this is one of several merge cell drawbacks. No real workaround available. Try avoiding merged cells! -- Regards Frank Kabel Frankfurt, Germany

The navigation buttons in Excel 2007 do not seem to work the way they did in Excel 2003. I have tried them on multiple computers. I know about right-clicking...

I have custom macros that are saved in an .xls file under the XLStart/ folder in Excel 2003. These macros are referenced by an Excel11.xlb file that holds...

please i want to know how i convert number to text in excel datasheet or access for example : 1235.75 one thousand two hundred thirty five and 75/100 thank...

I need to know how to create subtotals for individual pages in excel. The user has data each month consisting of hundereds of rows. Is it possible to have...

I have a spreadsheet with several hundred rows and many columns. The formula in column "C" sums values for all columns from "D" through the last column for...

Hi, SUMPRODUCT(--(S3:S44="A"),--(E3:M44100),--(E3:M44=200))/SUMPRODUCT(--(S3:S44="A"),--(E3:M44"")) doesn't work unless it is E3:E44 Looking to modify...