View Single Post
 
Old 07-30-2023, 07:23 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by p45cal View Post
I'll have a think on it.
See attached. Same as before regarding refreshing to update the second table. Rudimentary formula in column E.

Note, in your file, in row 7 you had TIm with a capital I; my queries are case sensitive so I changed the I to an i. Instead, I can make the query case insensitive if you wish.
Attached Files
File Type: xlsx msofficeforums51161Overlapping dates request_v2.xlsx (19.8 KB, 11 views)
Reply With Quote