I would like to determine a percentage in Excel that is based on
multiple conditions.  This is for a serious a products on different
displays and the quantity on those displays.  I need to know out of
all the stores surveyed, what percentage of those stores had a lobby

Any good cap gains templates around?
Thanks.

I have few workbooks in the same folder.
One of the books is "statistics" with only one sheet "sheet1". I gather
information from all the other workbooks in that folder.
If I copy all the workbooks to another drive and another folder,

Is it possible or is there any formula, if you enter a time range,say about
9hrs in a day, u can get a desired or scheduled breaks of 30mins, 15mins
break time calculated in tht 9hrs?
If somebody can help me, please mail me or contact me at

I am using Excel 2003.
I am trying to output a print area from my spreadsheet to a PDF file, but I
can't seem to find a way to automatically or even semi-automatically specify
the filename. I generate the path and filename in Excel.

Any way to use a spreadsheets cell info as a header (or footer) field?

I'm modeling a french roulette in excel and when defining the events the
function "iseven" when the value is zero returns "true".
On a strict sense 0/N=0 and 0+2=Even but for roulette purposes, zero (or
double zero) is neither even or odd.

I am in Book2 in sheet1 cell D4. I need to copy a value from another place.
What formula do I need to copy cell K67 from the CLOSED workbook named
"Book1" from "sheet2" where sheet2 is protected with a password
TO

I am trying to use ODBC to query an Excel spreadsheet. The ODBC driver
looks at the first 8 rows in each column to determine the datatype. I
have mixed numbers and text, but the driver thinks the column is
numeric. As a result, text entries are not returned.

I have a list of items in column a. Every time a value occurs I need
to return the value in column B to my sublist in another sheet. Here
is what I'm talking about - my list would look like this
A            B

on the J. Walkenbach's page
http://www.j-walk.com/ss/excel/usertips/tip068.htm you can see the Joel
Horowitz's  method of transforming the matrix data back to the dataset
table. Although this method is somehow the inverse of "pivot table method",

I've just bought and installed Office 2007 Enterprise and I'm
experiencing some strange things in Excel. For example, when I press
the Ctrl-S key combination, which would normally just save the sheet,
I get a warning (exclamation mark in yellow triangle) dialog box with

Compared with Excel 2007 install on Vista and Excel 2007 installed on XP. The
font color of Vista is darker and sharper than XP. Besides, the color of the
toolbar's background also vary.
The difference of the font color is obvious specially when the font size is

Trying to convert a program written over 20 years ago from Lotus 1.2.3 into
Excel 2000.  Problem is I can't find the verbage for the visual basic command
for going to a database and finding only certain criteria, copying it and
pasting it into another sheet.  Example:  Each ...

Dear Reader
Do you know whether there is a function that counts only the filtered
elements of a column and not the whole column?
Regards