<div>
In the &quot;Data&quot; Ribbon, there is section &quot;Outline&quot;, it has a &quot;Subtotal&quot; button, select the table, and then click on &quot;Subtotal&quot;, menu that pops ups will help you build in the &quot;drill&quot; capability to the table.
</div>


In the "Data" Ribbon, there is section "Outline", it has a "Subtotal" button, select the table, and then click on "Subtotal", menu that pops ups will help you build in the "drill" capability to the table.

<div>
Excel powerview has this functionality, available in v2013
</div>


Excel powerview has this functionality, available in v2013

How-to-create-a-table-with-Power-Vie.pdf

<div>
Hi Dhara,<br />
<br />
I tinkered around with PowerView a little but will give this another shot and let you know.<br />
<br />
Seems like a lot to go through though. I have a countifs formula that says I have 4 rows that match the countif criteria, Would just like to double click to see those 4 rows without having to create a powerview. <br />
<br />
Thanks,<br />
<br />
swjtx99
</div>


Hi Dhara,

I tinkered around with PowerView a little but will give this another shot and let you know.

Seems like a lot to go through though. I have a countifs formula that says I have 4 rows that match the countif criteria, Would just like to double click to see those 4 rows without having to create a powerview.

Thanks,

swjtx99

<div>
Hi Dhara,<br />
<br />
Your suggestion does technically work so have to give you credit for the solution, however, I find I cannot use a powerview table because my process creates the sheet and therefore I would also have to create the powerview using VBA so is probably not feasible. <br />
<br />
Thanks for your help!<br />
<br />
swjtx99
</div>


Hi Dhara,

Your suggestion does technically work so have to give you credit for the solution, however, I find I cannot use a powerview table because my process creates the sheet and therefore I would also have to create the powerview using VBA so is probably not feasible.

Thanks for your help!

swjtx99

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a table with formulas that count data on another sheet. If I use a Pivot table, I can double click on the cell with the results and it will create a sheet showing me the rows that were counted. I need to do that without a pivot table. <br />
<br />
Thanks in advance,<br />
<br />
swjtx99
</div>
</div>


Hi,

I have a table with formulas that count data on another sheet. If I use a Pivot table, I can double click on the cell with the results and it will create a sheet showing me the rows that were counted. I need to do that without a pivot table. 

Thanks in advance,

swjtx99

Drill down without Pivot Table

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.