Finding a calculated Value across Columns

[Nigel Wallis]

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

 

[Glenn]

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/micr...nctions/browse_thread/thread/864ea2a43ce06097

 

[Nigel Wallis]

Many thanks for replying Glenn.

I think that info might hold the key.

Cheers!