How to count the most recent value based on multiple criteria?
- by Andrew
I keep a log of phone calls like the following where the F column is LVM = Left Voice Mail, U = Unsuccessful, S = Successful.
A1 1 B1 Smith C1 John D1 11/21/2012 E1 8:00 AM F1 LVM
A2 2 B2 Smith C2 John D2 11/22/2012 E1 8:15 AM F2 U
A3 3 B3 Harvey C3 Luke D3 11/22/2012 E1 8:30 AM F3 S
A4 4 B4 Smith C4 John D4 11/22/2012 …