How to return previous date based on a criteria with expanding data
I have this data. I want the value in B6 to be the date from C4 follow its criteria from column A. Then the date in B10 to be the date from C6. The data will be expanded daily. Hope anyone can help me.
Thanks.. :)
Posted Jan 25, 2026, 12:26 PM UTC
211