Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
frequency a number repeats in a column | Excel Worksheet Functions | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
same number appears in a random number generator | Excel Worksheet Functions | |||
How do I count the frequency of a given number in a column? | New Users to Excel | |||
How do I find how often a number appears within a worksheet | Excel Discussion (Misc queries) |