Displaying most recent value in a horizontal array?
Hi,
I have an array full of prices and 1 date column. I need to display the most recent value of each row’s array that are all equal to today’s date. I plan to sum all the numbers eventually.
Ex:
TODAY’S DATE: July 4th 2024
04-Jul$14.00$45.00
78.00
18-May$63.00$86.00
$92.00
04-Jul$134.00$34.00$50.00 04-Jul$25.00
Output:
78
50
25
(Summed up this would be 153)
Thanks in advance!
Hi,I have an array full of prices and 1 date column. I need to display the most recent value of each row’s array that are all equal to today’s date. I plan to sum all the numbers eventually.Ex:TODAY’S DATE: July 4th 202404-Jul$14.00$45.00 78.0018-May$63.00$86.00$92.00 04-Jul$134.00$34.00$50.00 04-Jul$25.00 Output:785025(Summed up this would be 153)Thanks in advance! Read More
