Hi, I want to find the most recent leases (1,2,3,etc) based on the floor plan ID of a list of units at an apartment community. I tried using the OFFSET and MATCH functions like this but only works if the data is sorted by Floor Plan (which I don't want to do - the data is already sorted by most recent leases first and would like to keep that): =SUM(OFFSET($AD$156,MATCH($D11,$V$156:$V$2655,0)-1,0,$AA$9))/COUNT(OFFSET($AD$156,MATCH($D11,$V$156:$V$2655,0)-1,0,$AA$9))
See attached file.
Thanks!
See attached file.
Thanks!