torourke17
New Member
- Joined
- Jan 12, 2018
- Messages
- 12
- Office Version
- 365
- 2019
- Platform
- Windows
I have a table, Column A represents a billing period (11/30/18, 12/31/18, 1/31/19 etc.) and column B represents an amount received for the applicable billing period ($100, 115, 105, etc.).
In a separate cell I want to return a date of the last invoice payment received. So, if the table above shows a value for
(A1)November 30, 2018 (B1)$100
(A2)December 31, 2018 (B2) $115
(A3) January 31, 2019 (B3) $105
(A4) February 28, 2019 (B4) $0
(A5) March 31, 2019 (B5) $0
I'd want the cell B10 to search the table above and tell me that January 31, 2019 was the last billing period I received a payment for. Obviously it has something to do with searching the list and finding a value greater than $0 and pulling that date, but I can't think this through right.
In a separate cell I want to return a date of the last invoice payment received. So, if the table above shows a value for
(A1)November 30, 2018 (B1)$100
(A2)December 31, 2018 (B2) $115
(A3) January 31, 2019 (B3) $105
(A4) February 28, 2019 (B4) $0
(A5) March 31, 2019 (B5) $0
I'd want the cell B10 to search the table above and tell me that January 31, 2019 was the last billing period I received a payment for. Obviously it has something to do with searching the list and finding a value greater than $0 and pulling that date, but I can't think this through right.