I have been sitting for hours trying to figure out the formula for one of the entries on my homework!! I NEED HELP BAD!!! What is the index-match formula to get the name of the consultant who knows all of the languages? Thanks in advance!!
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="4"><col><col></colgroup><tbody>
</tbody>
Business Analyst Table | Summary: | |||||||||||||||
Name | Gender | Age | Yrs | Java | Python | C# | R | PHP | Java- Script | Ruby | Count | Total count of women | 6 | |||
Bhua, Li | M | 21 | 2 | Y | N | Y | Y | N | N | N | 3 | Total count of men | 12 | |||
Kadafi, Kim | M | 22 | 4 | Y | Y | Y | N | Y | N | N | 4 | Average age of women | 29.83333 | |||
Kidd, Laura | F | 23 | 1 | Y | Y | N | N | Y | Y | Y | 5 | Average age of men | 31.33333 | |||
Sea, Tyler | M | 24 | 3 | Y | N | N | N | Y | Y | N | 3 | Median age of all consultants | 30.58333 | |||
Jang, Lin | F | 25 | 5 | Y | Y | Y | Y | Y | Y | Y | 7 | Average years of experience | 7.5 | |||
White, Danzel | M | 25 | 3 | Y | Y | Y | N | Y | Y | N | 5 | Total years of Java experience (all consultants) | 60 | |||
Chavez, Juanita | F | 26 | 4 | N | Y | N | Y | Y | N | N | 3 | Consultant who knows all languages | #N/A | |||
Naik, Chandana | F | 28 | 9 | Y | N | N | Y | N | N | Y | 3 | |||||
Biagi, John | M | 29 | 11 | N | Y | N | Y | Y | N | Y | 4 | |||||
Goldsmith, Ed | M | 31 | 8 | N | Y | Y | N | N | N | Y | 3 | |||||
Hatt, Jerimiah | M | 32 | 5 | Y | N | N | Y | Y | N | Y | 4 | |||||
Santos, Carlos | M | 32 | 7 | N | N | Y | N | N | N | Y | 2 | |||||
Sosa, Flower | F | 32 | 10 | N | Y | Y | Y | N | Y | Y | 5 | |||||
Dan, Jake | M | 34 | 19 | N | Y | N | N | Y | Y | N | 3 | |||||
Harley, Jim | M | 38 | 9 | N | N | N | N | Y | Y | Y | 3 | |||||
Diaz, Jorge | M | 38 | 15 | Y | Y | Y | Y | Y | Y | N | 6 | |||||
Smith, Kylie | F | 45 | 7 | N | Y | Y | Y | Y | N | N | 4 | |||||
Brown, Fred | M | 50 | 13 | Y | N | N | Y | Y | Y | Y | 5 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="4"><col><col></colgroup><tbody>
</tbody>