I need some assistance with the formula. I need this to auto update once the app is synced
The formula is =ArrayFormula(LOOKUP(2,1/($D$2:$D$500=D2),$I$2:$I$500))
Table = Call Report
Column D = Store
Column I = Current Month Actuals
Thank you and stay blessed
Dessie
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |