Filter #17

Have a spreadsheet, with column A: Date Column B: Daily Takings Column C: 
Profit and Column D: %

All data is recorded on a daily basis for every day of the financial year.

A summery report for data is made on the same sheet for the total of the 
financial year, which is easy enough to do for the entire year. How do I 
filter so that only data appears in the summery report from lets say July 1 - 
July 21....or any other dates I choose..........ie: is it somehow possible to 
enter Begiining Date in a cell and End dat in another cell, so it filters the 
Date column and only have that dat appear in the summery report?


0
7/6/2005 8:38:16 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
393 Views

Similar Articles

[PageSpeed] 42

Read up on advanced filter, which allows you to filter input that does
not contain "July" for example.

Hope it helps


-- 
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7094
View this thread: http://www.excelforum.com/showthread.php?threadid=385053

0
7/6/2005 9:31:30 PM
when you setup your filter, select the date column and choose Custom

In the Custom AutoFilter dialog, it'll say Show rows where:DATE
then select - 'is greater than or equal to' and in the next box type your 
first date
then select the And radio button and in the second criteria box select - 
'is less than or equal to' and type in the other date.  Click OK and you 
should then see only the date range you require.

"renold1958" wrote:

> Have a spreadsheet, with column A: Date Column B: Daily Takings Column C: 
> Profit and Column D: %
> 
> All data is recorded on a daily basis for every day of the financial year.
> 
> A summery report for data is made on the same sheet for the total of the 
> financial year, which is easy enough to do for the entire year. How do I 
> filter so that only data appears in the summery report from lets say July 1 - 
> July 21....or any other dates I choose..........ie: is it somehow possible to 
> enter Begiining Date in a cell and End dat in another cell, so it filters the 
> Date column and only have that dat appear in the summery report?
> 
> 
0
bigwheel926 (227)
7/6/2005 10:25:03 PM
If you filter the data, you can use the Subtotal function in your 
summary report, to sum only the filtered data. For example, if your 
amounts are in column E, use this formula in the summary:

   =SUBTOTAL(9,E:E)

Look in Excel's Help for the different arguments you can use in the 
Subtotal function.

renold1958 wrote:
> Have a spreadsheet, with column A: Date Column B: Daily Takings Column C: 
> Profit and Column D: %
> 
> All data is recorded on a daily basis for every day of the financial year.
> 
> A summery report for data is made on the same sheet for the total of the 
> financial year, which is easy enough to do for the entire year. How do I 
> filter so that only data appears in the summery report from lets say July 1 - 
> July 21....or any other dates I choose..........ie: is it somehow possible to 
> enter Begiining Date in a cell and End dat in another cell, so it filters the 
> Date column and only have that dat appear in the summery report?
> 
> 


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
7/6/2005 11:17:45 PM
Thanks all........great help and much appreciated

"Debra Dalgleish" wrote:

> If you filter the data, you can use the Subtotal function in your 
> summary report, to sum only the filtered data. For example, if your 
> amounts are in column E, use this formula in the summary:
> 
>    =SUBTOTAL(9,E:E)
> 
> Look in Excel's Help for the different arguments you can use in the 
> Subtotal function.
> 
> renold1958 wrote:
> > Have a spreadsheet, with column A: Date Column B: Daily Takings Column C: 
> > Profit and Column D: %
> > 
> > All data is recorded on a daily basis for every day of the financial year.
> > 
> > A summery report for data is made on the same sheet for the total of the 
> > financial year, which is easy enough to do for the entire year. How do I 
> > filter so that only data appears in the summery report from lets say July 1 - 
> > July 21....or any other dates I choose..........ie: is it somehow possible to 
> > enter Begiining Date in a cell and End dat in another cell, so it filters the 
> > Date column and only have that dat appear in the summery report?
> > 
> > 
> 
> 
> -- 
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
> 
> 
0
7/8/2005 9:41:01 AM
Reply:

Similar Artilces:

Inverting an advanced filter
I'm using the advanced filter and would like to be able to see the set of rows that are hidden after I've viewed the set of rows that the filter shows. Some of my criteria are quite complex and converting them to select the omitted rows only would be time-consuming and, knowing me, error prone. Is there a way to invert the criteria automatically so I can run the new filter, or to use the old criteria but then show the hidden rows and hide the selected rows or is there perhaps some other mechanism to allow me to see the rows filtered out rather than the rows filtered in please? Many t...

Date Filter
Hi All, I want to Filter Date from 01.10.2009 to 30.10.2009. How? Regards Rao Ratan Singh Data > Filter > AutoFilter > Custom > value is greater than 40086 and value is less than 40017 -- Gary''s Student - gsnu200909 "Rao Ratan Singh" wrote: > Hi All, > I want to Filter Date from 01.10.2009 to 30.10.2009. How? > > Regards > > Rao Ratan Singh Correction: Data > Filter > AutoFilter > Custom > value is greater than 40086 and value is less than 40117 -- Gary''s Student - gsnu200909 &qu...

Filter records not meeting criteria
Hi all, I have a table of training records, and I want to run a query to filter out a list of staff, from a staff table, which indicates those who haven't completed a particular course. TblStaff and TblTraining both have [EmployeeNumber] field relationship. TblTraining has [CourseCode], CourseDesc] fields example 363, Fire Training I want a list of staff from TblStaff who haven't completed their fire training in the last 9 months... Hope that makes sense! thanks in anticipation and cheers DubboPete Use a subquery, Pete. Example in: Subquery Basics: Identifying what is NO...

Filter from users using Exchange
Here's the skinny Outlook client receiving email from an Exchange server. User wants to filter the email so that any mail from a particular group of users goes into a folder. This is easy enough with email that originates outside of Exchange since then it has normal SMTP headers. User simply sets up filter based on these headers ( file anything with "from" that contains "mydomain.com" for instance ). However email sent from another user on the same exchange server doesn't have these headers ( opening the message and looking at options shows blank header area ). T...

multiple filter's...
I am building a quotation spreadsheet and i would like to know if it's possible when i use the filter function can i put the info on another page or somewhere else on the same page separate from the drop box?? the reason being i have multiple catagories of info on the same row to make it visual friendly, entering the info below the drop box i don't think could work since the different filters would vary in the amount of lines. But filtering is new to me and i'm not completely familiar with it's limitations. thanks in advance. Hi have a look at: http://www.contextures.com/xladv...

Outlook 2003 Junk Email filter only works on Inbox?
I have 2 pop3 accounts that both go into Outlook 2003. I use rules to move the emails to their respective folders. I have the Junk Email filter turned on High...and yet nothing gets filtered. It seems to me that Outlook moves the messages first, then runs the Junk Email filter on the Inbox. The Inbox is empty when the filter is run, thus nothing is filtered. Can anyone direct me on how to accomplish either one of the 2 solutions mentioned below? 1. Run the Junk Email filter on folders other than Inbox? 2. Run the Junk Email filter BEFORE the message rules are applied? Either option would so...

Using strwhere and Like to filter form
Hi Folks I have a project form where I have a button that when clicked it it opens another form of property addresses filtered to selections made in 3 fields called projectArea1, projectArea2 and projectArea3 which are a selection of different roads. Each project could have 1 road involved or up to 3 roads. The form is based on a query and I am trying to get the criteria field of the Road field on the query to accept the strwhere clause below. I have been trying to use the strwhere and LIKE operator to filter the form to the roads inputted on the projectArea text fields. Dim CaseFrm As St...

filters
I want to know how to make use of filters, i have a column called age, i want to filter out to different ages groups, like between 24-34 one and other 45-54. how to do that. On the "Age" col, Try Data > Filter > Autofilter > Custom Set it as, for example: "is greater than or equal to" : 24 And "is less than or equal to" : 34 Click OK (Above filters age: 24-34 inclusive) Try also Debra Dalgleish's nice coverage on Autofilter & Advanced Filter at her: http://www.contextures.com/tiptech.html Autofilter - Basics Autofilter - Filter ... ...... Fi...

Filtered lists subtotal
Hello, I have a already filtered list with Column A: Dates, and Column B: numbers. I'd like each time I re-filter the list (custom filter - "less or equal to") up to a specific date in column A to get the subtotal of the numbers in Column B. But only the filtered numbers in Column B and not the whole column (fiiltered and unfiltered) Also how can I have a cell showing every time I filter the above list, the last value (date) of Column A Thank you. Hi have a look at the SUBTOTAL function. e.g. =SUBTOTAL(9,B1:B100) >-----Original Message----- >Hello, > >I have a ...

Deployment Manager 02-17-04
After installation and configuration of MS CRM Server following the available documentation, I attempt to add users via the deployment manager, but fail. I recieve an error " You do not have the appropriate priveleges to run this wizard, contact your system administrator" or there abouts. I am the system administrator. Am I missing some obscure permission to do this or is there some little unpublished feature out there that I am unaware of? you need to log into the server with an account that has a CRM license and admin rights within CRM... -Gary "MikeYoung" <myoun...

joining to worksheets or filtering not sure of correct terminology
Hi I have two worksheets that I want to join like i can do in an access database The first is called Items and the Second is called Winners Items contains about 1000 items and each row has a unique Item Number Winners contains the same unique Item numbers but only about 100 of the Items. I want to join these worksheets where they intersect, that is the unique item number, and combine into a third sheet. I haev been abel to import both these two sheets into access and then create a relationship between them and then export the query back to excel, but this is taking me ages, and I woud liek to...

ShowAllData works when filtered, error code when all showing?
I have a PRINT ALL macro with button on a sheet. There are 2 other print macros each filtering the data by 2 criteria. The 3rd, however, is to print the entire worksheet without filters and I put the ShowAllData code at the beginning before doing the sort and bringing up the print dialogue box:\ ActiveSheet.ShowAllData Application.Goto Reference:="R1C4" Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Key2:=Range("C2") _ , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom ...

Dialog Form for filtering report
I have a custom dialog form with an unbound list box, an option group, and some check boxes, by which the user configures his report. There are command buttons for Preview and Print. The user clicks the various controls on the dialog box, then click Preview. If he doesn't like the result he closes the preview, and clicks few more boxes in the dialog form and previews again. I must be needing some kind of requery because once certain records are filtered out, they won't come back just by rechecking the appropriate checkbox. The dialog form has to be manually closed an...

Query Help Needed 01-17-08
I have a database that tracks statistics for my department. I need to be able to compare the current years and previous years totals. I also need to be able to track them by month. I believe that a cross tab query would do the job, however I am not having any luck in making it work. my table is like this monthdate field(formatted as MMMM YYYY) field1,number field2,number field3,number field4,number field5,number field6,number field7,number The numbers are obtained from our database, however they are raw numbers, we have to format them into reports. I have created the database to use...

Exchange SP2 not filtering spam sent to contacts
I have a customer who asked me to upgrade his 2003 Exchange server to SP2, mainly for the UCE filtering. Upon upgrading, I was informed their 3 Blackberry's weten't receiving mail anymore. I looked into it, and decided the best approach would be to create a Contact for each Blackberry user, and forward mail to them, thus retaining the original sender information. Problem is the spam still gets to the phones, but not the Outlook inbox. Is the server just blindly forwarding to the contacts without filtering? If that's the case, I need another idea. BES is not a financial...

Report to Filter on Next Date Per File
I have a docketing report which reports any action due for a particular file. Theses actions are future dates. A file can have multiple actions due. For example: File ABC12345 Action 6/1/2010 Letter to Client Action 6/9/2010 Payment Due Action 12/10/2010 Status Check File CYO4457 Action 3/1/2011 Letter re Exam Action 6/4/2011 Annuity Due I need to write a report which will only give me the next action due. Using my example the output would be like the following: File ABC12345 Action 6/1/2010 Letter to Client Fil...

Exchange 2007 AntiSpam / Content Filtering 03-09-10
We have a user who is getting a LOT of SPAM. Many of these contain the word "Viagra". I went into Exchange Management Console - Organization Configuration - Hub Transport - Anti-Spam - Content Filtering - Custom Words, and added Viagra (and other forms of the word) to the "blocked" section. This did not stop the "viagra" messages. Is there something that I am missing here? I even tried rebooting the server but still get the SPAM. Thanks. ...

missing or ill egal extract range advanced filter
I am trying to use the Advanced Filter in a macro routine. If I include all of the fields from the list, the macro works with my Copy to location, A1:K1. If I change my Copy to location to exclude irrelevant columns, I change the range to A1:G1. Every time I do this, I get an error messge: "The extract range has a missing or illegal field name." Since the filter runs fine, if I include all the field names, I assume I must have one missing. I'm copying and pasting the values, so the Copy to field headings match the list's field headings. Here are the criteria, if that co...

Filter data per function
Hi, I have the following problem: I want to filter my excel sheet fo unique data. I have many columns with text-numbers (example ABC145-59 and I want to filter in such a way that only the unique values ar remaining. I cannot use the data-filter function of Excel. How can I do this? Thanks Michie -- vrijberge ----------------------------------------------------------------------- vrijbergen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2775 View this thread: http://www.excelforum.com/showthread.php?threadid=47266 You could use a helper column of formulas. ...

is there an addin to pop a notify dialog based on email filters
I want to know when an email from a certain person arrives. Is there a plugin that will do this? Outlook's rules wizard will do this. Tools, Rules and Alerts in Outlook 2003, or Tools, Rules Wizard in previous versions of Outlook. -- Patricia Cardoza Outlook MVP Author - Special Edition Using Microsoft Office Outlook 2003 Lead Author - Access 2003 VBA Programmer's Reference Author - Absolute Beginner's Guide to Microsoft OneNote 2003 http://blogs.officezealot.com/cardoza http://www.cardozasolutions.com "Steve" <sss@sss.com> wrote in message news:%231J14GSb...

Disabling the Junk Mail filter
Does anyone know if/how the Junk Mail filter in Outlook 2003 can be completely and permanently disabled. We run a subscribed anti-spam service at mail server level and the client filter is creating false positives all the time and causing much unrest amongst my users! I've tried setting the filter to no automatic filtering, but this doesn't seem to stop things redirecting to the junk mail (backup notifications originating from backup exec are consistently hitting the junk mail folder despite having been added to all safe sender and recipient lists). This trivial issue is drivin...

DatePart in Filter By Form field
Howdy. I've got a form based on a query, with a column in that query using the DatePart function. Here's that field definition: WeekDay: DatePart("w",[tourdate]) In the query, the values are correctly returned (1-7). In the form, those values display correctly. When I apply "Filter By Form", the pulldown for this field doesn't show items 1-7, but shows a list of actual dates - 3/24/2010, for instance. What's going on? ...

Excel 97 #17
Does anyone know if it is possible to select multiple cells from 2 different Pivot Tables? I have 2 pivot tables, each with a Total and would like to select the Totals from the 2 Pivot Tables. I know this can be done with Office 2003 and when selected, the SUM of the cells appears in the bottom right of the spreadsheet. I don't have xl97 to test this on, but if your pivottables are on one worksheet, then select the first range and ctrl-click to select the second range. If you don't see the sum, try rightclicking on the statusbar near those embossed boxes and select Sum. Tools|O...

Recipient Filtering
Good Day All, Okay, let me say what I want first. I would like to have an area within IMF to enter the e-mail addresses that I would like IMF not to filter. Meaning any e-mails coming from that address should not be filtered. Is that possible? I thought that the Recipient Filtering was the option for this, but its just for addresses that you don't want to get e-mails. Thanks. You can do this, although you need a hotfix to be able to make the registry changes: http://support.microsoft.com/?id=912587 Todd "Kirrin Jones" <kirrinjones@itbetterbelifeordeath-gmail.com&g...

How does Outlook 2003 Junk E-mail Filter rate with 3rd-party spam-filtering software???
I was wondering if anyone knows of how well Outlook 2003 Junk E-mail Filter w/SmartScreen Technology rates alongside other 3rd-party spam-filtering software? I've been using Outlook 2003 for about 4 months and it seems to do a pretty good job of filtering my junk email. I used to get around 100 spam emails a day (unfiltered) but now Outlook 2003 filters out all except 10-20% of them. I havent had any false positives yet since I have the setting on "Low Protection". I will try to adjust that to "High Protection" soon to see if it catches more junk email, although it w...