View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
greenmachine greenmachine is offline
external usenet poster
 
Posts: 5
Default find the frequency a number appears with another number within a s

i tried using histogram but it does not return the results. I have a large
set of numbers in 5 columns. Each number represents a process(not really
important). I am trying to find how often a number appears with another
number. To explain better here are three sets of numbers,
2,13,7,15,1_1,13,19,37,35 and 2,13,8,13,5.
In this example 2 and 13 appear twice within the 3 number set. I need to be
able to anaylze the data and pull this data out. I've tried the sort feature
but it takes alot of manual sorting going through each combination. Really
confused!