Hi I guess most things can be done but what I need to know is urgent and I hope someone may be able to assist quickly, I have a speard sheet with a grid...

This should be simple, but it’s defeating me. Column A is a date, Column C is text, Column F is a number, and column G is =IF(C10="Sales",F10/9,"") In a...

I'm looking for a formula (I think a formula, or some other way) whereby I enter data in one cell on one worksheet and it simultaneously (or after a...

I have several columns with zero values (0), and one column that contains text value. On another cell, I would like to have a formula/function that searches...

I working on a baseball scoresheet. I want cell Q2 to read the cell contents in column H of the active row, as I move the active cell up and down the rows...

Is it possible to obtain a quote on a CD using its CUSIP with the MSN Money Stock Quotes add-in? I've tried "/6616393", ".6616393" and just "6616393"; none of...

I'm not sure if this question belongs to microsoft.public.excel.programming or to here. I want to do a simple recode operation. in a matrix, I want to...

Hello! I'm not sure where I should ask this, but thought I'd try here to see if anyone knows what's up. My spreadsheet has always been able to pull down 30...

I have a inherited worksheet that has the following names that are global. Does anyone know what it would mean. Name ...

I am trying to count the number of times both col a and col b have a 1 in them on the same day. The spreadsheet has three columns A=Date C=1 or blank,D=1or...

I have a Database listing that shows Sales of Products by location by Date. I want to extract from this a total for each item by location by Date My...

Is there a "Table of Contents" function for sheets, so if I have Sheet1 cells with the names of the other sheets, I click on the sheet name and it goes to that...

Is it possible to move a Comment Box that is displayed, via code? I have a number of sheets that I copy, but each time I do, the Comment Boxes (on the Export...

Hi, people...this is the second time I post this because the other one didn't go through. I've added this formula to an Excel...

Excel on XP: I want the user to enter a sequence of random integers into cell A1 and have the spreadsheet record their maximum. So in B1 I placed the formula...

I am currently using the formula =SUMPRODUCT((--$J$5:$J$4000=$T$4007)*($AS$5:$AS$40000)*($AS$5:$AS$4000)) Column J is employee Id and could be formated as...

Can anybody help me to convert a table to a list? For example: Table: Red Black VW 100 20 Toyota 15 50 to become:

Newsgroupers I have a worksheet with 50 records. The last 5 records are on the final end of the page and were filled in as a footer for this page. Now I had...

is there a way to make excel remember to copy formulas down by itself, so I don't have to do it when I reach the bottom of how far I copied the first...