January 2017 – YB Digital

Microsoft Excel Spreadsheet

How to count the number of occurrences in a list with functions in Excel

January 29, 2017January 18, 2017 ybierling 0 Comments builtin, column, count, countif, easy, en, Excel, function, list, MSOffice, option, row, sheet, simple, table, unique, value, values

Having a list of values, for example city names, and want to know how many times each unique entry is

Microsoft Excel Spreadsheet

How to count the number of occurrences in a list with a pivot table in Excel

January 28, 2017September 10, 2018 ybierling 0 Comments column, count, en, Excel, list, MSOffice, option, pivot, row, sheet, table, unique, values, various

Having a list of values, for example city names, and want to know how many times each unique entry is

How to free storage space in Android by clearing cache : Going from smartphone's storage empty to clear

How to free storage space in Android by clearing cache

January 22, 2017January 18, 2017 ybierling 0 Comments android, application, cache, clear, data, easy, en, fast, free, internal, phone, quick, settings, simple, smartphone, space, storage, useful, various

If your Android is getting slow, or throw at you an “Insufficient storage” error message when trying to install an

Best hotel to get free loyalty program reward nights in Brussels : Hotel Ramada Brussels Woluwe

Best hotel in Brussels

January 21, 2017August 14, 2017 ybierling 0 Comments Belgium, BestWestern, Brussels, ClubCarlson, en, free, HHonors, Hilton, hotel, Ibis, IHG, LeClub Accor, Marriott, membership, night, Radisson Blu, reward, Scandic

Going to Brussels, and wondering how to get free reward nights as fast as possible, which loyalty program to choose,

How to combine two data sets and create all possible combinations with Excel : Result of combination of two data sets by creating some ID columns, and applying some vlookups

How to combine two data sets and create all possible combinations with Excel

January 15, 2017July 4, 2017 ybierling 0 Comments automatic, cell, column, combine, customer, data, en, Excel, expand, file, function, line, list, merge, Microsoft, MSOffice, product, roundup, sheet, spreadsheet, various, vlookup

Having two different data sets, for example a customers list and a products list, and want to combine them to

Prestashop how to create a discount / coupon / voucher code (percentage, fixed amount, ...) : Voucher entry in Prestashop order

Prestashop how to create a discount / coupon / voucher code (percentage, fixed amount, …)

January 14, 2017July 4, 2017 ybierling 0 Comments 1.6, amount, cart, code, coupon, create, cufflinks, discount, ecommerce, en, fixed, maleraffine, menu, online, options, order, percentage, Prestashop, rule, shop, technology, voucher, web

Creating a percentage discount code, meaning the customer enters a specific character string at the end of order process, and

StarAlliance GOLD status

How to get faster Gold Frequent Traveler with Staralliance, or why I switched from Miles&More to Miles+Bonus

January 8, 2017January 7, 2017 ybierling 0 Comments Aegean, AirOlympic, Austrian, book, en, flight, frequent, FTL, gold, international, lot, Lufthansa, miles, Miles&More, Miles+Bonus, silver, Staralliance, status, swiss, travel, traveler

Being a frequent traveller, with silver FTL status at Miles&More for longer than 5 years, I never got to the

Phone frozen how to force restart it with a hard reset

January 7, 2017January 6, 2017 ybierling 0 Comments android, Apple, en, force, freeze, Galaxy, google, hard, hardware, HTC, iPad, iPhone, iPod, phone, Pixel, reboot, reset, restart, Samsung, smartphone, soft, stuck, unresponsive, various

Having a phone (or, most likely, smartphone) not responding, probably making noise that won’t stop until the non removable battery