Join Dennis Taylor for an in-depth discussion in this video Copying and sorting filtered lists, part of Managing and Analyzing Data in Excel 2010.
It's not uncommon when viewing a filtered list to want to copy the data elsewhere.…There are special rules that allow us this to proceed pretty quickly.…You don't have to worry about the hidden data.…You also have the option of pasting the data as values or actually pasting it to…include formulas where present.…Let's imagine in this particular list here, we want to apply a filter and maybe…we just wanted to see people from certain departments.…So clicking the arrow for Department will unselect all of these and choose just…the people in the ADC group and in the Audit Services group. Click OK.…
And we may or may not want to sort these, but if we do, we could do that pretty…quickly here, sort A to Z. We've isolated the two.…Let's simply highlight the data.…We might want to include the titles as well.…There is a concern though as we consider highlighting the data.…What about formulas that might be in here?…Here is a formula here, rather long, that easy formula that extracts the month.…There is another formula right there that calculates the number of years a…
Author
Released
10/27/2011- Multiple key sorting
- Single and multiple column numeric filters
- Creating a top-ten list with values or percentages
- Setting up subtotals
- Creating multiple-field criteria filters
- Creating unique lists from repeating field data
- Using the Remove Duplicates command
- Finding duplicate data with specialized arrays
- Counting the number of unique items in a list
- Using SUMIF and COUNTIF functions
- Working with the database functions such as DSUM and DMAX
Skill Level Appropriate for all
Duration
Views
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Setting Up a Database in Excel 2010
with Dennis Taylor43m 23s Appropriate for all -
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Excel 2010: Data Validation
with Dennis Taylor59m 38s Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate
-
Introduction
-
Welcome50s
-
-
1. Sorting Data
-
Sorting from the Sort menu4m 37s
-
Sorting from the toolbar4m 2s
-
Multi-key sorting3m 4s
-
Sorting columns2m 11s
-
Sorting data in random order2m 42s
-
-
2. Filtering Data
-
Creating custom filters1m 40s
-
3. Creating Automatic Subtotals in Sorted Lists
-
Setting up subtotals4m 20s
-
-
4. Using Advanced Filters
-
5. Eliminating Duplicate Data
-
6. Using Database Analysis Tools
-
Conclusion
-
Next steps34s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Copying and sorting filtered lists