Help on creating a search function or search engine?

W

wackykat80

New Member
Joined
Jul 5, 2011
Messages
16
<table border="0" cellpadding="0" cellspacing="0" height="765" width="3141"><col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:5485;width:113pt" width="150"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col style="mso-width-source:userset;mso-width-alt:15835;width:325pt" width="433"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col style="mso-width-source:userset;mso-width-alt:2450;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:25892;width:531pt" width="708"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:9801;width:201pt" width="268"> <tbody> <tr style="height:15.75pt" height="21"> <td class="xl462" style="height:15.75pt" align="left" height="21"> <table border="0" cellpadding="0" cellspacing="0" width="1118"><col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:768;width:16pt" width="21"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> <col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:9837;width:202pt" width="269"> <tbody><tr style="height:15.0pt" height="20"> <td class="xl464" style="height:15.0pt;width:109pt" height="20" width="145">SKU (A1)
</td> <td class="xl464" style="width:16pt" width="21"> </td> <td class="xl464" style="width:257pt" width="342">DESCRIPTION (B1)
</td> <td class="xl465" style="width:92pt" width="122">TYPE (C1)
</td> <td valign="top">
</td><td valign="top">
</td><td class="xl465" style="width:43pt" width="57">PRICE (D1)
</td> <td class="xl469" style="width:30pt" width="40"> </td> <td class="xl464" style="width:92pt" width="122">SIZE (E1)
</td> <td class="xl464" style="width:202pt" width="269">COLOR/FINISH (F1)
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">2- 6216140</td> <td class="xl458">
</td> <td class="xl460">HOOK MET.16MM (WOOD SCREW) CHROME</td> <td class="xl466">HOOK</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">35.63</td> <td class="xl467">USD</td> <td class="xl462">16MM</td> <td class="xl463">CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">3- 621614090</td> <td class="xl458">
</td> <td class="xl460">PULL MET.16MM (M4) CHROME & BLACK</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">35.63</td> <td class="xl467">USD</td> <td class="xl462">16MM</td> <td class="xl463">CHROME & BLACK</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">4- 167128140</td> <td class="xl458">
</td> <td class="xl460">PULL MET.128MM (M4) CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">28.34</td> <td class="xl467">USD</td> <td class="xl462">128MM</td> <td class="xl463">CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">5- 167288140</td> <td class="xl458">
</td> <td class="xl460">PULL MET.288MM (M4) CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">46.16</td> <td class="xl467">USD</td> <td class="xl462">288MM</td> <td class="xl463">CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">6- 10056416140</td> <td class="xl458">
</td> <td class="xl460">PULL MET.416MM (M4) CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">59.20</td> <td class="xl467">USD</td> <td class="xl462">416MM</td> <td class="xl463">CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">7- 10056160140</td> <td class="xl458">
</td> <td class="xl460">PULL MET.160MM (M4) CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">26.07</td> <td class="xl467">USD</td> <td class="xl462">160MM</td> <td class="xl463">CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">8- 5736014030</td> <td class="xl458">
</td> <td class="xl460">PULL MET.16MM (M4) CHROME & WHITE</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">29.88</td> <td class="xl467">USD</td> <td class="xl462">16MM</td> <td class="xl463">CHROME & WHITE</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">5736014090</td> <td class="xl458">
</td> <td class="xl460">PULL MET.16MM (M4) CHROME & BLACK</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">29.88</td> <td class="xl467">USD</td> <td class="xl462">16MM</td> <td class="xl463">CHROME & BLACK</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">57916014030</td> <td class="xl458">
</td> <td class="xl460">PULL MET.160MM (M4) CHROME & WHITE</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">46.97</td> <td class="xl467">USD</td> <td class="xl462">160MM</td> <td class="xl463">CHROME & WHITE</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">57916014090</td> <td class="xl458">
</td> <td class="xl460">PULL MET.160MM (M4) CHROME & BLACK</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">46.73</td> <td class="xl467">USD</td> <td class="xl462">160MM</td> <td class="xl463">CHROME & BLACK</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21721714030</td> <td class="xl458">
</td> <td class="xl460">KNOB MET.24MM (M4) CHROME & WHITE</td> <td class="xl466">KNOB</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">14.33</td> <td class="xl467">USD</td> <td class="xl462">24MM</td> <td class="xl463">CHROME & WHITE</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21721714090</td> <td class="xl458">
</td> <td class="xl460">KNOB MET.24MM (M4) CHROME & BLACK</td> <td class="xl466">KNOB</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">14.33</td> <td class="xl468">USD</td> <td class="xl462">24MM</td> <td class="xl463">CHROME & BLACK</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">61696764174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.64MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">11.17</td> <td class="xl467">USD</td> <td class="xl462">64MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">61644332174</td> <td class="xl458">
</td> <td class="xl460">KNOB MET.32MM (M4) MAT CHROME</td> <td class="xl466">KNOB</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">8.25</td> <td class="xl467">USD</td> <td class="xl462">32MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">61696732174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.32MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">9.23</td> <td class="xl467">USD</td> <td class="xl462">32MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21696192174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.192MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">25.27</td> <td class="xl467">USD</td> <td class="xl462">192MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21696160174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.160MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">20.22</td> <td class="xl467">USD</td> <td class="xl462">160MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21696128174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.128MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">16.34</td> <td class="xl467">USD</td> <td class="xl462">128MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21702224174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.224MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">29.61</td> <td class="xl467">USD</td> <td class="xl462">224MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21702160174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.160MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">20.85</td> <td class="xl467">USD</td> <td class="xl462">160MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">2170296174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.96MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">15.33</td> <td class="xl467">USD</td> <td class="xl462">96MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">21691128174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.128MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">15.54</td> <td class="xl467">USD</td> <td class="xl462">128MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">2169164174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.64MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">12.93</td> <td class="xl467">USD</td> <td class="xl462">64MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">2169132174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.32MM CC (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">10.76</td> <td class="xl467">USD</td> <td class="xl462">32MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">216423175</td> <td class="xl458">
</td> <td class="xl460">PULL MET.96MM (M4) VELVET CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">18.51</td> <td class="xl467">USD</td> <td class="xl462">96MM</td> <td class="xl463">VELVET CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">30373175</td> <td class="xl459">
</td> <td class="xl460">KNOB MET.32MM (8/32) BRUSHED CHROME</td> <td class="xl466">KNOB</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">4.37</td> <td class="xl467">USD</td> <td class="xl462">32MM</td> <td class="xl463">BRUSHED CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">79222174</td> <td class="xl458">
</td> <td class="xl460">KNOB MET.22MM (M4) MAT CHROME</td> <td class="xl466">KNOB</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">14.66</td> <td class="xl467">USD</td> <td class="xl462">22MM</td> <td class="xl463">MAT CHROME</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl458" style="height:15.75pt" height="21">79216174</td> <td class="xl458">
</td> <td class="xl460">PULL MET.16MM (M4) MAT CHROME</td> <td class="xl466">PULL</td> <td valign="top">
</td><td valign="top">
</td><td class="xl461" align="right">18.97</td> <td class="xl467">USD</td> <td class="xl462">16MM</td> <td class="xl463">MAT CHROME</td> </tr> </tbody></table></td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td class="xl465">
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">Ok I cleaned up some stuff and this is the basic information I need to work with. From this info I needed to create a search engine, like if a customer just wants a list of pulls in satin nickel with the price/without the price. It seems that V-Look up isn't working. I've tried numberous things and no luck. It needs to be user friendly like what we use every day...ex: I want dodge durango 99...in google/bing...that specific criteria is generated into a list. Is there anyway to do this in excel.? Please help???
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl460">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl461" style="height:15.75pt" align="left" height="21">
</td> <td class="xl468" align="left">
</td> <td class="xl461" align="left">
</td> <td class="xl472" align="left">
</td> <td class="xl467" align="left">
</td> <td class="xl463" align="left">
</td> <td class="xl463">
</td> <td class="xl458">
</td> <td class="xl464" align="right">
</td> <td class="xl458">
</td> <td>
</td> <td class="xl466">
</td> <td class="xl469">
</td> </tr> </tbody></table>
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
nope...last time i used this thing I was in high school and I have forgotten all of this function stuff...? do tell?
 
Upvote 0
Click on the link in the previous post #2. It's a step-by-step guide.

Or web search Excel Autofilter tutorial for a variety of useful guides and videos.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
537
smozgur
smozgur
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
902
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
M
  • Question Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M
B
  • Question Question
Webscrapping Loop to get table data
Replies
1
Views
667
John_w
J

Forum statistics

Threads
1,223,276
Messages
6,171,140
Members
452,381
Latest member
Nova88

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top