+ Reply to Thread
Results 1 to 7 of 7

Formula for finding repeats in previous row

  1. #1
    Registered User
    Join Date
    01-31-2009
    Location
    Florida, USA
    MS-Off Ver
    Excel 2011 Mac
    Posts
    4

    Post Formula for finding repeats in previous row

    I am not good with formulas in Excel and I was hoping that someone might be able to help me. I'll try to show below what I would like to do.

    0 1 2 3 4 5
    0 2 4 5 X
    1 3

    So the first row has 5 numbers, and the second row has 4 numbers that repeated from the previous row, therefore is an "X" next to the numbers. But in the third row, there are two numbers, but they're not repeats from the previous row, therefore there is no "X" next to the numbers.
    I need a formula that can help me do this, is it possible? Basically each row is looking for ANY repeats from the previous row, and if there is, an X automatically appears in the cell next to the numbers.

    One more thing, is it possible to insert a check mark instead of "X"

    I'm very sorry if I'm not very clear at what I want done. I'm not good with excel or math language lol.
    Thanks ahead of time for any help that I can get.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula for finding repeats in previous row

    is numbers are in same cell or in different cells in a row
    if possible attach sample excel file with desired results
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    01-31-2009
    Location
    Florida, USA
    MS-Off Ver
    Excel 2011 Mac
    Posts
    4

    Smile Re: Formula for finding repeats in previous row

    Thanks for the quick response! Sorry, I didn't realize earlier I could've attached an excel file to show you what I wanted done. Please check the attachment to see the file. Thanks.
    Attached Files Attached Files

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula for finding repeats in previous row

    =IF(AND(INDEX(COUNTIF(A2:F2,A3:F3),0)),"X","")
    Try this and copy towards down

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula for finding repeats in previous row

    Even try below array formula (Shift+Ctrl+Enter)
    =IF(AND(COUNTIF(A2:F2,A3:F3)),"X","")

  6. #6
    Registered User
    Join Date
    01-31-2009
    Location
    Florida, USA
    MS-Off Ver
    Excel 2011 Mac
    Posts
    4

    Re: Formula for finding repeats in previous row

    Thanks so much, I'll try them and get back to you on if they work or not.

  7. #7
    Registered User
    Join Date
    01-31-2009
    Location
    Florida, USA
    MS-Off Ver
    Excel 2011 Mac
    Posts
    4

    Re: Formula for finding repeats in previous row

    I tried them both but it didn't work...sorry, can you please help me again? I tried Googling for a few hours and I saw the Match function, I tried that too, but I got errors because I don't know if the lookup_value can be a range instead of just one number. I also saw SUMPRODUCT function but I'm completely confused by that one. Any help that I can get from you would be great. Thanks!

+ 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. Replies: 6
    Last Post: 12-09-2012, 09:00 PM
  2. [SOLVED] a 365 day report..easy way to create formula that repeats adding the previous sheet?
    By acolyte13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-18-2012, 07:45 PM
  3. Formulae for: 4 most repeats,4 least repeats in a series of numbers
    By Sedge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2010, 04:56 AM
  4. Need function for finding and indicating repeats/duplicates
    By CL39 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-20-2008, 01:30 PM
  5. function for finding repeats in a column...
    By killertofu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2006, 04:03 PM

Tags for this Thread

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