Let say you have a number column and a date column.
The rows are in order starting from oldest to newest.
There may be rows that have the same date, but they will be in order.
Im wondering if its possible to iterate throughout each row, and sum total all previous dates with the currant row date. This would be done for each for, row. If there is more than 1 date of the row it is working on, only use the latest entry (Last row with that date).
I want to display this is a chart, but also dont want duplicate values for the dates that contain more than 1 entry.
Any input would be appreciated.