I have hundreds of lines for which I need to find the average percent based on shift and date. Column A-L Column A contains the shift date, column F contains the average, and column I contain the score. If shift and date are the same on rows 2 and 3, the VBA code for average on cells I2 and I3 is on F 2. Please help with vba code that will do them all for the entire sheet.
A | E | F | I | |
Date | Shift | Average | Score | |
1/24/23 | 1 | 84% | 65.5% | |
1/24/23 | 1 | 101.4% | ||
1/24/23 | 2 | 51.9% | 51.9% | |
1/23/23 | 1 | 70.8% | 65.4% | |
1/23/23 | 1 | 76.1% |