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.
[TABLE="width: 965"]
<TBODY>[TR]
[TD]ID #</SPAN>
[/TD]
[TD]Students</SPAN>
[/TD]
[TD]English</SPAN>
[/TD]
[TD]Physics</SPAN>
[/TD]
[TD]Chemistry</SPAN>
[/TD]
[TD]Biology</SPAN>
[/TD]
[TD]Computer</SPAN>
[/TD]
[TD]Social Studies</SPAN>
[/TD]
[TD]Arabic</SPAN>
[/TD]
[TD]Gen. Knowledge</SPAN>
[/TD]
[TD]Total Obtain.</SPAN>
[/TD]
[TD]Total</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]381</SPAN>
[/TD]
[TD]Ahmed</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]82</SPAN>
[/TD]
[TD="align: right"]62</SPAN>
[/TD]
[TD="align: right"]44</SPAN>
[/TD]
[TD="align: right"]98</SPAN>
[/TD]
[TD="align: right"]92</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]585</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]382</SPAN>
[/TD]
[TD]Rashid</SPAN>
[/TD]
[TD="align: right"]36</SPAN>
[/TD]
[TD="align: right"]62</SPAN>
[/TD]
[TD="align: right"]69</SPAN>
[/TD]
[TD="align: right"]89</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]24</SPAN>
[/TD]
[TD="align: right"]43</SPAN>
[/TD]
[TD="align: right"]39</SPAN>
[/TD]
[TD="align: right"]395</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]383</SPAN>
[/TD]
[TD]Aster</SPAN>
[/TD]
[TD="align: right"]89</SPAN>
[/TD]
[TD="align: right"]55</SPAN>
[/TD]
[TD="align: right"]78</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]64</SPAN>
[/TD]
[TD="align: right"]88</SPAN>
[/TD]
[TD="align: right"]21</SPAN>
[/TD]
[TD="align: right"]82</SPAN>
[/TD]
[TD="align: right"]522</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]384</SPAN>
[/TD]
[TD]Yoyo</SPAN>
[/TD]
[TD="align: right"]32</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]31</SPAN>
[/TD]
[TD="align: right"]22</SPAN>
[/TD]
[TD="align: right"]12</SPAN>
[/TD]
[TD="align: right"]79</SPAN>
[/TD]
[TD="align: right"]36</SPAN>
[/TD]
[TD="align: right"]278</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]385</SPAN>
[/TD]
[TD]peter</SPAN>
[/TD]
[TD="align: right"]79</SPAN>
[/TD]
[TD="align: right"]97</SPAN>
[/TD]
[TD="align: right"]83</SPAN>
[/TD]
[TD="align: right"]77</SPAN>
[/TD]
[TD="align: right"]86</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]81</SPAN>
[/TD]
[TD="align: right"]701</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]386</SPAN>
[/TD]
[TD]Pascle</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]78</SPAN>
[/TD]
[TD="align: right"]35</SPAN>
[/TD]
[TD="align: right"]50</SPAN>
[/TD]
[TD="align: right"]89</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD="align: right"]458</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]387</SPAN>
[/TD]
[TD]Harry</SPAN>
[/TD]
[TD="align: right"]55</SPAN>
[/TD]
[TD="align: right"]79</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]36</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD="align: right"]85</SPAN>
[/TD]
[TD="align: right"]77</SPAN>
[/TD]
[TD="align: right"]508</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]388</SPAN>
[/TD]
[TD]Smith</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]34</SPAN>
[/TD]
[TD="align: right"]21</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]14</SPAN>
[/TD]
[TD="align: right"]69</SPAN>
[/TD]
[TD="align: right"]64</SPAN>
[/TD]
[TD="align: right"]367</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]389</SPAN>
[/TD]
[TD]Justin</SPAN>
[/TD]
[TD="align: right"]67</SPAN>
[/TD]
[TD="align: right"]66</SPAN>
[/TD]
[TD="align: right"]86</SPAN>
[/TD]
[TD="align: right"]26</SPAN>
[/TD]
[TD="align: right"]42</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]43</SPAN>
[/TD]
[TD="align: right"]480</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]390</SPAN>
[/TD]
[TD]Fernando</SPAN>
[/TD]
[TD="align: right"]10</SPAN>
[/TD]
[TD="align: right"]78</SPAN>
[/TD]
[TD="align: right"]5</SPAN>
[/TD]
[TD="align: right"]81</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD="align: right"]85</SPAN>
[/TD]
[TD="align: right"]82</SPAN>
[/TD]
[TD="align: right"]39</SPAN>
[/TD]
[TD="align: right"]421</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]391</SPAN>
[/TD]
[TD]Duminy</SPAN>
[/TD]
[TD="align: right"]22</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]18</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]65</SPAN>
[/TD]
[TD="align: right"]13</SPAN>
[/TD]
[TD="align: right"]83</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]414</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]392</SPAN>
[/TD]
[TD]Frenkin</SPAN>
[/TD]
[TD="align: right"]88</SPAN>
[/TD]
[TD="align: right"]37</SPAN>
[/TD]
[TD="align: right"]68</SPAN>
[/TD]
[TD="align: right"]43</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]80</SPAN>
[/TD]
[TD="align: right"]92</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]528</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]393</SPAN>
[/TD]
[TD]Sameer</SPAN>
[/TD]
[TD="align: right"]69</SPAN>
[/TD]
[TD="align: right"]50</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]95</SPAN>
[/TD]
[TD="align: right"]95</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]95</SPAN>
[/TD]
[TD="align: right"]86</SPAN>
[/TD]
[TD="align: right"]679</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Table# 01
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
[TABLE="width: 367"]
<TBODY>[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Maximum Marks in each Subject of 3 Student</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Minmum Marks in each Subject of 3 Student</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Top 3 Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Down 3 Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Less then 33 Marks Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]More then 80 Marks Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]And a chart to Explain these values</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
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.
[TABLE="width: 965"]
<TBODY>[TR]
[TD]ID #</SPAN>
[/TD]
[TD]Students</SPAN>
[/TD]
[TD]English</SPAN>
[/TD]
[TD]Physics</SPAN>
[/TD]
[TD]Chemistry</SPAN>
[/TD]
[TD]Biology</SPAN>
[/TD]
[TD]Computer</SPAN>
[/TD]
[TD]Social Studies</SPAN>
[/TD]
[TD]Arabic</SPAN>
[/TD]
[TD]Gen. Knowledge</SPAN>
[/TD]
[TD]Total Obtain.</SPAN>
[/TD]
[TD]Total</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]381</SPAN>
[/TD]
[TD]Ahmed</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]82</SPAN>
[/TD]
[TD="align: right"]62</SPAN>
[/TD]
[TD="align: right"]44</SPAN>
[/TD]
[TD="align: right"]98</SPAN>
[/TD]
[TD="align: right"]92</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]585</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]382</SPAN>
[/TD]
[TD]Rashid</SPAN>
[/TD]
[TD="align: right"]36</SPAN>
[/TD]
[TD="align: right"]62</SPAN>
[/TD]
[TD="align: right"]69</SPAN>
[/TD]
[TD="align: right"]89</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]24</SPAN>
[/TD]
[TD="align: right"]43</SPAN>
[/TD]
[TD="align: right"]39</SPAN>
[/TD]
[TD="align: right"]395</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]383</SPAN>
[/TD]
[TD]Aster</SPAN>
[/TD]
[TD="align: right"]89</SPAN>
[/TD]
[TD="align: right"]55</SPAN>
[/TD]
[TD="align: right"]78</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]64</SPAN>
[/TD]
[TD="align: right"]88</SPAN>
[/TD]
[TD="align: right"]21</SPAN>
[/TD]
[TD="align: right"]82</SPAN>
[/TD]
[TD="align: right"]522</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]384</SPAN>
[/TD]
[TD]Yoyo</SPAN>
[/TD]
[TD="align: right"]32</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]31</SPAN>
[/TD]
[TD="align: right"]22</SPAN>
[/TD]
[TD="align: right"]12</SPAN>
[/TD]
[TD="align: right"]79</SPAN>
[/TD]
[TD="align: right"]36</SPAN>
[/TD]
[TD="align: right"]278</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]385</SPAN>
[/TD]
[TD]peter</SPAN>
[/TD]
[TD="align: right"]79</SPAN>
[/TD]
[TD="align: right"]97</SPAN>
[/TD]
[TD="align: right"]83</SPAN>
[/TD]
[TD="align: right"]77</SPAN>
[/TD]
[TD="align: right"]86</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]81</SPAN>
[/TD]
[TD="align: right"]701</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]386</SPAN>
[/TD]
[TD]Pascle</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]78</SPAN>
[/TD]
[TD="align: right"]35</SPAN>
[/TD]
[TD="align: right"]50</SPAN>
[/TD]
[TD="align: right"]89</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD="align: right"]458</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]387</SPAN>
[/TD]
[TD]Harry</SPAN>
[/TD]
[TD="align: right"]55</SPAN>
[/TD]
[TD="align: right"]79</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]36</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD="align: right"]85</SPAN>
[/TD]
[TD="align: right"]77</SPAN>
[/TD]
[TD="align: right"]508</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]388</SPAN>
[/TD]
[TD]Smith</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]34</SPAN>
[/TD]
[TD="align: right"]21</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]14</SPAN>
[/TD]
[TD="align: right"]69</SPAN>
[/TD]
[TD="align: right"]64</SPAN>
[/TD]
[TD="align: right"]367</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]389</SPAN>
[/TD]
[TD]Justin</SPAN>
[/TD]
[TD="align: right"]67</SPAN>
[/TD]
[TD="align: right"]66</SPAN>
[/TD]
[TD="align: right"]86</SPAN>
[/TD]
[TD="align: right"]26</SPAN>
[/TD]
[TD="align: right"]42</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]43</SPAN>
[/TD]
[TD="align: right"]480</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]390</SPAN>
[/TD]
[TD]Fernando</SPAN>
[/TD]
[TD="align: right"]10</SPAN>
[/TD]
[TD="align: right"]78</SPAN>
[/TD]
[TD="align: right"]5</SPAN>
[/TD]
[TD="align: right"]81</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD="align: right"]85</SPAN>
[/TD]
[TD="align: right"]82</SPAN>
[/TD]
[TD="align: right"]39</SPAN>
[/TD]
[TD="align: right"]421</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]391</SPAN>
[/TD]
[TD]Duminy</SPAN>
[/TD]
[TD="align: right"]22</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]18</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD="align: right"]65</SPAN>
[/TD]
[TD="align: right"]13</SPAN>
[/TD]
[TD="align: right"]83</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]414</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]392</SPAN>
[/TD]
[TD]Frenkin</SPAN>
[/TD]
[TD="align: right"]88</SPAN>
[/TD]
[TD="align: right"]37</SPAN>
[/TD]
[TD="align: right"]68</SPAN>
[/TD]
[TD="align: right"]43</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]80</SPAN>
[/TD]
[TD="align: right"]92</SPAN>
[/TD]
[TD="align: right"]45</SPAN>
[/TD]
[TD="align: right"]528</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]393</SPAN>
[/TD]
[TD]Sameer</SPAN>
[/TD]
[TD="align: right"]69</SPAN>
[/TD]
[TD="align: right"]50</SPAN>
[/TD]
[TD="align: right"]90</SPAN>
[/TD]
[TD="align: right"]95</SPAN>
[/TD]
[TD="align: right"]95</SPAN>
[/TD]
[TD="align: right"]99</SPAN>
[/TD]
[TD="align: right"]95</SPAN>
[/TD]
[TD="align: right"]86</SPAN>
[/TD]
[TD="align: right"]679</SPAN>
[/TD]
[TD="align: right"]800</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Table# 01
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
[TABLE="width: 367"]
<TBODY>[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Maximum Marks in each Subject of 3 Student</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Minmum Marks in each Subject of 3 Student</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Top 3 Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Down 3 Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]Less then 33 Marks Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]More then 80 Marks Students</SPAN>[/TD]
[/TR]
[TR]
[TD]Find ????</SPAN>[/TD]
[TD="colspan: 4"]And a chart to Explain these values</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
Question are above mention please advice me. How allaborate them.
Thanks
Navi_G