Excel Formulas with Advanced challenge Exercise

profileShavone05
south_bend_assistance_league.xlsx

Sheet1

Assistance League of South Bend
Year
Number of Year of Membership 2010
Member Zip Code Employees Expiration Code
Candy's Candy Shop 46656 3 2014 3
Chip Technology 46651 175 2015 3
Computer Attic 46663 4 2012 2
Deluxe Auto Shop 46645 7 2011 1
Dental Associates 46687 15 2012 5
Dr. Mary Terese 46663 5 2015 2
Dunkin' Donuts 46678 7 2012 4
Earl's Restauraant 46635 45 2013 3
First Federal Bank 46667 36 2015 3
Frieendly Chevy 46686 17 2017 3
From Office 46611 25 2016 5
General Hospital 46625 480 2014 4
Grande Table 46646 25 2013 4
Holiday Inn 46621 75 2012 4
Ken's Florist Shop 46641 10 2011 2
Lisa's Photo Studio 46602 5 2014 4
Meineke Muffler 46656 24 2013 1
Midas Muffler 46621 22 2017 3
Mill Shope 46605 165 2014 2
Mobile One 46671 11 2018 3
Red Roof Inn 46610 70 2016 2
Reservation Innn 46657 42 2016 2
State University 46612 422 2015 3

Sheet2

Sheet3