No problem,

Heres a sample sheet.



So basically the user of the sheet, will hide column H and then add a column between C & D, adding in the days date. Therfore keeping the data we need to be able to query back as far as 10 days (up to column M).

Column B is the one with the formula in it. So for example, Column B, Row 2's formula is:

=IF(COUNTA(INDIRECT("D2:M2"))3,"Training",COUNTA( INDIRECT("D2:M2")))

It's a voicemail update check spreadsheet.

Hope that make sense.

Thanks again