Scrap Girls Digital Scrapbooking Forum: Is It Possible To Sort My Wish List? - Scrap Girls Digital Scrapbooking Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Is It Possible To Sort My Wish List? finding and removing duplicates

#1 User is offline   Kate Davis 

  • Hot Scrapper
  • PipPipPipPipPipPip
  • View gallery
  • Group: Members
  • Posts: 964
  • Joined: 14-August 12
  • Gender:Female
  • Location:UK

Posted 10 October 2012 - 04:28 PM

I've just been through my wishlist looking for holiday items to buy in the sale. As I scrolled through my list I got the impression that I have some items several times (maybe 4 or 5 :embarrassed003: ). Is it possible to sort the list or identify and delete duplicates?

Plus is it possible to prevent this happening in the future or will it always happen if something is already on my list and I add it again?
Posted Image
You can get more of me on Twitter or on my main blog.

#2 User is online   Belle 

  • Scrap Girl Messageboard Wise One
  • PipPipPipPipPipPipPipPipPipPip
  • View gallery
  • Group: Members
  • Posts: 18,337
  • Joined: 14-March 10
  • Personal Statement:I have 3 children and 7 grand's. All live close by, so I consider myself one very blessed lady.
  • Gender:Female
  • Location:Cape Town South Africa

Posted 11 October 2012 - 03:07 AM

Would not know. I don't have all that much on my list at the moments. Good thing to know though.
Posted Image

Posted Image Posted Image Posted ImagePosted ImagePosted Image

#3 User is online   ValerieT 

  • Scrap Girl Messageboard Wise One
  • PipPipPipPipPipPipPipPipPipPip
  • View blog
  • View gallery
  • Group: TOU Administrator
  • Posts: 5,750
  • Joined: 06-February 12
  • Personal Statement:Mad as a hatter, with the patience of a saint!
  • Gender:Female
  • Location:Yorkshire, UK

Posted 11 October 2012 - 04:33 AM

I know you can sort by priority, I don't think you can any other way.

As for duplicates, I had some too, so I'm guessing the store software can't tell what's on our wish list. Hopefully someone can confirm this.
Posted Image
Posted Image Posted Image Posted Image Posted Image Posted Image

#4 User is offline   Nica 

  • Scrap Girl Messageboard Wise One
  • PipPipPipPipPipPipPipPipPipPip
  • View gallery
  • Group: Scrap Girls Layout Artist Team
  • Posts: 2,746
  • Joined: 09-September 09
  • Personal Statement:Love God
    Love Others
    Offer Hope
  • Gender:Female
  • Location:Michigan

Posted 11 October 2012 - 06:53 AM

Okay, I asked this question before myself. I understand that I can mark the various products as "high, regular, or low" priority, but can you actually sort them? I would love to go to my wishlist and see just the high priority items, for instance, or maybe just the "Value Packs" or "Brushes" without having to scroll through the whole list.
Posted Image
Posted ImagePosted ImagePosted Image

#5 User is offline   Kate Davis 

  • Hot Scrapper
  • PipPipPipPipPipPip
  • View gallery
  • Group: Members
  • Posts: 964
  • Joined: 14-August 12
  • Gender:Female
  • Location:UK

Posted 11 October 2012 - 09:01 AM

View PostNica, on 11 October 2012 - 06:53 AM, said:

I would love to go to my wishlist and see just the high priority items, for instance, or maybe just the "Value Packs" or "Brushes" without having to scroll through the whole list.


Perhaps that is why you can have more than one list, although not sure what you do if you have a list for type and theme it could start getting really confusing!

When I moved all the items I want from bookmarks to the wishlist I had some issues and it looked like items hadn't been added so I tried again (and again and again in some cases). But it is also possible I've added some again just browsing the boutique or after looking after some layouts in the forum.
Posted Image
You can get more of me on Twitter or on my main blog.

#6 User is offline   Kate Davis 

  • Hot Scrapper
  • PipPipPipPipPipPip
  • View gallery
  • Group: Members
  • Posts: 964
  • Joined: 14-August 12
  • Gender:Female
  • Location:UK

Posted 13 October 2012 - 04:38 PM

I have sorted my wish list and removed the duplicates. In case it is useful for anyone else, here is what I did

  • Copy all text from wish list
  • Paste special into Excel as text
  • Add new row 1 and add column header e.g. type and title
  • Apply filter and filter on column A for product type (should now have just titles for each item)
  • Sort column B in alphabetic order (this will enable you to see which titles are included more than once)
  • On wish list do text search for duplicate titles and delete all but one of each title


Instead of sorting column B I actually used a pivot table to only show which items were duplicated, but didn't want to scare people off. However it did give me some interesting information. I originally had 406 items on my list and had duplicates for 78 of them. My list is now down to 281 items (not that short :)). I had two items duplicated 6 times!
Posted Image
You can get more of me on Twitter or on my main blog.

#7 User is offline   CRS 

  • Scrappin' with CS5
  • PipPipPipPipPipPipPipPipPipPip
  • View blog
  • View gallery
  • Group: Scrap Girls Welcoming Committee
  • Posts: 26,775
  • Joined: 21-February 06
  • Gender:Female
  • Location:Columbia, Maryland

Posted 13 October 2012 - 08:00 PM

For those douplicates....I guess you really liked it! LOL, thanks for the info!

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users