98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel london - Question
excel london - Question
Resolved · Low Priority · Version Standard
Mon 5 Mar 2007, 17:02Delegate Yanti said...
Yanti has attended:
Excel Advanced course
Question
Hello, I am trying to organize the information taken form more than one table into one, ranking only the entries different than zero into descending order.
From lists such as the below (note every continent is organized in a separate excell sheet)
EUROPE
italy 2%
england 0%
ASIA
thailand 1%
China 0%
Japan 6%
AMERICAS
US 7%
Canada 0%
Chile 5%
I need to be able to authomatically retreive the data different from ZERO, and organize them in descending order into a new excel spreadsheet.
as per below
US 7%
Japan 6%
Chile 5%
italy 2%
thailand 1%
Can you please let me know how to get this done, as I am trying but can't come up with anything./
cheers
yanti
Mon 5 Mar 2007, 17:17Trainer Amanda said...
RE: question
Hi Yanti
Thanks for your question.
You can do this by:
1. Clicking in one of the two columns that contains your data, then go to Data - Filter - AutoFilter.
2. Click the dropdown arrow about the column with the % showing and select Custom.
3. Choose 'does not equal' from the box on the left, then type 0 into the box on the right (i.e. you are applying a filter so you can see only rows where the % is not 0).
4. Click OK.
5. Copy and paste the filter results into a new spreadsheet.
I hope this works for you - let me know by reply if you have any problems.
Amanda
Mon 5 Mar 2007, 17:28Delegate Yanti said...
RE: question
Hi Amanda,
I was hoping to inser a formula in the summary table in order to retreive authomatically all the info and organize them.
as I have very many tables, I can't work on each and everyone, it would take me ages.
is it possible to achieve it with a macro or something similar?
cheers
yanti
Wed 7 Mar 2007, 11:17Trainer Garry said...
RE: question
This is a Visual Basic question which you really need to come on a course to understand the functions of doing this
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Screen Splitters in ExcelScreen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter. |
