+ Reply to Thread
Results 1 to 2 of 2

Formula for repeating items in a column

Hybrid View

  1. #1
    LaserDance
    Guest

    Formula for repeating items in a column

    I have a column with these items:

    orange
    kiwi
    mango
    orange
    banana
    mango
    orange
    tomato

    I need a formula which can count and show the repeating items. In my caseit is orange and mango. I think it should be with conditional formating, but do not know the formula.

    Thanks.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,719

    Re: Formula for repeating items in a column

    If your data is in column A then you can highlight any repeated values by using this formula in conditional formatting

    =COUNTIF(A:A,A1)>1
    Audere est facere

+ 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