using find and replace it's making me look in another file to upd01622 (6/6/2010 5:22:33 PM) UtfI 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 it
wants me to look in another file to "update values"? T...

Trying to get this if statment to work21662 (6/5/2010 6:29:43 PM) CerealkillerI have excel 2000. I am trying to get this formula to work. It does not give
me any errors or anything It just will not return the number in the cell that
it references
Cell CJ44 has the formula
Here is...

Checkbook calculations21857 (6/6/2010 4:06:19 PM) UtfI 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 subtracted
from my balance, as well as keep a running balance. An...

Complex AND OR Formula91913 (6/5/2010 9:07:18 PM) Colin
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" OR "4BX" AND J2 =11 THEN PUT 1 ,
OTHERWISE PUT J2
Can s...

maintaining constant percentage11761 (6/5/2010 4:43:08 AM) SF123(1)Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 1...

Select a worksheet21711 (6/5/2010 10:22:00 PM) UtfI'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$2,"Desktop",IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$5,"N...

Count function seeing formulas as data - 1694051388 (6/6/2010 12:52:02 PM) UtfCan 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
cells. I need the count function to check on the number of oc...

HELP! having trouble matching info with excel, HELP!11248 (6/6/2010 8:13:08 AM) UtfHi, 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 blank.
File 2, has ID numbers in column C and column D has ...

xdate in Windows 722258 (6/6/2010 12:47:50 AM) UtfI 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. Xdate
always worked just fine in Excel 2003, but when I lo...

Calculating pay dates41621 (5/28/2010 1:08:01 AM) UtfIf a date is a friday, I want to display the previous Thursday (MM/DD/YYYY).
If a date is a Saturday - Thursday, I want to display the Thursday as a date
(MM/DD/YYYY).
To illustrate, if the date is 05/2...

Totaling columns41379 (6/5/2010 2:22:54 AM) UtfI was so impressed with the wonderful responses and spot on answers to my
first question on this site I thought I would give this one a try. I did try
to research to find this on the site, but perhaps I am...

Moving Column data formula11518 (6/5/2010 7:49:23 PM) Utf 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
completed. Is there a formula that can check each row in c...

Weibull function in Excel32757 (6/5/2010 1:44:21 AM) UtfI have a survival dataset (see below). I want to fit to Weibull function
S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
gamma=2.32. If I use a method tranforming probability to Ln(Ln(...

Help using the LARGE function "WITHOUT" using an array61320 (6/3/2010 1:40:06 AM) exceluserCan someone show me how to accomplish the following by using the LARGE
function "WITHOUT" using an array ?
I'm trying to rank each product (most, second most, etc.) by weight.
Data worksheet
A...