V
Victor Delta
I have an Excel spreadsheet which records monthly meetings with clients. The
clients' names are listed in column A and each column in a certain range
(say G to Z) represents a month. I periodically insert new columns on the
end as necessary (and I should mention that columns B to F and AA and beyond
are used for other data. Meetings are indicated by inserting the date or
some text in the appropriate column. There are often several months between
meetings with a particular clients - indicated by empty cells.
I would like to show in, say, column B, either the month of the last meeting
OR the number of months since the last meeting (it doesn't matter which as
the other can be calculated easily from the first) but am not sure to do
this. I've tried a couple of formulae which did not do what I wanted.
Can anyone please suggest a simple method.
TIA
V
clients' names are listed in column A and each column in a certain range
(say G to Z) represents a month. I periodically insert new columns on the
end as necessary (and I should mention that columns B to F and AA and beyond
are used for other data. Meetings are indicated by inserting the date or
some text in the appropriate column. There are often several months between
meetings with a particular clients - indicated by empty cells.
I would like to show in, say, column B, either the month of the last meeting
OR the number of months since the last meeting (it doesn't matter which as
the other can be calculated easily from the first) but am not sure to do
this. I've tried a couple of formulae which did not do what I wanted.
Can anyone please suggest a simple method.
TIA
V