Question about Microsoft Excel for PC
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.
Suggest the formula of vlookup and hlookup and give one one example of all theses formulas.
Thanks and Regards
Posted on May 13, 2008
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 04, 2011 | Microsoft Excel for PC
May 31, 2009 | Microsoft Office Excel 2003 for PC
May 07, 2009 | Microsoft Excel for PC
Feb 22, 2009 | Microsoft Computers & Internet
Jan 17, 2009 | Microsoft Excel for PC
Dec 03, 2008 | Computers & Internet
Feb 23, 2008 | Microsoft Office Standard for PC
Oct 19, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
744 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: