using find and replace it's making me look in another file to upd Utf 0 343
I have used the find and replace function several times in the spreadsheet to update the fromulas monthly. For some reason when I use it this month ...

Checkbook calculations Utf 2 405
I am trying to create an Excel worksheet to calculate my checkbook. I want to be able to enter different transactions and have them added or subtrac...

Count function seeing formulas as data Utf 5 272
Can you change the count function seeing formulas in cells as data. This makes the function completely useless. I have an array 1000 cells X 500 c...

Count function seeing formulas as data Utf 4 292
How can you get around the count function seeing formulas in any cell referenced as data? ...

HELP! having trouble matching info with excel, HELP! Utf 1 282
Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is bl...

xdate in Windows 7 Utf 2 432
I finally entered the world of Windows 7, albeit only because my laptop died. I am a historan who needs to calculate dates into the 18th century. ...

Select a worksheet Utf 2 300
I'm using the below formula to determine the specific type of equipment from a list named: database =IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$...

Complex AND OR Formula Colin 9 300
HI I need to express something in a formula , and am having trouble with it. I need to say this : IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" ...

Remove error notification X7/M7=0 when one or both cell values are Utf 3 273
How to remove error notification when X7/M7=0 when one or both cell values are 0 ...

Moving Column data formula Utf 1 247
I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be...