I agree with djapigo. Some things that might cause issues, hidden spaces. you might have " UA" or "meeting room " numbers might be stored as text. Best bet is to submit a sample of your workbook so we can troubleshoot.
I have attached a test document, I hope you can help me
Bookmarks