LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Extracting a list from an array

I have a large rectangular table filled with cells each holding
numerical integer values, from -2,000 to + 2,000.

I want to extract a listing sorted by values, ending up with a two
column list data in the form of:

Value1, frequency1
Value2, frequency2

Etc…

Is there a statistical or other Ifunction which will accomplish this
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Extracting datas from one list not on another list Dani Lima Excel Worksheet Functions 7 December 19th 08 12:50 PM
Extracting List of Occurrences Terry Bennett Excel Worksheet Functions 7 January 15th 08 10:49 PM
Extracting from a List Mike Moore Excel Discussion (Misc queries) 2 January 19th 07 08:37 PM
Extracting Data from a list andrewc Excel Worksheet Functions 3 December 13th 05 03:31 PM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"