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.