When using an add in function in Excel to compute values for hundreds of thousands of rows of data, Excel will start freezing or showing "0" values.

The add in function allows me to calculate the mileage of an origin and destination pair for each row.

I've tried filtering by year, but am having issues with that even.

Are there any solutions to this?

`show formulas`

so we can see how it is setup.1more comment