Find range (Max value minus Min value) for each unique building

[CyFishh]

I’m trying to figure out how to create a field that calculates the range (max minus min) of average element scores within each building. Each building has multiple users where the data would need to come from. Each user has a unique ID and an average element score tied to them.

The picture below shows the desired outcome. I was able to do create this table by using static values. Now that I’ve uploaded a new data pull from a separate date I would like to use a metric. All data is coming from a Google sheet.