Custom Label and Count Duplicates

  • Hi,


    Is is possible to insert a custom label in duplicates after counting? I want to achieve Column D in the spreadsheet below:


    [ATTACH=CONFIG]51879[/ATTACH]


    A B C D
    [TABLE="width: 693"]

    [tr]


    [td]

    Shipping Name

    [/td]


    [td]

    Address

    [/td]


    [td]

    City

    [/td]


    [td]

    Count

    [/td]


    [/tr]


    [tr]


    [td]

    Black Badger (The)

    [/td]


    [td]

    55 Water St North

    [/td]


    [td]

    Cambridge

    [/td]


    [td]

    1 of 2

    [/td]


    [/tr]


    [tr]


    [td]

    Black Badger (The)

    [/td]


    [td]

    55 Water St North

    [/td]


    [td]

    Cambridge

    [/td]


    [td]

    2 of 2

    [/td]


    [/tr]


    [tr]


    [td]

    Charaka Kithulegoda c/o ING

    [/td]


    [td]

    3389 Steeles Avenue East, Suite 1100

    [/td]


    [td]

    Thornhill

    [/td]


    [td]

    1 of 1

    [/td]


    [/tr]


    [tr]


    [td]

    County Bistro (Blu)

    [/td]


    [td]

    92 King Street West

    [/td]


    [td]

    Cobourg

    [/td]


    [td]

    1 of 3

    [/td]


    [/tr]


    [tr]


    [td]

    County Bistro (Blu)

    [/td]


    [td]

    92 King Street West

    [/td]


    [td]

    Cobourg

    [/td]


    [td]

    2 of 3

    [/td]


    [/tr]


    [tr]


    [td]

    County Bistro (Blu)

    [/td]


    [td]

    92 King Street West

    [/td]


    [td]

    Cobourg

    [/td]


    [td]

    3 of 3

    [/td]


    [/tr]


    [/TABLE]


    TIA!

  • Re: Custom Label and Count Duplicates


    Yes it is. Have you a sample worksheet?

    Regards


    Fotis :hammerhe:


    [SIZE=4]. [/SIZE]Array(CSE) { }, formulae are confirmed with CONTROL+SHIFT+ENTER.


    [SIZE=4]. [/SIZE]-Replace commas ( , ) with semicolons ( ; )-or vice versa in formulae, if your locale setting demands.


    [SIZE=4].[/SIZE]--Don't attach a screenshot--Just attach your Excel file!


    [SIZE=4].[/SIZE]--[SIZE=3]KISS[/SIZE]([SIZE=2]Keep it simple Stupid[/SIZE])

  • Re: Custom Label and Count Duplicates


    Try:


    =COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)&" of "&COUNTIFS(A:A,A2,B:B,B2,C:C,C2)


    copied down

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Custom Label and Count Duplicates


    Cross-posted here. Please read the forum rules (both forums!) on cross-posting.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!