So....the test results are in. You were correct...cleaning things up and putting finite cells rather than selecting the entire column, I ran it on 4 pieces of equipment for testing. It went from 5 minutes 16 seconds to calculate. After the cleanup, it took just under 5 seconds to calculate!


Thanks so much Ali! Looks like I have a bad habit I need to get rid of. Never noticed it in old Excel I guess when we had 65K rows max...but when the formulae get more statements and you add 1 Million+ rows it makes a huge difference!