+ Reply to Thread
Results 1 to 3 of 3

How to count items that are not repeated in one row?

  1. #1
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Question How to count items that are not repeated in one row?

    Hi,

    With reference to http://www.excelforum.com/excel-gene...ml#post2395095, how can I count a row of items that is not repeated? Is there a function to do this?

    Example,

    A1 = Apple
    B1 = Apple
    C1 = Orange
    D1 = Durian
    E1 = Orange

    Total Fruits = 3
    Last edited by Lewis Koh; 04-24-2011 at 11:05 PM.

  2. #2
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Re: How to count items that are not repeated in one row?

    Hi, I got it. Pls ignore this post. Thanks.

    =SUMPRODUCT((A1:E1<>"")/COUNTIF(A1:E1,A1:E1&""))

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: How to count items that are not repeated in one row?

    Hi Lewis,

    See the attached with a helper column and the answer at the top.

    You could also do a Advanced Filter using the Unique check box.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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