ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   grab detail when = 1 (https://www.excelbanter.com/excel-worksheet-functions/64917-grab-detail-when-%3D-1-a.html)

jenn

grab detail when = 1
 
I have a pivot table to help me look for duplicate service entries. When the
sub-total is 2 or more I double click on the 2 and I get an automatic
spreadsheet of the details. How can I do this for mulitple rows at one
time...
I have ID, Service Date, Service time, provider, minutes as my columns that
I have pivoted. I put ID in the data field to get the count...


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com