Use the data in Sheets 7a and 7b to answer the following questions:
a. Sheet 7a worksheet contains two lists of names. Use an array formula to count the number of names appearing on both lists.
b. Sheet 7b worksheet contains some calculations. Use an array formula to count the number of cells containing errors. Hint: Use the ISERROR function in your array formula.
Use The Data In Sheets 7a And 7b To Answer The Following Questions A Sheet 7a Worksheet Contains Two Lists Of Names U 1 (34.3 KiB) Viewed 15 times
Use The Data In Sheets 7a And 7b To Answer The Following Questions A Sheet 7a Worksheet Contains Two Lists Of Names U 2 (34.7 KiB) Viewed 15 times
t 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 20 27 28 29 30 31 32 33 34 35 36 37 38 29 40 41 42 43 44 45 46 47 48 49 50 x 0 :6 Jon J Bob Ann Annie Erica Adam Tad Brooke Archie Peyton Ron Erica Dirk Brooke Tracy Tad Derek Sheet 7a - 3 I - Sheet 7b 2 +
1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 B 6 с D Game At Bats 10 11 12 13 Sheet 7a 2 25555NNSSAO E Hits 02220 1 1 2 0 2 1 0 F ............. Sheet 7b G +
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!