hits counter

butter LONDON March/April 2014

THE CUT UP COLLECTION. butter LONDON

THE CUT UP COLLECTION. butter LONDON

Available for Spring 2014 are three new polishes from butter LONDON’s “The Cut Up” Collection!  From left to right in the image above:

Anorak: Black, white and silver chunky glitter overcoat suspended in a clear base

Dust-Up: Gold, silver and bronze chunky & fine glitter overcoat suspended in a clear base

Titchy: Multi-colour chunky and fine glitter overcoat suspended in a clear base

Click HERE to shop butterLONDON.com!

butter LONDON Steals At Ulta!

Ulta’s 21 days of beauty steals have started… and today’s deal is great for lovers of nail lacquer from butter LONDON!

butter LONDON Ulta 21 Days Of Beauty

butter LONDON Ulta 21 Days Of Beauty

Today until 9:00 pm, you can select two butter LONDON nail lacquers for a grand total of $15. What a great time to grab some shades for spring, or replenish a favorite!

Click HERE to shop Ulta.com!

Who Stopped Following Me On Pinterest?

It’s a simple question, and for those of us with an iPhone or other Apple device it’s easy enough to monitor. But this gal is a PC, so until an online application is available, I’ve been able to check this easily using Microsoft Excel.

Copying And Sorting Pinterest Followers

Copying And Sorting Pinterest Followers

Step 1: Go To Your Profile And Click On Followers

Step 2: Scroll All The Way To The End (to ensure the names of all of your followers are on the screen)

Step 3: Right Click On The Screen And “Select All”

Step 4: Paste Into A Microsoft Excel Worksheet

Step 5: Create Another Blank Worksheet

Copying And Sorting Pinterest Following Data, tutorial, how to find out who unfollowed me on pinterest using excel

Copying And Sorting Pinterest Following Data

Step 6: Click On “Following”

Step 7: Scroll All The Way To The End (to ensure all of the names of those you are following are in your worksheet)

Step 8: Paste Into A Blank Microsoft Excel Worksheet

Who Unfollowed Me On Pinterest?

Who Unfollowed Me On Pinterest?

Step 9: Turn The Gibberish Into Something Useful
You will notice that there is a pattern.  The number of rows between each name might vary, depending on what version of Excel you are using.  Enter the number 1 next to the first “follower” on the list, and zeros next to the data that you want to remove.  When you get to the second name, enter a reference back to the cell with the 1 in it.  Then copy and paste that cell all the way to the end of your list.

Step 10:  Copy the entire worksheet, and paste as values.  There is now a 1 next to each name, and zeros next to lines you’d want to remove.

Step 11:  Sort by Column C, and delete all of the zeros.  You are now left with only names in your list.

Step 12:  Repeat step 1 through 11 for your “Following” list.

Tutorial:  Who Unfollowed Me On Pinterest?

Tutorial: Who Unfollowed Me On Pinterest?

how to tell who unfollowed you on pinterest, using excel

Tutorial: Who Unfollowed Me On Pinterest?

Step 13:  At this point, you will have two lists that look like the screenshot above.  One contains the names of your followers, and the other a list of names you are following.  Go to the tab that contains the list of those you are following, and enter a vlookup function with your list of followers as the data source.

Who Unfollowed Me On Pinterest?

Who Unfollowed Me On Pinterest?

Step 14: Copy the vlookup formula all the way down to the end of your list. The names with a “1″ are following you in return. The names with a #n/a are not. You can now scroll through your Following list, to determine if these names still deserve you as a “fan” or not.

If you’re looking to see which of your followers has stopped following you, collect these databases over time and use vlookup to compare them to each other!

Questions?  Please leave a comment here!

Make Up For Ever HD Blush Review

Make Up For Ever HD Blush Closeup, photo, photos, review, reviews, opinion, opinions, beauty blog

Beauties: Make Up For Ever HD Blush Closeup

Press SampleA recent launch that I have been SO EXCITED to get my hands on is Make Up For Ever HD Blush!  These creamy cheek colors are available in a bouquet of pinks, peaches, neutrals, and even orange! [Read more...]

Fairly Precious Swatch, MAC Extra Dimension Skinfinish

Fairly Precious Swatch, MAC Extra Dimension Skinfinish

Fairly Precious Swatch, MAC Extra Dimension Skinfinish

Press SampleYou know when MAC releases any new products with the word “Skinfinish” they will be great.  I recently had the opportunity to dip into MAC Extra Dimension Skinfinish in “Fairly Precious” which was a limited-edition shade that is a universally-flattering peach with a subtle metallic finish. [Read more...]

MAC Colour Correct Collection

MAC Prep + Prime Colour Correct Collection

MAC Prep + Prime Colour Correct Collection

My complexion is always in need of a bit of correction! These products from MAC can conceal and cancel flaws to give you the perfect canvas for your makeup.  Personally, I can always use a touch of yellow to neutralize my redness.

PREP+PRIME CC COLOUR CORRECTING SPF 30
ADJUST peachy beige
NEUTRALIZE yellow
ILLUMINATE lavender
RECHARGE apricot
SRP $30.00 US/$36.50 CDN

PREP+PRIME CC COLOUR CORRECTING LOOSE
ADJUST peachy beige
NEUTRALIZE yellow
ILLUMINATE lavender
RECHARGE apricot
SRP $24.00 US/$29.00 CDN

PREP+PRIME CC COLOUR CORRECTING COMPACT
ADJUST peachy beige
NEUTRALIZE yellow
ILLUMINATE lavender
RECHARGE apricot
SRP $24.00 US/$29.00 CDN

Click HERE to check out the collection at MAC.

NARS Sex Fantasy Blush

Sex Fantasy Blush, NARS, review, reviews, photo, photos, swatch, swatches, beauty blog, makeup blog

Sex Fantasy Blush, NARS

Press SampleWhether it be warm or cool, NARS Final Cut contains hues of pink in every flavor, and my personal new favorite is Sex Fantasy.

Modern hues of pink lean cool, and this pale pink has cool undertones, but not to the point that you’ll look like you’ve been holding your breath for too long! [Read more...]

Torres Del Paine Satin Lip Pencil, NARS Spring 2014

NARS Satin Lip Pencil, Torres Del Paine, nars spring 2014, nars spring makeup

NARS Satin Lip Pencil, Torres Del Paine

Press SampleSpring is coming!  YAY!  If you’re dying to shed heavy colors in favor of vivid spring-worthy shades, you definitely need to check out the NARS Final Cut color collection, an array of colors that resembles a blooming bouquet of spring flowers. [Read more...]

L’Occitane Zesty Lime Ultra Soft Cream

loccitane-zesty-lime-ultra-soft-cream

L’Occitane Zesty Lime Ultra Soft Cream

Press SampleI’ve been using L’Occitane products for a very long time, and their Shea Butter Hand Cream can usually be found somewhere in my house, perched on a sink or tucked in a handbag.

I couldn’t wait to try this eye-opening scent to help ease my skin into Spring!  L’Occitane Ultra Soft Cream is lighter than the typical body butter, and absorbs quickly (so you don’t have to wait too long to slide those skinny jeans on, after application)!  This Zesty Lime scent is exactly what I need to kick start my morning, with its citrusy zing! [Read more...]

Soft Candy Lip Scrub, Treat Beauty

Soft Candy Lip Scrub, Treat Beauty

Soft Candy Lip Scrub, Treat Beauty

This beauty blogger is a long-time fan of the brand Treat Beauty. This winter, when my lips were dry and cracking, I purchased Treat Beauty Soft Candy Lip Scrub to get them back to a soft and supple state. This formula is indeed a treat! This highly-emollient scrub is coarse enough to soften rough lips, and even has a super-sweet taste.

Retail price is $22. You can purchase this at TreatBeauty.com or Amazon.com.