Using the "IF" function?

[Ruff]

I setup a worksheet like below

A B
1 Jan 123
2 Feb 543
3 Mar 654
4 Apr 456
5 May 645
6 Jun 543
7 Jul 0
8 Aug 0
9 Sep 0
10 Oct 0
11 Nov 0
12 Dec 0
13

When the end of the month, the user will enter some value in the B column,
And now I would to setup a formula at A13, if the user enter the value in
the B7, then the A13 will show Jul, when the user carry on to enter the
value in the B8, then the A13 will change to show Aug, is it possible to
setup a if formula or other formula rather than use the macro to doing this?
Many Thanks.

Ruff

 

[RagDyer]

Try this:

=INDEX(A1:A12,COUNTIF(B1:B12,">0")+1)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Bill Kuunders]

One way

a bit of a workaround

=COUNT(B1:B12)*30-15
format the cell as custom......... mmm

 

[RagDyer]

Sorry, misread your question.
Try this instead:

=INDEX(A1:A12,COUNTIF(B1:B12,">0"))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Bill Kuunders]

oops
if you do have 0's in B7 etc you'll need

=COUNTIF(B1:B12,">0")*30-15