Question about Microsoft Excel for PC

2 Answers

Min and Max Date range filter

Hi

I have data in a pivot chart as follows:
Posting Date Item No_ Invoiced Quantity Total 30/11/07 0116913 2 8910.02

I need to be able to type a min and max Date range (corresponding to Posting Date Column) in the excel sheet and this needs to then filter the pivot table (let me know if I need to Paste Values in another sheet) to show only the Dates within the range given.

Any help will be appreciated.

Thanks

Posted by on

  • glidergem May 08, 2008

    Hi. Thanks for that. I'll give it a try. I was hoping for something where I would be able to just change the data in the cells and not have to go through setting filters each time I want to change the output but at least this gives me what I need for now :)



    Thanks.

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Suggest the formula of vlookup and hlookup and give one one example of all theses formulas.
Thanks and Regards


Bhagat Solanki

Posted on May 13, 2008

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 26 Answers

Check out: Tools -> Data -> Filter -> Auto Filter.
You may want to look at the help function to get a better idea of how powerful this feature is.

Let me know if this helps.

Posted on May 08, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What RPMis the max torque


the chart shows figures of 10.7 hp-8.0kw with a torque of 19.5 ft/lbs- 26.4nm at 2500rpms ( max net torque)
the chart shows gx390 is 11.7hp (8.7kw) but the torque is the same as the gx340
you can get these figures from world. honda com or by going google and typing in--torque range of honda gx 340 motor at max rpms
10 hp engines running at 2500 rpms will be good for gensets of 5kw continuous out put as most makes run that size engine

Apr 20, 2016 | Honda Gx340 Gas Engine 11hp Motor Pressure...

1 Answer

Canon pixma troubleshooting


1. Make sure your printer drivers are up to date by going to the manufacturer's website and checking from and downloading the latest printer drivers for your printere.
2. Make sure you are running SP2 for Office 2007 - to check Choose Office Button, Excel Options, Resources and at the bottom of the screen it should say something like Excel 2007 (12.0,6535.5002) SP2.
3. You can print a chart while selecting it but all you get is the chart. If you want the data with the chart you need to select a range that includes the chart and the data, but this does not sound like your problem. Canon Printer Support

Mar 07, 2014 | Office Equipment & Supplies

2 Answers

What is excel


Hi,

Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

1 Answer

How to make tally charts on my laptop?


To create a tally chart in a laptop,the laptop must a spreadsheet package like Microsoft excel

these are the steps involve
-select the data to be use for graph.include the column and row label in sections
-select data
-click on number tab
-click on text
-click ok
-click on chart wizard icon on the tool bar
or
click on insert on menu bar
click on standard tab or custom types tab
under chart type list ,click to select the desire chart type eg tally.
under chart sub -type list,click to select the chart desire.
click on next button.
click on data range tab under series to select rows or columns.
click on next button.
that solve it.I hope you"ll find the solution post useful,dont forget to leave your comment by saying hope hopeful this post is to you

Oct 07, 2010 | Computers & Internet

1 Answer

Reminder in excel


There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.

Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.

Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.

Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.

May 31, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Count the number of open and closed order status per owner


My suggestion is to use a Pivot Table.  Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.  

Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet.  then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe


May 07, 2009 | Microsoft Excel for PC

2 Answers

How do you set up window range?


or press ZOOM, option 6 (ZStandard).  That instantly resets the window range.

Jan 20, 2009 | Texas Instruments TI-84 Plus Silver...

3 Answers

Excel formula help


formula for the keys or short curt for excel

Jul 15, 2008 | Microsoft Excel for PC

1 Answer

Data for excel chart


You need to create subtotals so that it looks like something like this:

Prod/units Amt. Level Total

xxxx 10.00 1
yyyy 20.00 1
30.00

dddd 40.00 2
ffff 30.00 2
70.00

etc.

To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.

If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.

Some reading:
http://www.ehow.com/how_13020_pivot-table-wizard.html
http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Also Google "Excel pivot table wizard" to get more.

Good luck!

Feb 23, 2008 | Microsoft Office Standard for PC

1 Answer

Excel Pivot view


Highlight the entire pivot table and name it as a range. Then in the formula, replace the reference to the table addresses with the range name. Then wherever you move the table (move, not cut and paste) it will automatically gather the right data. Thanks for rating FixYa!

Oct 19, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

744 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18357 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...