ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Chronological Formula (https://www.excelbanter.com/excel-worksheet-functions/446584-chronological-formula.html)

kawaikini
Chronological Formula
 
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.

Spencer101
Quote:
Originally Posted by kawaikini (Post 1603697)
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.


All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com