Results 1 to 4 of 4

Thread: Count unique number in a column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-07-2014, 02:24 AM #2
    PcMax
    PcMax is offline
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    15
    Hi,

    I propose the following file
    Use a matrix to test each value

    Code:
    {=(SUM(LEN(tbl))-SUM(LEN(SUBSTITUTE(tbl;$B$9;""))))/LEN($B$9)}
    Attached Files Attached Files
    Last edited by PcMax; 01-07-2014 at 02:27 AM. Reason: Formula translated into English
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Count unique number in a cell
    By mahmoud-lee in forum Excel Help
    Replies: 3
    Last Post: 01-05-2014, 07:59 PM
  2. VBA Macro To Create A New Column Of Unique Values From Another Column Of Duplicates
    By ketats1 in forum Excel Help
    Replies: 10
    Last Post: 05-23-2013, 12:30 PM
  3. Add Trailing Count Number For Each Duplicate Value
    By Howardc in forum Excel Help
    Replies: 9
    Last Post: 05-22-2013, 09:12 PM
  4. Unique Random Number In Ascending Order
    By marreco in forum Excel Help
    Replies: 8
    Last Post: 11-04-2012, 04:15 PM
  5. Unique Count on a Filtered Range
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-14-2011, 04:29 AM

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
  •  

Forum Rules