Displaying most recent value in a horizontal array?

/ 2024-07-04 / Microsoft

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

Tags: microsoft