| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | Excel Worksheet Functions | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | Excel Discussion (Misc queries) | |||
| Using formula to calculate a number. | Excel Worksheet Functions | |||
| need help with formula | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Linear Mode
