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 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!
 
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
frequency a number repeats in a column Ken Excel Worksheet Functions 5 March 8th 07 03:12 AM
countif formula to find the occurances of a number that is greater than one number but less than another steveo Excel Discussion (Misc queries) 3 July 8th 06 02:04 AM
same number appears in a random number generator Carmel Excel Worksheet Functions 4 May 28th 06 12:22 AM
How do I count the frequency of a given number in a column? dykstra_sj New Users to Excel 6 February 2nd 06 08:32 PM
How do I find how often a number appears within a worksheet PaulGrowns1 Excel Discussion (Misc queries) 1 September 29th 05 12:13 PM


All times are GMT +1. The time now is 01:20 PM.

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"