Thread: Chronological Formula
View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by kawaikini View Post
Aloha. We're creating a chronological calendar list tracking small hive beetle populations in beehives. Need formula to find difference between today's row count and previous row count: Current row value minus previous row value, e.g. row 10, column B value minus row 9, column B. Tomorrow, row 11, column B value minus row 10, column B.
Thank you very much.
Hi,


Simply a case of entering =B10-B9 and drag down. It will adjust as it's copied to each row.
Reply With QuoteReply With Quote