Howdy Community,
I'm looking for help with a multi something formula, or whatever works best, to identify the largest value for a specific pad. Every pad has several wells and every well has several events. Some events will be null. The number of wells per pad, and events per well can change but I need to identify the largest value per pad regardless of those inconsistencies.
I've attached an example dataset and shown a simple example below. In the example below the "Large" category represents the output I'm looking for from a formula. The other 4 columns are those that are available to me.
| WELL | Pad | Event | Value | Large |
| Well 01 | Pad 1 | Event 1 | 7.5 | YES |
| Well 01 | Pad 1 | Event 2 | | NO |
| Well 01 | Pad 1 | Event 3 | 1 | NO |
| Well 02 | Pad 1 | Event 1 | 2 | NO |
| Well 02 | Pad 1 | Event 2 | | NO |
| Well 02 | Pad 1 | Event 3 | 1 | NO |
| Well 01 | Pad 2 | Event 1 | 6 | NO |
| Well 01 | Pad 2 | Event 2 | 3 | NO |
| Well 02 | Pad 2 | Event 1 | | NO |
| Well 02 | Pad 2 | Event 2 | 9 | YES |
| Well 02 | Pad 2 | Event 3 | 1 | NO |
Any assistance would be much appreciated!
Luke
