Hi Xor I prepared answers to your first questions (pls see attached) before I saw your latest post about named ranges- based on the more up to date information in Sample 5 would the named range also work for the whole year?

Attached Files

Sample Data 5.xlsx (67.9 KB, 13 views)