+ Reply to Thread
Results 1 to 2 of 2

If cell A2 & B2 are Duplicates of A1 & B1 fill cell C2 with C1?

  1. #1
    Registered User
    Join Date
    11-16-2014
    Location
    Mt Isa
    MS-Off Ver
    2016
    Posts
    62

    If cell A2 & B2 are Duplicates of A1 & B1 fill cell C2 with C1?

    Hopefully the title explains

    Trying to save time by getting excel to work with/for me. The sheet is needed to track a large and constantly increasing set of objects. There are connected cells to each object, that it would be great if when that object is recorded again (duplicated), rather than having to fill every cell, or go and copy and paste values, excel could do it for me.

    is this possible? i have added an example sheet for reference.

    (ps i have done research, but cant seem to find a solution that returns a value in another cell. I have find conditional formatting for duplicates, and also return static values, even counting, but not anther cell, hence coming here)
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,135

    Re: If cell A2 & B2 are Duplicates of A1 & B1 fill cell C2 with C1?

    To return another cell:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I didn't take time to look at your file but from your description put this in C2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The ? represents what you want if they are not duplicates.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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: 11-27-2018, 07:17 AM
  2. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  3. [SOLVED] How can I fill cell A1 with cell B1 Skip 70 cells and fill A71 with B2 etc....
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2013, 11:22 AM
  4. Multiple rows are duplicates EXCEPT only ONE cell. Make that ONE cell a list
    By ikesmith08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2013, 12:35 PM
  5. Replies: 2
    Last Post: 10-26-2012, 09:57 AM
  6. Replies: 9
    Last Post: 07-12-2012, 06:32 PM
  7. Replies: 1
    Last Post: 03-05-2011, 12:37 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