I have the Owner Statement for rental properties that I need to summarize. I am trying to get the name of the current tenant that will be at the bottom of the list.
Right now cell B1 is a drop-down of all properties. When a property is selected, that property's transactions are filtered.
I need the last cell in column D that matches B1 in column B and with "Rent Income" in column C.
Data header row is on row 12 and goes to row 322 but I will be adding data each month.
Right now cell B1 is a drop-down of all properties. When a property is selected, that property's transactions are filtered.
I need the last cell in column D that matches B1 in column B and with "Rent Income" in column C.
Data header row is on row 12 and goes to row 322 but I will be adding data each month.