Hi Max

One way
Insert 2 rows above your data, so that Jan to Dec is in row 3.
In cell A2 enter
=COUNTA(A4:A1004)
In cell A1 enter
=COLUMN()*(A20)
copy A1:A2 through B1:L1
Now, if there is any data at all in the columns, the column number will
appear in row 1, otherwise it will be zero.
To find the number of months prior to December that data has been
entered, then
In cell M1 enter
=12-Max(A1:K1)

--
Regards

Roger Govier


"Max_power"
wrote in message
...

Thanks for the response.

Lets say I have months jan:Dec which are A:L respectively
I'll have data in most of the rows from A to L

I just want to have formula whereby I pick say the last month and find
when the last occurance of data was entered ie what month.

So if I pick December as the starting point, if nothing was entered in
the cell corresponding to Nov, or Oct but it does in September it will
return 3 ie 3 months have passed since data has been entered.

Many thanks for any help on the matter

Max


--
Max_power
------------------------------------------------------------------------
Max_power's Profile:
http://www.excelforum.com/member.php...o&userid=32255
View this thread:
http://www.excelforum.com/showthread...hreadid=535551