First

Prev 
Next

Last
Pages: 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118
references rename! I have a summary sheet which collects data from identical copies of a main scenario sheet. main is copied to main1, main2, main3 I build the references in this summary sheet as: 'main2'!cell_name When the main sheet is updated, the old copies of it are deleted and replace with the new main. In the mea... 2 Apr 2010 19:19
Compare text in 2 different files I am using Excel 2003 and have two files containing mailing information. I need to check and see which companies are on both lists. I can't use a VLOOKUP formula because some of the company names are slightly different. e.g. One may have a LLC or Inc. at the end and the other doesn't. Is there a formula I can... 2 Apr 2010 17:06
NONFUNCTIONING FORMULA Can anyone help me figure out why a formula would stop functioning? I set up a check register and had the formula =SUM(D2:F2993) to render the balance of the w/d and deposit. It should calculate al the way to row 2993 however row 371 started adding the w/d to the balance. I can not only find the error but I don... 2 Apr 2010 17:06
first some general questions about populating... not sure if i can detail my question here, but here goes.... i have an existing workbook, with existing worksheets with formulas set up etc.....but it is in a fixed number of entries format.....ie we want to record a series of test results, scores, over the course of a year......currently we have 3 variations ... 2 Apr 2010 15:59
Count dates until complete or Cancel (Excel 2003) Is there a way to calculate the days and then stop the counting when you have entered a completion date and/or cancelled appears in the "Status column? I want the duration column to keep calculating the days until either a date is enter into the "Completion Date" Column or the "Status" Column has ... 3 Apr 2010 06:06
Index, Match help I need help with an index, match formula. Worksheet 1 has 8 columns. In ColA is the name, Col 4 is the associated cost center. Worksheet 2 needs to find the cost center based on the name in ColE. I could use a vlookup but the Index Match takes up less space when saved. I am using Excel 2003. Thanks. ... 3 Apr 2010 01:50
COUNTIFS BETWEEN WORKSHEETS HELP How do you specify in a formula to count all cells in one column if values in another column match a value in a particular cell and sum the totals across worksheets. I have tried this formula but something is amiss at the last step. I wanted to only count a value if a date in column M matched the date in cell... 2 Apr 2010 12:38
How do I change the format to allow a zero as a first digit? When I input an ID number, they all start with a zero. Excell automatically removes it. How do I turn off this function? ... 2 Apr 2010 12:38
Weeknum function help Hello, I am trying to show the current week and using this formula: =WEEKNUM(TODAY())1, someday it works, somday it doesn't (return "#NAME?"). Why is that? Is there other alternative? Thanks ... 2 Apr 2010 11:31
Text to Number format I have copied a column of numbers to excel and now cannot apply any formulas because the numbers are text. How can I convert the text to numbers? Thanks.  Janet ... 4 Apr 2010 23:41 