View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Handy Handy is offline
external usenet poster
 
Posts: 3
Default Retaining metrics for each month

What condition can be used to keep a cells evaluation status within that
month even if it changes the next month. For example if A2 = "evaluated" in
January but changes to "completed" in February, how can you retain that
evaluated status for the month of January even after it changes during a
later month?