Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1,388

Pareto of data

I have a columns of data (aprox 150 rows and 30 columns_). I want to extract
the top 12 values of each column in descending order. At the moment I am am
RANKing each column and then doing a HLOOHUP, it is very long winded and
making the file very big.

Any suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pull data from another sheet based on certain criteria	steve_sr2	Excel Discussion (Misc queries)	1	February 23rd 06 10:08 AM
Excel Macro to Copy & Paste	[email protected]	Excel Worksheet Functions	0	December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other?	baz	Excel Worksheet Functions	7	September 3rd 05 03:47 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM
Line Graph Data Recognition	Nat	Charts and Charting in Excel	2	April 30th 05 02:07 PM

All times are GMT +1. The time now is 11:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us