Hello my newly acquired friends,
I have a list of household visits conducted by our workers. I'm using Excel 2010. Database is huge, has about 9000 rows and 150 columns. At the end I created several summary columns that give me a better and easier overview. I used codes, conditional formating with traffic light colors etc. Now one of the things I need to check is whether at least one visit for each address was conducted in the afternoon and weekend. My list of visits looks like this:
Visits.jpg
I was trying hard to create a neat formula on the same sheet, but I couldn't figure out anything. Now I created a separate sheet where I first check individually for each visit (1 to 20) whether it was in the afternoon and at the end do the final check. And than again a similar thing for the weekends. It works, but it's ugly and awkward, plus significantly increases my file size. Currently it works like this:
Afternoon weekend.jpg
At the end I link my findings back to the original sheet and than color-code them.
Check.jpg
I as I said, it does work somehow, but I'm not satisfied with my solution. Excel is all-mighty, I'm quite positive that there must a be a shorter, easier and more elegant solution.
Any help will be greatly appreciated.
Have a nice day,
Masha
Bookmarks