Results 1 to 3 of 3

Thread: Formula for grouping duplicates and asigning to each groud number in colum

  1. #1

    Question Formula for grouping duplicates and asigning to each groud number in colum



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, everyone,

    I am stuck!

    I have excel file with product list.

    The thing is, that I have duplicate titles.

    And for these duplicate titles, I need to attach in next colum number, so they can be grouped and filtered by numbers also, not just titles.

    In file, example of list, with all products.
    In red colum is example.

    link--> failiem [dot] lv/u/turrwqc
    or

    Precu nomenklatura for 1C Muk 2013-12-18 (macro).xlsm

    The thing, is, that I want formula or VBA, what will give me those numbers automaticly

    Example
    Colum A | Colum B
    Title | Group number
    Bread 1
    Coffey 2
    Coffey 2
    Drinks 3
    Chocolate 4
    Chicken 7
    Pork 8
    Beef 9
    Beef 9
    Beef 9
    Beef 9
    Salads 10
    Juice 11

    and etc.

    Any help would be appreciated, thanks!
    Last edited by roulendz; 2013-12-19 at 12:10 PM.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IF(A2<>A1,MAX(B$1:B1)+1,B1)

    copied down.


  3. #3

    Thanks, It worked like a charm

    Quote Originally Posted by NBVC View Post
    Try:

    =IF(A2<>A1,MAX(B$1:B1)+1,B1)

    copied down.


    Thanks, It worked like a charm!!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •