I need a formula to determine when the data was last changed

  • Thread starter Climber of Mtns
  • Start date
C

Climber of Mtns

First, thanks to all those that help users on this forum. I have found many
answer to my questions on the office discussion groups. But, I need some
assistance with this one.
I have a sheet where I need to determine when the last update (count change)
occured. The sheet contains data for weekly counts and I am trying to create
a "last updated" and a "update amount" columns. I need to determine the date
of the last change in the count for all the entities. (does C2=C3, then get
the date from A3 and difference between C3 and C2 . All entities are counted
every week but not all the counts change from the previous week. The columns
are:
Date Entity Name Count (numerical)

Thanks in advance for any suggestions
A B C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top