Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically filtering a range
I have a two part question:
1. How do I automatically take data from one tab and sort the data based on the frequency the numbers are used and paste that data into another tab showing a column with the data and the frequency the data occurred. 2. Automatically take the data generated above and copy and paste them from columns to rows based on the top 40 numbers generated above. Also how can I set a data range for calculations that gets updated weekly without having to go back and update the range. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering Excel 2003 Charts to a date range | Charts and Charting in Excel | |||
Filtering a dynamic range | Excel Worksheet Functions | |||
filtering on range of values | Excel Discussion (Misc queries) | |||
Advanced Filtering Extract Range Missing,etc | Excel Worksheet Functions | |||
Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) |