Welcome Guest
Log In | Register )
You last visited December 9, 2016, 4:13 pm
All times shown are
Eastern Time (GMT-5:00)

analyzer.......

Topic closed. 2 replies. Last post 12 years ago by johnph77.

Page 1 of 1
PrintE-mailLink
flaboi's avatar - peace
New Member
miami
United States
Member #15147
May 10, 2005
59 Posts
Offline
Posted: May 24, 2005, 1:11 pm - IP Logged

Anyone know of a program to analyze the numbers to know how many of the same number there is? Like something that tells you theres 26 5's in your pile or 20 2's... Just a simple program.. Cause ive tryed all the programs at the site and the crunch and everything else and nothing works for me. Filters i got but i need a analyzer... If anyone knows of one it would help out a lot and it would be appreciated..

    Avatar

    United States
    Member #12495
    March 15, 2005
    76 Posts
    Offline
    Posted: May 25, 2005, 2:59 pm - IP Logged

    in Excel, if you expand the function of data analysis, the histogram function should do the trick you want.

     

      johnph77's avatar - avatar
      CA
      United States
      Member #2987
      December 10, 2003
      832 Posts
      Offline
      Posted: May 25, 2005, 7:32 pm - IP Logged

      flaboi

      Try this:

      Enter this formula into a cell outside the range you wish to analyze.

      =COUNTIF(CELL1.CELL2,5)

      where Cell 1 is the upper left limit of the range you wish to analyze and Cell 2 is the lower right limit of the range you wish to analyze.

      Punctuation must be correct.

      gl

      j

      Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

      Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

       =^.^=