Mar 09 2020 04:58 AM
Hi,
As per attached sheet, I want the following result from NI4 to ABJ73:
I want a formula to find percentage change in current date by taking base as previous day value. If there is no value in previous day, then last previous day having value must be taken as base day.
For example: Return for January 9, 1950 would be = (17.08/16.98-1) = 0.59% [because there is no data for Jan 7 and Jan 8)
Need the solution urgently.
Mar 09 2020 06:15 AM
Mar 09 2020 06:40 AM
Mar 09 2020 10:34 AM