+ Reply to Thread
Results 1 to 6 of 6

repeated numbers - numeri ripetuti

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    repeated numbers - numeri ripetuti

    Hello to all,
    this formula:
    COUNTIF($A2:$A$11,$A2)
    is repeated numbers in the range A2:A11 with a value of 2 if it is repeated.
    you can change the formula if the number is repeated write me "repeated" and not 2?
    Thank you,
    max_max
    --------------------------------------------------------------------------------------------
    Salve a tutti,
    questa formula:
    =CONTA.SE($A2:$A$11;$A2)
    trova numeri ripetuti nel range A2:A11 con il valore 2 se è ripetuto.
    è possibile modificare la formula se il numero è ripetuto mi scriva "ripetuto" e non 2?
    Grazie,
    max_max

  2. #2
    Registered User
    Join Date
    09-25-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: repeated numbers - numeri ripetuti

    I think you are looking for IF function: IF($A$2:$A$11=$A2,"Repeated","Not Repeated"). You may remove the Not Repeated to make blanks if not repeated.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,452

    Re: repeated numbers - numeri ripetuti

    May be:
    =IF(COUNTIF($A$2:$A$11,$A2)>1,"repeated","not repeated")
    Quang PT

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: repeated numbers - numeri ripetuti

    Maybe this:

    A
    B
    C
    1
    Apple =IF(COUNTIF($A$1:A1,A1)>1,"Repeated","")
    2
    Plum
    3
    Mellon
    4
    Plum Repeated
    5
    Cherry
    6
    Apple Repeated
    Last edited by AlKey; 09-28-2013 at 01:52 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: repeated numbers - numeri ripetuti

    Thank you all,
    now testing your solutions.
    Thank you again.
    max_max
    -----------------------------
    Grazie a tutti,
    ora prove le vostre soluzioni.
    Grazie ancora.
    max_max

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: repeated numbers - numeri ripetuti

    You're Welcome and thank you for the feedback. Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to copy repeated numbers
    By cruzesr in forum Excel General
    Replies: 1
    Last Post: 05-22-2008, 09:01 PM
  2. How to copy repeated numbers?
    By cruzesr in forum Excel General
    Replies: 1
    Last Post: 02-04-2008, 11:38 PM
  3. [SOLVED] finding repeated numbers
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2006, 07:10 AM
  4. Replies: 2
    Last Post: 05-02-2006, 11:20 AM
  5. delete repeated numbers
    By Labman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2005, 08:07 PM

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