Hi there!
I've tried to find a way to do this simply, but I'm stumped. I have a rotating roster of people who will be assigned to different tasks. They can't do multiple tasks on the same day. I want to make sure I'm not duplicating names across each row.Conditional formatting works across a...
Oh my goodness, thank you soooo much! Works perfectly now - I was afraid I'd be missing something super-easy. I have been following Chandoo's posts for quite a while now - I'll have to make use of the forums more often. :)
I'm re-vamping a spreadsheet our company is using to perform audits at each of our ten locations. Each location will be audited in different areas depending on their contract requirements, etc. I have a list of audit questions assigned to different audit areas, and I'm trying to do a lookup...