View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Climber of Mtns[_2_] Climber of Mtns[_2_] is offline
external usenet poster
 
Posts: 1
Default I need a formula to determine when the data was last changed

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
a
Date Entity Name Count (numerical)

Thanks in advance for any suggestions
A B C