I am looking to calculate the last sales price for a particular unit and also return the last sales date for a unit.
excel.jpg
i would like to have the most recent Agreement Sales Price to be returned in a cell based on Unit type matching. Additionally, i would like to get the date of the last sale based on the unit type returned in a separate cell. would love some help with this.
Bookmarks