How do I reference a larger table in Microsoft Excel to create a smaller table?
-
I am creating report templates that would allow me to basically paste a pivot table into a spreadsheet and have certain values from that table appear in another smaller table on the same spreadsheet. I have mostly been using vlookup to get the values I need. However, this is my problem: If there a range of data A5:F35, with the F column showing percentage values, how do you construct a formula to pull certain rows from the larger table BASED ON THE PERCENTAGES and have them appear in the smaller table. For example, In the large table that is being referenced, Lets say I want only the rows with percentages between 75% and 85% to appear in the smaller table. I want to do this without copying and pasting anything over. I just want to drop the large amount of data in and let the template do the rest. I know that it must be some combination of VLOOKUP and IF functions. Any help would be greatly appreciated. Thank you.
-
Answer:
You can use the 'advanced filter' feature to solve the problem. Link given below. P. S. You can use a simple loop macro also to solve the problem.
Doug at Yahoo! Answers Visit the source
Other answers
You dont have to do that, the old copy and paste works just fine open both files select data from the one you want to copy. Then copy and paste to area you want the data in the smaller table done.
garrytoo
Related Q & A:
- What is Hash Table, how to create a hash table?Best solution by Stack Overflow
- How do I create an HTML table, in jQuery, with JSON data?Best solution by Stack Overflow
- How can I write a good reference letter?Best solution by dailywritingtips.com
- How do I cancel my current yahoo email address and then create a new one?Best solution by Yahoo! Answers
- How can I get a bahrain transferable visa in order to find a job?Best solution by evisa.gov.bh
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.