| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy Filter
I now have all of my info on one line. I can get it to sort. How do I get a count of only the stores, that filtered to the criteria? How do I get a total number of circulars needed for those stores? -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=519797 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy Filter
Assuming your data (before filtering) is in A2:100, enter formula:
=SUBTOTAL(3,A2:A100) HTH -- AP "CBrausa" a écrit dans le message de ... I now have all of my info on one line. I can get it to sort. How do I get a count of only the stores, that filtered to the criteria? How do I get a total number of circulars needed for those stores? -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=519797 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy Filter
Not real sure of your situation, but the SUBTOTAL(YourRange,2) feature will
count rows in a filtered output and ignore the hidden ones......... Vaya con Dios, Chuck, CABGx3 "CBrausa" wrote: I now have all of my info on one line. I can get it to sort. How do I get a count of only the stores, that filtered to the criteria? How do I get a total number of circulars needed for those stores? -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=519797 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy Filter
Thanks for the help. It works. :) -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=519797 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
| Is there an easy way to filter duplicate rows of data in excel? | Excel Discussion (Misc queries) | |||
| Very easy question about filter!!! | Excel Discussion (Misc queries) | |||
| Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
