Navi_G
Board Regular
- Joined
- May 30, 2018
- Messages
- 94
- Office Version
- 2016
- Platform
- Windows
Hi,
Dear Experts i found in typical vlookup situation. i use vlook up function but i can't use with other functions
please advice me on this illustration.
<TBODY>
</TBODY>
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
Question are above mention please advice me. How allaborate them.
Thanks
Navi_G
Dear Experts i found in typical vlookup situation. i use vlook up function but i can't use with other functions
please advice me on this illustration.
ID #</SPAN> | Students</SPAN> | English</SPAN> | Physics</SPAN> | Chemistry</SPAN> | Biology</SPAN> | Computer</SPAN> | Social Studies</SPAN> | Arabic</SPAN> | Gen. Knowledge</SPAN> | Total Obtain.</SPAN> | Total</SPAN> |
381</SPAN> | Ahmed</SPAN> | 75</SPAN> | 82</SPAN> | 62</SPAN> | 44</SPAN> | 98</SPAN> | 92</SPAN> | 33</SPAN> | 99</SPAN> | 585</SPAN> | 800</SPAN> |
382</SPAN> | Rashid</SPAN> | 36</SPAN> | 62</SPAN> | 69</SPAN> | 89</SPAN> | 33</SPAN> | 24</SPAN> | 43</SPAN> | 39</SPAN> | 395</SPAN> | 800</SPAN> |
383</SPAN> | Aster</SPAN> | 89</SPAN> | 55</SPAN> | 78</SPAN> | 45</SPAN> | 64</SPAN> | 88</SPAN> | 21</SPAN> | 82</SPAN> | 522</SPAN> | 800</SPAN> |
384</SPAN> | Yoyo</SPAN> | 32</SPAN> | 33</SPAN> | 33</SPAN> | 31</SPAN> | 22</SPAN> | 12</SPAN> | 79</SPAN> | 36</SPAN> | 278</SPAN> | 800</SPAN> |
385</SPAN> | peter</SPAN> | 79</SPAN> | 97</SPAN> | 83</SPAN> | 77</SPAN> | 86</SPAN> | 99</SPAN> | 99</SPAN> | 81</SPAN> | 701</SPAN> | 800</SPAN> |
386</SPAN> | Pascle</SPAN> | 45</SPAN> | 78</SPAN> | 35</SPAN> | 50</SPAN> | 89</SPAN> | 45</SPAN> | 75</SPAN> | 41</SPAN> | 458</SPAN> | 800</SPAN> |
387</SPAN> | Harry</SPAN> | 55</SPAN> | 79</SPAN> | 45</SPAN> | 90</SPAN> | 36</SPAN> | 41</SPAN> | 85</SPAN> | 77</SPAN> | 508</SPAN> | 800</SPAN> |
388</SPAN> | Smith</SPAN> | 99</SPAN> | 34</SPAN> | 21</SPAN> | 33</SPAN> | 33</SPAN> | 14</SPAN> | 69</SPAN> | 64</SPAN> | 367</SPAN> | 800</SPAN> |
389</SPAN> | Justin</SPAN> | 67</SPAN> | 66</SPAN> | 86</SPAN> | 26</SPAN> | 42</SPAN> | 75</SPAN> | 75</SPAN> | 43</SPAN> | 480</SPAN> | 800</SPAN> |
390</SPAN> | Fernando</SPAN> | 10</SPAN> | 78</SPAN> | 5</SPAN> | 81</SPAN> | 41</SPAN> | 85</SPAN> | 82</SPAN> | 39</SPAN> | 421</SPAN> | 800</SPAN> |
391</SPAN> | Duminy</SPAN> | 22</SPAN> | 90</SPAN> | 18</SPAN> | 33</SPAN> | 65</SPAN> | 13</SPAN> | 83</SPAN> | 90</SPAN> | 414</SPAN> | 800</SPAN> |
392</SPAN> | Frenkin</SPAN> | 88</SPAN> | 37</SPAN> | 68</SPAN> | 43</SPAN> | 75</SPAN> | 80</SPAN> | 92</SPAN> | 45</SPAN> | 528</SPAN> | 800</SPAN> |
393</SPAN> | Sameer</SPAN> | 69</SPAN> | 50</SPAN> | 90</SPAN> | 95</SPAN> | 95</SPAN> | 99</SPAN> | 95</SPAN> | 86</SPAN> | 679</SPAN> | 800</SPAN> |
Table# 01 |
<TBODY>
</TBODY>
Find ????</SPAN> | Maximum Marks in each Subject of 3 Student</SPAN> |
Find ????</SPAN> | Minmum Marks in each Subject of 3 Student</SPAN> |
Find ????</SPAN> | Top 3 Students</SPAN> |
Find ????</SPAN> | Down 3 Students</SPAN> |
Find ????</SPAN> | Less then 33 Marks Students</SPAN> |
Find ????</SPAN> | More then 80 Marks Students</SPAN> |
Find ????</SPAN> | And a chart to Explain these values</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
Question are above mention please advice me. How allaborate them.
Thanks
Navi_G