On 02 Jan 2004 18:54:59 GMT, "Azad Saleh" wrote: Path:...

The Indirect function does not seem to work for a range of worksheets. For example, Sum(Jan!:Aug!A4) works for summing all the A4's on the worksheets between...

Excel 2000 I want to create a combo box in sheet1 that will list the values in sheet2!a1:a7 and let the user select one of the items to populate the combo...

I would like to write a formula that will put the name of the sheet on that page. i.e. the sheet name is "Base Case", I would like to put a function in...

is there a function to have the last entry in a row on sheet1 to auto-populate to a designated cell on sheet 2?

is it possible to set up the TEXT worksheet function so that the string length it returns is the same wnether the value it is translating is positive or...

I have recorded some macros that I will like for it to run at a given time. Example 01/02/04 at 5.00pm. Is this possible and where in the recorded macro should...

I had that same problem. I eventually resolved it using the sum funtion in combination with the offset funtion. The offset function allows "sum" cells that are...

Nest them together by using the find number as the last number in the formula -- Don Guillett SalesAid Software "CRS" wrote in...

Happy New Year to All!!!, I want to make a formula for the following column. A B C D E F 1 Date Ring H1 Consn. Ring...

I have a basic query that I've set up in Excel, using Microsoft Query, that uses a parameter (state) that is stored in another cell. I can't figure out how to...

:confused: Hi All, I am in need to assistance once again, could some please help me with the following I am wanting to copy a value that is worked out of a...

I need to sum the number of occurances of a problem based on a product code in the col. to the left. This also needs to only sum if it happened between two...

I'd like to create a formula in a cell that is determined by a row value in a different cell. I think it will use something involving quotes and ampersands,...

Hi I am able, using data validation, to restrict input into a cell to 30 characters and display warnings and error messages. However, it allows the person...

I am trying to merge two workbooks. Under Tools option, Compare and Merge Workbooks option is grayed out. How I can turn is on? TIA

Can you multiply TIME format with Currency format? New to show and automate hours and dollars in payroll sheet. Thanks!

I have 12 columns with dates in each cell (1 row). I'd like to write a formula that would look at row of dates (12 cells worth), determine which date is the...

Can someone tell me how to compute CAGR using Excel?

My first guess is that this new pivottable isn't named "pivottable5". If it's the only one on the worksheet, then maybe this'll...