Results 1 to 6 of 6

Thread: Best way to mass search a list on another list :)

  1. #1

    Joined
    Feb 2018
    Posts
    27
    Userbars
    1
    Thanks
    8
    Thanked
    14/8
    DL/UL
    12/0
    Mentioned
    3 times
    Time Online
    2d 23m
    Avg. Time Online
    1m

    Best way to mass search a list on another list :)

    Soo I have "The list"

    I have a list of Emails

    I want to select lines that contain that email and extract them onto another sheet.

    Any people know of a way?

    Kinda pulling my hair out of this one.

  2. #2
    Crazy Cat Lady PrettySarcastic's Avatar
    Joined
    Jun 2015
    Posts
    2,203
    Pronouns
    she/her
    Userbars
    56
    Thanks
    4,482
    Thanked
    6,589/1,483
    DL/UL
    47/0
    Mentioned
    392 times
    Time Online
    163d 17h 35m
    Avg. Time Online
    1h 13m
    @(you need an account to see links)

    Kind of depends. I have never seen the magic list.

    If it's in Excel format (or Google Sheets), this could probably be done with some snazzy formulas.

    I'm pretty good in Excel, so if so, let me know if I can assist.




    graphics by Flordibel & Menine <3

  3. #3
    Jumbo Shrimp's Avatar
    Joined
    Nov 2017
    Posts
    150
    Userbars
    5
    Thanks
    190
    Thanked
    154/55
    DL/UL
    23/0
    Mentioned
    13 times
    Time Online
    18d 14h 47m
    Avg. Time Online
    11m
    why not just have the usernames sent to the email?

  4. #4

    Salivating Slorg's Avatar
    Joined
    Aug 2015
    Posts
    198
    Userbars
    3
    Thanks
    119
    Thanked
    189/88
    DL/UL
    19/0
    Mentioned
    16 times
    Time Online
    25d 11h 19m
    Avg. Time Online
    11m
    Copy both lists into an excel spreadsheet. highlight all the data, click Conditional Formatting → Highlight Cells Rules → Duplicate Values

    Click ok, Bam.

    Should highlight the cells of all the duplicate emails in the list
    Add salt to taste!

  5. #5
    Saiyan Race
    j03's Avatar
    Joined
    Dec 2011
    Posts
    13,720
    Userbars
    166
    Thanks
    5,906
    Thanked
    33,076/6,608
    DL/UL
    23/36
    Mentioned
    3,867 times
    Time Online
    563d 4h 55m
    Avg. Time Online
    3h 13m
    Need more detail to your post... Some of the responses on this topic don't relate at all to what you asked me via PM, assuming it's the same scenario.

    Maybe share some code that you've already tried so we can work with something.
    (you need an account to see links)
    (you need an account to see links)(you need an account to see links)

    ------------------------
    [02/24/2013] Stealth CORE is made into the first standalone Neopets auto-player.
    ------------------------


  6. #6

    Joined
    Feb 2018
    Posts
    27
    Userbars
    1
    Thanks
    8
    Thanked
    14/8
    DL/UL
    12/0
    Mentioned
    3 times
    Time Online
    2d 23m
    Avg. Time Online
    1m
    You are correct joe it is the same as what we discussed, but PrettySarcastic the legend managed to assist me and come up with a beautiful system using excel to sort it!

    But thanks to those who tried to help!

Posting Permissions

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