0

I'm working with a large building footprint data-set that was joined to Parcel data based on geographic location. This Building Footprint data-set has multiple footprints within the same parcel and therefore has identical Parcel_ID's.

I am looking to find a formula that selects rows based on an identical Parcel_ID and then outputs the preferred footprint (rows) based on how close it's "Calculated_Square_Footage" values are to the Listed_Square_Footage value.

So take for example: I have a table with 6 building footprints (6 rows of data). All 6 footprints have the same ID (Parcel_ID) and Listed_Square_Footage value because they all lie within the same parcel. But, all 6 footprints have different Calculated square footage calculations because they are different sizes. I want a formula that highlights, selects, or outputs the row where it's Calculated_Square_Footage value is closest to the Listed_Square_Footage value: (See table below)

Preferred_Footprint_Table_Example

1 Answer 1

0

If you create a helper column with the following formula (I put mine in column F):

=ABS(D2-C2)

You can then use the following formula to return the footprint:

=INDEX(A2:A7,MATCH(MIN(F2:F7),F2:F7,0))
1
  • Sorry for the late reply. I appreciate your help and this worked but I did find a slight issue when applying this formula to the entire data-set. The formula selects from a range of cells instead of selecting from just footprints (rows) with identical parcel ID's. So when the formula calculated for building footprint "4" it results in building footprint 5 being preferred when it should still be building footprint 3. And in some cases there are just 2 or 3 footprints w/in a parcel and not 6 so the range of calculating for 6 cells won't be accurate. Anyway to mitigate this? Nov 2, 2018 at 13:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .