+ Reply to Thread
Results 1 to 2 of 2

Auto populate cell from a repeated number

  1. #1
    Registered User
    Join Date
    08-16-2007
    Posts
    7

    Auto populate cell from a repeated number

    I need help finding a way to auto populate cells that have repeated numbers into new cells. Here's what I mean:
    On cells A1 thru A10 I have the followig numbers (1,2,3,4,5,1,2,3,1,3) where the number 1 and 3 repeat twice after the firts time, the number 2 repeats once after the first time. Therefore I would like auto populate cells B1 and C1 with the number 1 (because it appears twice after the fisrt time) and cell B2 with the number 2 (because it repeats once) and cells B3 and C2 with the number 3 (because it repeats twice).
    Please try to avoid macros if possible. I don't know how to use them yet. Unless the macro comes with step by step instructions. Thank you for your help and time.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Auto populate cell from a repeated number

    Using your posted example,
    try this:
    Please Login or Register  to view this content.
    Copy that formula across and down as far as you need.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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