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…
- 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
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.