Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was looking for a way to have a field/button that could help me
display either : All date, 07/18 or 08/18 Here's one way, starting with the input data and result data arranged as before. Step 1: Set up filtering by selecting A1:A5 and using Home Editing Sort & Filter Filter (I use Excel 2010; other versions might vary.) This enables either viewing all rows or selecting rows by date. Step 2: In G2, enter =SUBTOTAL(103, A2) and copy down to G5. This returns 1 for visible rows; 0 for hidden rows. Step 3: In B9, I put =COUNTIFS(B$2:B$5, $A9, $G$2:$G$5, 1) and copy it into B9:F10. This limits the counting to visible rows only. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Values in Pivot Table | Excel Discussion (Misc queries) | |||
Automatic Sorting of Top Ten values in a table | Excel Discussion (Misc queries) | |||
Pivot Table Import Link to Numerical Values | Excel Worksheet Functions | |||
Sorting Numerical Values... | Excel Worksheet Functions | |||
how do i create a pie chart in excel with non-numerical values? | Charts and Charting in Excel |