Dear Microsoft: We've been forced to use user-built functions to try to access information in closed workbooks using referenced cells (INDIRECT.EXT). We do...

Hi everyone! I'm trying to make references from one book to another by using the INDIRECT function, but I found out it doesn't work when the source book is...

Hi All, I'm trying to summarise timesheets in a spreadsheet, but having trouble in a few areas. We work on flexible time, therefore at the end of the month...

I am trying to create a VLOOKUP - I want the Table Array to search C:C (all of column c) - I keep getting an error. Am I doing this incorrectly?

I need a formula to sum values in the same column on multiple sheets if it finds a specified value in the same row of a different column. SUMIF works fine if I...

I am using the following formulaeto report the cost value in cell E2 which is a calculated value. ="Average Cost ="&" "&(E2) I get in return Average Cost =...

This is a real beginners question, but I can't figure out what to do from the Excel Help, so ... Just exactly what are the steps to get TREND to return...

What is size limit for textbox in excel 2003

Column A = numeric list 0-96 Column B = alphabetically ascending list of text I use a drop down list (numbers from A) in conjunction with a VLOOKUP (A and B)...

Hi all, I want to draw a random sample of size 10 (suppose) from a population having members : 1, 2, 3, and 4, where I assume following: Probability that 1...

I have a macro tht runs perfectly on three different machines, but whenever we try to run it on fourth (all machines have same version of excel) it fails and...

Hi, I hope that this should be quite easy, but I'll be blowed if I can find an answer on google... Column F has dates, some rows may be blank Column G has...

Hi, In a workbook with many worksheets, all of which are protected, I was wondering if it was possible to display (perhaps in A1) a letter or symbol to...

I would like to fill data (of cell A1 - for example) into the entire column below it (cell A2 until the end---in excel 2002 until cell A65536; in excel 2007...

I have a 75+ worksheet 2003 workbook that recently stopped reliably updating linked formulas and recalculating function formulas. "CALCULATE" appears in the...

Hi to everyone, I'm using this code to add dates in a rage of cells. It uses a calendar control to fill in dates. I found it to this web-site:...

I have 2 cells, 1 headed "Quarter", the other headed "Year" in whcih a user will enter 1, 2, 3 or 4 in the first cell and the year in the 2nd cell...

I would like to fill data (of cell A1 - for example) into the entire column below it (cell A2 until the end---in excel 2002 untill cell A65536; in excel 2007...

I am using =TODAY()-B5 in Excel 2000 and getting extra month in the count I am using the Formula =TODAY()-B2 to display a running time (YR – MO – Days)...

I have a function that works fine: =IF(ISERROR(VLOOKUP(G3,'Sheet1'!$C$1:$D$30,2,0)),"",VLOOKUP(G3,'Sheet1'!$C$1:$D$30,2,0)) My difficulty is, I want to expand...