Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
items filtered
I have all of my data filtered.Ex. : I go in and select filter for people by
the name of Smith. At the bottom left corner it should say "4 items out of 52 found". My spreadsheet no longer gives me that information it just says "filter mode". I never had this problem before, I'm assuming I have accidently keyed something in wrong. HELP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
items filtered
You can use the SUBTOTAL function like
=SUBTOTAL(3,Full_Range)&" items out of "&COUNTA(Full_Range)&" found" for an explanation see http://www.contextures.com/xlautofilter02.html#Count -- Regards, Peo Sjoblom "roxanne" wrote in message ... I have all of my data filtered.Ex. : I go in and select filter for people by the name of Smith. At the bottom left corner it should say "4 items out of 52 found". My spreadsheet no longer gives me that information it just says "filter mode". I never had this problem before, I'm assuming I have accidently keyed something in wrong. HELP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
items filtered
Hi,
Please check the below link, so that you will get some idea. http://support.microsoft.com/kb/213886 Regards, Soundar. "roxanne" wrote: I have all of my data filtered.Ex. : I go in and select filter for people by the name of Smith. At the bottom left corner it should say "4 items out of 52 found". My spreadsheet no longer gives me that information it just says "filter mode". I never had this problem before, I'm assuming I have accidently keyed something in wrong. HELP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I count items in a filtered list? | Excel Worksheet Functions | |||
Dificulty in copy and paste when items is filtered in excel 2007 | Excel Worksheet Functions | |||
cut and paste filtered items | Excel Discussion (Misc queries) | |||
counting filtered items | Excel Worksheet Functions | |||
How can I show the total sum of items in a filtered column | Excel Worksheet Functions |