View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PT[_3_] PT[_3_] is offline
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