+ Reply to Thread
Results 1 to 12 of 12

Seeing if multiple items in a dictionary exist...

  1. 05-17-2017, 09:05 AM #1
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Seeing if multiple items in a dictionary exist...

    Hi,

    So I have a sheet with about 8 columns...

    Please Login or Register  to view this content.
    So I populate the dictionary 

    Please Login or Register  to view this content.
    So there are people with the same name and same age and same team... and for when these are the same in my data across the row, I want to tally the win.


    So I am trying something like...

    Please Login or Register  to view this content.
    But this above expression only takes into account the name... can I make it so that some how it can match several columns?
    Reply With QuoteRegister To Reply
  2. 05-17-2017, 09:09 AM #2
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Seeing if multiple items in a dictionary exist...

    If you need to match multiple columns, you need to use concatenated string as Key value in dictionary object.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  3. 05-17-2017, 09:21 AM #3
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Seeing if multiple items in a dictionary exist...

    Can you show an example?
    Reply With QuoteRegister To Reply
  4. 05-17-2017, 09:27 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Seeing if multiple items in a dictionary exist...

    Here's almost the same problem

    https://www.excelforum.com/excel-pro...if-values.html
    Reply With QuoteRegister To Reply
  5. 05-17-2017, 09:38 AM #5
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Seeing if multiple items in a dictionary exist...

    Sure, upload sample workbook representing your data set and what the end result should be and I can do a demo.

    As general example....
    Please Login or Register  to view this content.
    See attached as well.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 05-17-2017, 09:53 AM #6
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Seeing if multiple items in a dictionary exist...

    Hi Please see the attached example that illustrates what I am trying to achieve
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 05-17-2017, 09:58 AM #7
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Seeing if multiple items in a dictionary exist... 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 05-17-2017, 10:23 AM #8
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Seeing if multiple items in a dictionary exist...

    Which workbook is this for @ jindon
    Reply With QuoteRegister To Reply
  9. 05-17-2017, 10:25 AM #9
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Seeing if multiple items in a dictionary exist...

    For your attachment Sheet2.
    Reply With QuoteRegister To Reply
  10. 05-17-2017, 10:45 AM #10
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Seeing if multiple items in a dictionary exist...

    This is perfect, Thank You So much!

    Just to make sure I understand it, check my commentary below
    Please Login or Register  to view this content.

    Just a brief descrip maybe of the code would be helpful and then I can mark this thread as solved
    Last edited by swade730; 05-17-2017 at 11:13 AM.
    Reply With QuoteRegister To Reply
  11. 05-17-2017, 11:14 AM #11
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Seeing if multiple items in a dictionary exist... 

    Please Login or Register  to view this content.
    HTH
    Reply With QuoteRegister To Reply
  12. 05-18-2017, 06:43 AM #12
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Seeing if multiple items in a dictionary exist...

    Thank You Again!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Retrive multiple items from dictionary
    By jaryszek in forum Excel General
    Replies: 34
    Last Post: 02-24-2017, 07:52 AM
  2. Add items to dictionary - VBA Help Needed
    By mitko007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2015, 07:26 AM
  3. [SOLVED] Looping through dictionary items where items are an array
    By strud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2014, 06:56 AM
  4. [SOLVED] Referencing multiple dic.items in dictionary to clean up my code
    By strud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2013, 07:58 AM
  5. [SOLVED] Add multiple items to scripting dictionary from one key and keep structure
    By strud in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-07-2013, 09:44 AM
  6. [SOLVED] Scripting Dictionary add additional items
    By thisisgerald in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-15-2012, 07:32 AM
  7. looping through items in a dictionary
    By Abe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-08-2006, 05:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1