Recording previous value of a group of cells into one cell

**hammer2** · 09-05-2011, 08:21 AM

Hi all,

Column S: Cells S5 to S40 will have a value ranging from 0 to ? .....There will only ever be one figure greater than zero ie they will always be of equal value. eg 0,0,0,2,2,0,2,0,etc These cells are automatically updated from another program.

In Cell AE5 only, I want to be able to record the PREVIOUS value (above zero) from the above range. So each time my program updates Column S, Cell AE5 will record the previous figure that was above zero.

I would need the complete dummies step by step guide to be able to input the code please.

Many thanks
Hammer

**hammer2** · 09-07-2011, 06:52 AM

Bump..............

**inayat** · 09-07-2011, 07:25 AM

Ok here is the answer. I dont think that this is the best way, but it will work. Explanation Follows:
Column A has Serial No. (Not required, I have given this just to let you know where is the highest Value)
Column B has the value that your program will give
In column C I have given the formula to detect if the corresponding value in Column B is greater than ZERO. If that condition is met, then the formula will list out the Row Number.
In D3 I have given the formula to check the highest number in Column C. Since you want the latest value greater than ZERO, it will give the S.no of that value in the range. I have used Max formula to calculate the maximum value.

I hope this helps. Attached is the workbook. Let me know if you have any questions. Again this may not be the best way as one more column is required but it will work.

Cheers

**hammer2** · 09-07-2011, 10:33 PM

Thanks for your time inayat.
Much appreciated, but I must apologise because I actually have messed up what I was wanting.
I will mark this solved and create a new thread.