Is there a problem with using dates in IF statements? I'm trying to ask Excel to record 0 if the date is 9/9/99, and if it's not 9/9/99 put in the content of...

Hi! I've got a huge excel file with inventory items in one column, and quantities in the next column. I need to be able to do two things: 1) Be able to find a...

Dear Sir, I want to use sumif function inside sumproduct function Pls help me out

All, Let's assume I have a bunch of dates in column A. For Example: A 1 10/02/03 2 11/15/04 3 12/31/04 4 01/04/03 5

I have a spreadsheet that contains peoples names and birthdates as follows: John 3/17/75 Jane 5/1/55 etc. I would like to do two things. First, I would like...

Hi, I think this should be easy but I've had a long day...... I've got two columns A) Subject and B) Score. Within column A there are multiple subjects and...

Hey guys. I have a question regarding the SEARCH function. I am trying to parse through data in an excel spreadsheet in order to look for certain characters....

can u tell me the procedure to save a macro

I am not an expert at excel, but I want to lock certain cells, once the value of a different cell that makes reference in a formula to these cells reaches 0. ...

I am trying to calculate interest using 2 interest rates in 1 calendar year. Example: Lets say that from January 1, 2005 through June 30, 2005 the interest...

Hello, it will be nice if i can format the Worksheet tabs in multiple rows. Currently tabs of worksheets are linear and sometimes continue forever. This...

I'm trying to create a formula that returns a value if a number is greater that one value and less than another. Any suggestions? Thanks -- JerryS

Ok I have a situation where I would like to call a specific worksheet using a reference to another cell as the worksheet name. In the case that I am working...

I have a Template and when I open it up I want it to be able to insert the date in a specific cell on open and not have to type it in. Is this...

Ques.. When you have a column on the master sheet, how do you copy that column to other sheets so that when you make a change to the column of the...

I am trying to figure out how write a macro for the following things to happen: _Column_1_ _-Column_2-_ _*Column_3*_ word1 ...

Hello, I have a formula working where I am looking for a Match of one item...I would like to add 2 more items that need to match. Is there a way to add...

Hallo everybody! Any idea if it´s possible to get more then 65500 cells out of excel or is it impossible? Sweden -- Sweden

I have a number of spreadsheets that I need to merge. I have a master spreadsheet with 37 columns of data required. On the other spreadsheets there is a...

i have two colums of increasing numbers. the first time column b is greater than column a i want to put an arrow in the next column. So far whatever i do it...