+ Reply to Thread
Results 1 to 5 of 5

Trying to find how many times each cell recurs in CSV, a bit special

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    11

    Trying to find how many times each cell recurs in CSV, a bit special

    I have a .csv file with 150,000 cells like this one:
    25,50,10,490,490,490,465,440,625

    I want to find how many times each one can be found in the document. Normally I could just rank them from A to Z but the thing is the order of the last 6 numbers doesn't matter so 25,50,10,490,490,490,465,440,625 is considered the same as 25,50,10,625,490,490,465,440,490 for my purposes. What I want is something like "This one can be found in the document 100 times, this one can be found in the document 25 times" for each one. Any way to do this?

    Thanks.

  2. #2
    Registered User
    Join Date
    06-07-2012
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Trying to find how many times each cell recurs in CSV, a bit special

    Are each of those numbers in a seperate cell? So, 25 is in column A, 50 is in column B, etc? Or is the whole string of numbers in one cell?

  3. #3
    Registered User
    Join Date
    05-02-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Trying to find how many times each cell recurs in CSV, a bit special

    Both can be done, I can convert the string into separate cells.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Trying to find how many times each cell recurs in CSV, a bit special

    You can list the values from 1 to max down a column, and then use the FREQUENCY function.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    06-07-2012
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Trying to find how many times each cell recurs in CSV, a bit special

    Quote Originally Posted by hihihaha View Post
    Both can be done, I can convert the string into separate cells.
    Seperate the numbers into individual columns using text-to-colums (with comma as dilineator), then use COUNTIF funtion. I think this is what you want, not sure if I understand exactly what you are asking...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1