ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula for displaying the lowest number of a range? (https://www.excelbanter.com/excel-worksheet-functions/23504-formula-displaying-lowest-number-range.html)

coal_miner

Formula for displaying the lowest number of a range?
 
I need some formula help for a worksheet I am setting up. I have multiple
tabs for a worksheet, and I have an injury report on each tab. On each
injury I track the last day with out an injury, and I need a formula for my
summary page that can take all the different injury reports and determine
which has been the least amount of days since last injury and display it.
Any help would be greatly appreciated. Thanks.

Bob Phillips

On the summary page, add the injury, last date of injury, and a calculation
of days since injury. It is a simple Min then.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"coal_miner" wrote in message
...
I need some formula help for a worksheet I am setting up. I have multiple
tabs for a worksheet, and I have an injury report on each tab. On each
injury I track the last day with out an injury, and I need a formula for

my
summary page that can take all the different injury reports and determine
which has been the least amount of days since last injury and display it.
Any help would be greatly appreciated. Thanks.





All times are GMT +1. The time now is 01:16 PM.

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