Finding a calculated Value across Columns

Hi

Does anyone know of a formula that will display the cell reference of a
given value? Basically I have a schedule running across 4 years (Columns) and
demands for various parts. I have total requirement and stock level calls:
I'd like to be able to say "Find the cell where the Sum of a.....x column is
greater than the stock level"- i.e. when do will we run out. I know I could
use a subtotal for each date but that would mean an extra column and I would
prefer to keep it as automated as possible

Many Thanks

Nigel Wallis wrote:
Hi

Does anyone know of a formula that will display the cell reference of a
given value? Basically I have a schedule running across 4 years (Columns) and
demands for various parts. I have total requirement and stock level calls:
I'd like to be able to say "Find the cell where the Sum of a.....x column is
greater than the stock level"- i.e. when do will we run out. I know I could
use a subtotal for each date but that would mean an extra column and I would
prefer to keep it as automated as possible

Many Thanks


Take a look at this and see if any of it helps:

http://groups.google.com/group/micro...4ea2a43ce06097

Many thanks for replying Glenn.

I think that info might hold the key.

Cheers!

"Glenn" wrote:

Nigel Wallis wrote:
Hi

Does anyone know of a formula that will display the cell reference of a
given value? Basically I have a schedule running across 4 years (Columns) and
demands for various parts. I have total requirement and stock level calls:
I'd like to be able to say "Find the cell where the Sum of a.....x column is
greater than the stock level"- i.e. when do will we run out. I know I could
use a subtotal for each date but that would mean an extra column and I would
prefer to keep it as automated as possible

Many Thanks


Take a look at this and see if any of it helps:

http://groups.google.com/group/micro...4ea2a43ce06097