Returning number of blank cells
First of all, thanks once again for all the help I've been receiving over
the last 2 days.
I have a chart with location(column A) and sales information (rows B to P).
I was asked to prepare a function that would only display the month the
blank cells are in. For example, this is what I have:
Location Oct Nov Dec
123 Main St. 2000 5252
324 Yonge St. 6358 2551
432 James St. 9563
This is what I want:
Location Month Not Paid
123 Main St. Dec
324 Yonge St. Nov
432 James St. Nov, Dec
If there's another way I should be going about doing this, please feel free
to advise. Thanks once again.
|