About half my queries come back with the #VALUE error, but I cannot find out why or how to correct. The Help section does not cover this topic well enough. I...

Hello: I have 2 worksheets. The first is a product price data sheet and the second the clients product usage sheet. My task is to get the price of the...

I have a workbook containing 12 worksheets, one for every month of the year. Each worksheet contains several columns containing: Date, Credit (value), Credit...

Previously posted in microsoft.public.excel.worksheetfunctions but I didn't get any response, so I'm trying another group in case I posted to the wrong one. ...

I'm trying to create a template which contains some cells with formulas. Because the contents of the cells in which the formulas reference are currently empty,...

we are importing a pivot table from column c & d How an we configure colun c minus column d

Hi Excel Forum, What do the two dashes (--) mean and do in the following formulas: =SUMPRODUCT(--A1:G1) =SUM(IF(ISNUMBER(--A1:G1),--A1:G1)) entered with...

Is anyone aware of any tutorials on formulas? I am especially interested in the "IF" scenarios. Thank you.

I'm trying to work with the formula: =SUMIF(B3:B500,??????????????,G3:G500) I want to be able to calculate data between two dates, let’s say between 1 July...

hi, is there a function that does this if a1=1, if true a2=b1, if false a2 stays as it was (EITHER WITH A ZERO VALUE OR THE VALUE THAT MAY HAVE BEEN ENTER...

hello there. i have a spreadsheet that is located on my hard drive. when i click on it, excel opens up but the data and tool bars will not load. also when i...

I am using Excel 97 with OS WINNT. I have recorded a macro which copies the first sheet called "Daily" from my source workbook to a new workbook, names this...

Do anybody knows how can I execute automaticaly a macro when a worksheet is opened. Thanks Rubens Araujo

Hi, Every time I click on a shortcut link to a spread sheet, whether on the desktop or from e-mail I get a message that says "A document with the same...

I'm recording the time I spend working on a piece of work in a spreadsheet along with meeting details etc. I've 2 columns that are start and finish times and a...

Hi. I've been handed an excel file that needs tweaking. Was wondering if someone here could help. This xls file consists of 7 worksheets, one of every day...

In row 1 I have my column names. What I want is to be able to scroll through my spreadsheet without having this row move so when I am at the bottom of my...

I've run into a problem trying to copy data from a cell in one sheet to another. I have a spreadsheet called "rating" which contains a number of formula...

Is there a macro or other way (short of cutting & pasting) of putting address book entries into a row format. For example: John Smith 123 Main...

Hi, I want to do an index for molecular formulas. Normally I import a file (.csv) and I have one column (text)...