Functions

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