David0227
New Member
- Joined
- Mar 1, 2020
- Messages
- 14
- Office Version
- 2011
- 2010
- 2007
- Platform
- Windows
- MacOS
I am looking to calculate row C and Row D
In C I want to return the max date per service from column B but it to show for each row of that service
in D I want to return a value of 1 in the row where the MAX date per servive exists
Appreciate any help, thanks
In C I want to return the max date per service from column B but it to show for each row of that service
in D I want to return a value of 1 in the row where the MAX date per servive exists
Appreciate any help, thanks
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Service | Date | Max Date Service | Row with Max Date Service | ||
2 | 1 | 1/24/99 | 1/25/99 | |||
3 | 1 | 1/25/99 | 1/25/99 | 1 | ||
4 | 2 | 2/24/98 | 2/24/98 | 1 | ||
5 | 3 | 2/25/98 | 2/25/98 | 1 | ||
6 | 4 | 2/25/98 | 2/25/98 | 1 | ||
7 | 5 | 2/27/98 | 2/28/98 | |||
8 | 5 | 2/28/98 | 2/28/98 | 1 | ||
9 | 6 | 3/1/98 | 3/1/98 | 1 | ||
Sheet1 |