excel formula question

Hi, I have a worksheet with thousands of rows. Each row contains several cells with formulas that reference other cells on that row. For example, cell E1 has this formula: =A1+B1. Cell F1 has this formula: =C1+D1. The same kinds of formulas appear on each row. For example, cell E100 has this...

Hi, I have a large pool of data and if I graph the data i can see an oscillating patern. How can I let Excel find the oscillating formula? Cheers, Dutchmountain

Hi Team, Hi I am trying to create a formula to find the net chargeable amount. Lets say <colgroup><col></colgroup><tbody> A2=Chargeable weight B2= price per kilo post 15 kilos for the 1st 5 kilos C2= price per kilo after that </tbody> e.g. If the total weight is 25 kgs, I want the formula...

Hi Guys, I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...

I have a problem that seems to have beaten me. I have a number of compounds that are tested at different concentrations and I need, that if one concentration fails then they all do. <colgroup><col span="2"><col><col><col><col></colgroup><tbody> Sample Enzyme Mean%Act Rep QC Enzyme QC QC Flag...

It seems confusing but should be simple even I can't find a way to get it done :) Basically I have: column B with values (estimated Duration) Column C to L I have markers in the cells either "x" or "" What I want is to automate a way at the end of each Column C to L (Totals) If there are...