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

Try this:

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

--
HTH,

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


"Ruff" wrote in message
...
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

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!
==============================================



"RagDyer" wrote in message
...
Try this:

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

--
HTH,

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


"Ruff" wrote in message
...
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

One way

a bit of a workaround

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

--
Greetings from New Zealand
Bill K

"Ruff" wrote in message
...
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

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

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

--
Greetings from New Zealand
Bill K

"Ruff" wrote in message
...
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