Problem: Sheet1 A1:I1 are data entry, J1=Sheet1J1-Sheet1I1+Sheet2G1 Sheet2 G2 is data entry Sheet2 A1=IF(Sheet1J1-Sheet1I1+Sheet2G1=0,A1," ") ...

Hello, I'm using Excel 2003 and need help on an If statement or not sure whether I should use a Vlook Up table. I have 2 spreadsheets. The first has a list...

Hello everyone, I have a table set up for which is use the below code to retrieve data, depending on the info I...

I have a spreadsheet with a 450 rows and 2 columns The first column is a list of sites and the second is a list dates (2003-2007). The second sheet is a...

Hi folks. I believe I have a simple question here. I hope someone can help: I have two cells of data. For simplicity's sake let's say: A1 is 5 B1 is 10 I'd...

How can I protect range of cells in a worksheet - Thanks

I am having a bit of difficulty with a project I'm working on. After selecting a category from list1 and an item from list2 on sheet1, I want a given range...

I need to sum only the values that are visible after i have applied the autofilter.

I have A copy of the sheet I am working on and it may show what i need better than I can explain, if the cell has a zero in it I need the formula to find the...

I want to select the last entry in a column, and insert this value into a formula elsewhere. A new number is added daily to this column. There are empty...

Helloo everybody I want SUM(A1:the value entered i C1). Say if C1=6, SUM(A1:A6). I tried SUM(A1:address(c1,1)), resulted in error. Any suggestions...

I am trying to get the correct amount by using the following formula: =c3/d3 to get percentage amount c3 is 12.74 d3 is 19.81 my percentage in e3 equals 64%...

I have a list of fire events that I need to sort by year. The date field for each event is formated as mm-dd-yyyy. I can't figure out how to restrict the...

How does one use the RTD Function in Office 2007? Thanks, Joe

Is there a formula that I could use to perform the following. In one spreadsheet I have a unique no e.g.1018. In another spreadsheet I have lots of rows...

Hi, I'm struggling with an error on exponential computation and need an expert's help. One of my investment's holdings is minus. ^^;; When I tried to...

i am trying to do a lookup function for a chart i use. what i am trying to do is create a list of counts that i do on parts for work. at the moment i can...

Hi I tried the suggestions that were given to me. The only problem is that they will show a percentage in .00 instead of %. They want me to get the the...

I was wondering if their is a good EXCEL Formula websites out their. I found some but they didn't list a lot of formulas. So where is the secret page on...

Hello again Is there a function that will look up a column and then use the next cell it finds with a number greater than 0, so if I have a column b1 through...