Thank you! This worked for all but two dealerships. (Autonation Ford & Van Chevrolet). These two came back with a #VALUE! error, stating that the data was the wrong data type. Very odd to me. These two dealerships are side by side of each other (Basically in the same parking lot). Can you see why it might have this error? If there isn't a fix, I'm okay with it. I have hundreds of dealerships to add to this list. (I run a logistics company that delivers Auto Parts). Again! Thank you so much for your time and help to solve my problem. Based on your formula, I would have NEVER, EVER figured it out! Cheers from Phoenix, AZ (It is 45.5 celsius today!)