+ Reply to Thread
Results 1 to 11 of 11

Unique Entries from column to row for a reference

  1. #1
    Forum Contributor
    Join Date
    02-21-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Unique Entries from column to row for a reference

    Hi Gurus, please help me with the attached Workbook where I have mentioned my requirement.

    I had posted a thread for this and got the solution, but here I want to track the Unique combinations.

    The issue is I have a unique two field combination in two columns which has multiple values in the third column. I want to segregate the values in the 3rd columns for the one I need to validate. Its a business validation which has more than 15000 entries. Appreciate your help.

    I have explained in the Workbook attached.

    Please help.

    Thanks in advance.

    -Shiva
    Attached Files Attached Files
    Last edited by shivspatil; 02-08-2018 at 02:02 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Row again

    Before a moderator asks you to I suggest you amend the subeject header of your thread to something more appropriate as per Rule #1

    https://www.excelforum.com/forum-rul...rum-rules.html

    With 59 posts you should have learnt to do this by now.

    And this is a duplicate post of

    https://www.excelforum.com/excel-gen...row-again.html

    contracening Rule 5 (Wow, you're really going for it today, aren't you?)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    02-21-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Row again

    Appreciate and noted your comments. Have reposted with clarity. Thank you

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Unique Entries from column to row for a reference

    @shivspatil- are you asking for a formula to generate a list of unique POrgs for each unique vendor, like G2:M2 in your example?
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

  5. #5
    Forum Contributor
    Join Date
    02-21-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Unique Entries from column to row for a reference

    Yes Leelnich. As mentioned, I want Unique entries and Unique POrg with PI in column D with POrg-PI format eg. J001-PI in J2 cell and so on.

    All results from G2-M2 are the unique entries from columns B&C but some of them have different values in column D.
    If you see 6001 has three entries with no PI entry in column D, thus in the cell I2 I need 6001-NA to show POrg 6001 doesnt have a PI entry.
    Cells J2 & K2 Porg J001 & J003 have one entry PI in column D so we have result in the cells J2 & K2 as J001-PI & J003-Pi

    Hope I'm clear.

    Pls help, Thank You

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Unique Entries from column to row for a reference

    G2
    Please Login or Register  to view this content.
    Try this and copy towards right
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  7. #7
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Unique Entries from column to row for a reference

    This is doable with formulas, but calculation will be SLOW. VBA macro is a better choice, if permissible.

  8. #8
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Unique Entries from column to row for a reference

    If you're interested, paste this macro in a standard module (ALT+F11...ALT+I...ALT+M), adjust the ranges, and press F5 to run it:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by leelnich; 02-08-2018 at 11:23 AM.

  9. #9
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Re: Unique Entries from column to row for a reference

    Great job for double dic

  10. #10
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Unique Entries from column to row for a reference

    Thank you, daboho, much appreciated ... and thanks, shivspatil, for the rep!

  11. #11
    Forum Contributor
    Join Date
    02-21-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Unique Entries from column to row for a reference

    Thanks a million nflsales. It was really amazing and helped me a lot. I could fix the issue based on your solution that saved huge time. Repute added

    -Shiva

+ Reply to Thread

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