Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 114
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello all
I have a sheet with some 10-20 GROUPS (DATE tab - group/ungroup) I want to be able search for the min value of the dates within a certain group. I would like to do this with a simple formula, but also one that is transferable to other cells without needing to be altered.
Right now I am simply using =MIN(F1:F5) and then changing the formula for the next group (ie, =MIN(F7:F10)). The GROUP sizes are not uniform and so that formula does not copy without alteration, which is what I want to avoid.
Help please
I have a sheet with some 10-20 GROUPS (DATE tab - group/ungroup) I want to be able search for the min value of the dates within a certain group. I would like to do this with a simple formula, but also one that is transferable to other cells without needing to be altered.
Right now I am simply using =MIN(F1:F5) and then changing the formula for the next group (ie, =MIN(F7:F10)). The GROUP sizes are not uniform and so that formula does not copy without alteration, which is what I want to avoid.
Help please