Using the "IF" function?
hi vezerid,
Thanks for your reply, maybe not detail enough I wrote the mail before.
Actually I want the cell A13 automatically detect the B1:B12, each month I
the value in the B column, A13 will detect if the cell not equal to 0, then
it show the A column text. That mean last step B7 get the value it show A7
value in A13, if I carry on to enter the value in B8, then A13 show the A8
value.
Thank you so much.
Ruff
"vezerid" ¼¶¼g©ó¶l¥ó·s»D
.com...
Ruff,
I understand that the months will be filled in chronological order.
Hence you want the last month entered.
The formula I am suggesting for A13 is an array formula, i.e. you need
to enter it with Shift+Ctrl+Enter
=INDEX(B1:B12,MAX(ROW(1:12)*--(B1:B12<0)))
HTH
Kostis V
|