+ Reply to Thread
Results 1 to 3 of 3

Insert duplecat values in row with conditional data

  1. #1
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    184

    Insert duplecat values in row with conditional data

    Hi All,

    I have two duplecats columns. I need to have the Result

    INPUT: is columns A & B
    OUTPUT: is column C OR (result)

    Please,wihout VBA & helper column
    data3.gif
    Regards,
    Jacob
    Attached Files Attached Files
    Last edited by Yaghoub61; 09-24-2020 at 04:52 PM.
    Notice:
    my main language is not English

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Insert duplecat values in row with conditional data

    Please try at C2
    =IF(AND(A1=A2,B1=B2),C1,N(C1)+1)
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    184

    Re: Insert duplecat values in row with conditional data

    Bo_Ry, Thank you so mhch for great help

    It is Awesome!

    It works perfectly

    Many Thanks again!

+ 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. [SOLVED] Insert columns based upon data using conditional formatting
    By Cindy Stanley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2018, 02:44 PM
  2. [SOLVED] Insert Extra Rows on Data Based on Values from Another Cell
    By Ocean Zhang in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2014, 07:48 PM
  3. Replies: 2
    Last Post: 03-12-2013, 04:10 PM
  4. Insert Values Only b/c of conditional formatting
    By nahge123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2012, 02:28 AM
  5. [SOLVED] input box to insert values under last line of data
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2012, 05:00 PM
  6. Macro To Insert Conditional Data
    By Tanya_UK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2008, 08:51 AM
  7. [SOLVED] How do I insert symbol conditional on cell values
    By Ivan Taklew in forum Excel General
    Replies: 2
    Last Post: 04-27-2006, 10:55 AM

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