I've been stumped on how to do this so I thought I would try here.
This is for an RPG game I play.
This is what I'm trying to do...
I have columns that are text that I filter and I want the filtered text to appear on another worksheet.
The header is 2 rows and the filtered line will be displaying on row 3 (Both on the original worksheet and on the sheet that it will be display on)
I will be filtering it down to just one row which is row 3
Example after being filtered:
<table border="0" cellpadding="0" cellspacing="0" width="884"><colgroup><col style="mso-width-source:userset;mso-width-alt:7716;width:158pt" width="211"> <col style="mso-width-source:userset;mso-width-alt:6473;width:133pt" width="177"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;width:158pt" height="20" width="211">
</td> <td class="xl65" style="width:133pt" width="177">
</td> <td class="xl66" style="width:53pt" width="70">
</td> <td colspan="2" class="xl68" style="width:104pt" width="139">CF</td> <td colspan="2" class="xl66" style="width:87pt" width="116">Handling</td> <td class="xl66" style="width:59pt" width="78">
</td> <td class="xl66" style="width:70pt" width="93">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt" height="20">Chassis</td> <td class="xl64">Sub Category</td> <td class="xl66">Body</td> <td class="xl68">Start</td> <td class="xl68">Max</td> <td class="xl66">On</td> <td class="xl66">Off</td> <td class="xl66">Armor</td> <td class="xl66">AutoNav</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Car</td> <td class="xl65">Sports Car</td> <td class="xl67">3</td> <td class="xl67">3</td> <td class="xl67">18</td> <td class="xl67">4</td> <td class="xl67">8</td> <td class="xl67">0</td> <td class="xl67">0</td> </tr> </tbody></table>
So in this example I would want Car showing up on A3 of Sheet2 and Sports Car on B3.
I have no problems doing this with the columns that contain numbers (By using subtotal) but have not been successful with text.
When I try using =INDEX(Chassis!A:A,(ROW())) it shows the true line 3 instead of the filtered line 3.
This is for an RPG game I play.
This is what I'm trying to do...
I have columns that are text that I filter and I want the filtered text to appear on another worksheet.
The header is 2 rows and the filtered line will be displaying on row 3 (Both on the original worksheet and on the sheet that it will be display on)
I will be filtering it down to just one row which is row 3
Example after being filtered:
<table border="0" cellpadding="0" cellspacing="0" width="884"><colgroup><col style="mso-width-source:userset;mso-width-alt:7716;width:158pt" width="211"> <col style="mso-width-source:userset;mso-width-alt:6473;width:133pt" width="177"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;width:158pt" height="20" width="211">
</td> <td class="xl65" style="width:133pt" width="177">
</td> <td class="xl66" style="width:53pt" width="70">
</td> <td colspan="2" class="xl68" style="width:104pt" width="139">CF</td> <td colspan="2" class="xl66" style="width:87pt" width="116">Handling</td> <td class="xl66" style="width:59pt" width="78">
</td> <td class="xl66" style="width:70pt" width="93">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt" height="20">Chassis</td> <td class="xl64">Sub Category</td> <td class="xl66">Body</td> <td class="xl68">Start</td> <td class="xl68">Max</td> <td class="xl66">On</td> <td class="xl66">Off</td> <td class="xl66">Armor</td> <td class="xl66">AutoNav</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Car</td> <td class="xl65">Sports Car</td> <td class="xl67">3</td> <td class="xl67">3</td> <td class="xl67">18</td> <td class="xl67">4</td> <td class="xl67">8</td> <td class="xl67">0</td> <td class="xl67">0</td> </tr> </tbody></table>
So in this example I would want Car showing up on A3 of Sheet2 and Sports Car on B3.
I have no problems doing this with the columns that contain numbers (By using subtotal) but have not been successful with text.
When I try using =INDEX(Chassis!A:A,(ROW())) it shows the true line 3 instead of the filtered line 3.