Okay, so adjust it
=INDEX($C2:$N2,1,MONTH(TODAY()))
--
HTH
RP
(remove nothere from the email address if mailing direct)
=INDEX($1:$1,1,MAX(($C2:$N2<"")*(COLUMN($C2:$N2)) ))
which is an array formula so commit with Ctrl-Shift-Enter
"srinivasan" wrote in message
...
"Bob Phillips" wrote:
For row 2
=INDEX($C2:$N2,1,MONTH(TODAY()))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"srinivasan" wrote in message
...
I am having a work sheet with each column representing a month from
January
to December. i.e from C column to N column) The list of branch offices
are
indicated in column B.The details of sales from various branch offices
are
fed against each month in the corresponding row. Some offices report
the
details promptly while many report belatedly. My requirement is that
at a
glance I want to know the latest month for which the details are recd
from
branch office to be indicated in the last column next to December by a
formula( month name not figures). Is this possible? Thanks for the
respondents in advance.
No. this does not work.The formula should see if there is any figures in
a column and if so it should indicate the month noted against the same in
the top row
|