Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2014
    Posts
    30
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Similar numbers to update other Column

    Hi,
    I need similar numbers of column D to update Column G like A, B, & C.
    Column-D|Column-G
    4536.......|A
    8787.......|A
    8787.......|B

    1111.......|A
    1111.......|B
    1111.......|C
    2222.......|A
    2222.......|B
    2222.......|C
    2222.......|C
    2222.......|C

    If similar numbers in Column D extends to more than 3 all the remaining will be defined as 'C' for Column-G.

    Thanks in Advance.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 645 Times in 589 Posts
    John,

    If your number started at D4 then in G4, place the following formula then copy down:

    =IF(COUNTIF($D$4:$D4,D4)<4,CHAR(64 +COUNTIF($D$4:$D4,D4)),"C")

    John1.png

    HTH,
    Maud

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    John_2014 (2016-05-06)

Posting Permissions

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