chuchuberthelot
New Member
- Joined
- Mar 2, 2020
- Messages
- 2
- Platform
- MacOS
Hi I'm trying to get the last value when the following conditions are met.
I've tried this formula, but it doesn't seem to work...
=IF(AND(E2=$A$2:$A$13,B2:B13<F2),$C$2:$C$13)
Can anyone help me?
- Customer ID = Customer ID
- Date 1 < Date 2
I've tried this formula, but it doesn't seem to work...
=IF(AND(E2=$A$2:$A$13,B2:B13<F2),$C$2:$C$13)
Can anyone help me?