Filtering to show changed cells - is it possible without resorting to macros

[DerfNotwen]

We have a reporting spreadsheet, used by our PMs, with a text input cell for the PM to provide a brief update on the week's activities.

I know I can Track Changes, which will put a small flag on a changed cell, but is there a way that can feed into another column/cell to show that the status has been Updated. This can then be filtered to show who has or has not updated their status that week.

If at all possible without having to resort to macros.

TIA

Derf

 

[ranman256]

filters.
pivot.

 

[DerfNotwen]

Whilst I understand both those terms, in relation to the above query, I'm at a loss as to how to interpret/implement