Fill cells based on the other 3 cells unique combination the value on the target cell

Discussion in 'Excel' started by dp111, Apr 10, 2018.

  1. dp111


    Apr 10, 2018
    Likes Received:

    I have the following requirement:

    if cells A3, B3, C3, have unique combination, then enter in cell D3, the next 'incremental' value from D1, D2.

    Ie: if the the combination of the three cells is unique and for example in D2 is AB002 enter in D3, AB003; if the combination is not unique enter the same as last one.

    Thanks a lot,

    dp111, Apr 10, 2018
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.