MrMeerkat
New Member
- Joined
- Sep 8, 2023
- Messages
- 3
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
Hello everyone, this request sounds easy but i can’t seem to wrap my head around doing it. Thanks for you help in advance.
Help needed:
Left Table - Input
Right Table - Desired Output
In the desired output:
Streak - based on the consecutive blanks starting from first blank in the respective product column to last blank based on latest date input in the Date column
Last Price - Last filled value
2nd Last price - Second last filled value
3rd Last Price - Third last filled value
Help needed:
Left Table - Input
Right Table - Desired Output
In the desired output:
Streak - based on the consecutive blanks starting from first blank in the respective product column to last blank based on latest date input in the Date column
Last Price - Last filled value
2nd Last price - Second last filled value
3rd Last Price - Third last filled value