Hello. I have a large data set that looks like the spreadsheet shown below. I am interested in a formula that puts the correct value in the "Continuous Months on a Team" column using the person's name, team, and start/end months. The biggest challeng I am having is getting the correct output for is people similiar to Linda. Thank you in advance for the help!
Person Team Month Start Month End Total Months Continuous Months on a Team
Bob A 1 3 2 2
Bob C 1 3 2
Joe B 2 4 2 2
Linda A 1 2 1 4
Linda B 2 3 1
Linda C 3 5 2
Linda D 10 12 2 2
Linda E 10 11 1
Linda F 13 15 2 2
Linda G 13 15 2
Bookmarks