Results 1 to 11 of 11

Populating a column based on previous data in 2 other columns

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Populating a column based on previous data in 2 other columns

    This is what I've come up with so far;

    =IF(AND(B1=B2,B2=B3),A1&", "&A2&", "&A3, IF(B1=B2,A1&", "&A2, A1))

    It is limited to 3 cells sadly but I need it to work into the thousands.

    What needs to happen is (Please see my data set for you)...

    AEG	79901G-M 	94975062800
    AEG	79901G-M 	94977004600
    ARTHUR MARTIN	AHT6083K 	94962052900
    ARTHUR MARTIN	AHT6083X 	94962053000
    ARTHUR MARTIN	AHT6231K 	94976005900
    ARTHUR MARTIN	AHT6331K 	94974058600
    ARTHUR MARTIN	AHT6421P 	94962045000
    ARTHUR MARTIN	AHT6431K 	94962043900
    ARTHUR MARTIN	AHT6431W 	94962043800
    ARTHUR MARTIN	AHT7531K 	94963022000
    ARTHUR MARTIN	AHT7531W 	94963021900
    FAURE 	CZC6046X 	94774075700
    ARTHUR MARTIN	EHG70830X 	94963032600
    ELECTROLUX 	EHM60335X 	94974059400
    ELECTROLUX 	EHM60335X 	94974059401
    ELECTROLUX 	EHT60235K 	94976006000
    ELECTROLUX 	EHT60235K 	94976006001
    ELECTROLUX 	EHT60235K 	94976006002
    We'll take the spreadsheet for example, it'll where there's a match in B2 and B3, it'll copy C2 and C3 and put in another cell seperated with ", ".

    Ideally resulting in a format similiar to -

    AEG	79901G-M 	94975062800, 94977004600
    ARTHUR MARTIN	AHT6083K 	94962052900
    ARTHUR MARTIN	AHT6083X 	94962053000
    ARTHUR MARTIN	AHT6231K 	94976005900
    ARTHUR MARTIN	AHT6331K 	94974058600
    ARTHUR MARTIN	AHT6421P 	94962045000
    ARTHUR MARTIN	AHT6431K 	94962043900
    ARTHUR MARTIN	AHT6431W 	94962043800
    ARTHUR MARTIN	AHT7531K 	94963022000
    ARTHUR MARTIN	AHT7531W 	94963021900
    FAURE 	CZC6046X 	94774075700
    ARTHUR MARTIN	EHG70830X 	94963032600
    ELECTROLUX 	EHM60335X 	94974059400, 94974059401
    ELECTROLUX 	EHT60235K 	94976006000, 94976006001, 94976006002
    I would honestly give a kidney for any help on the matter.
    Last edited by JJJJ1; 04-27-2010 at 11:43 AM. Reason: Broke the rules :(

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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