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

Having a list of values, for example city names, and want to know how many times each unique entry is repeated ? Here’s a simple solution, using built in functions. See also with pivot table Start by copying the list, and pasting it in another column. With the pasted data selected, click on menu option […]

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

Having a list of values, for example city names, and want to know how many times each unique entry is repeated ? Here’s a simple solution, using a pivot table. See also with standard functions Start by selecting your list of values, and go to menu INSERT > PivotTable Make sure your selection is correct, […]

How to free storage space in Android by clearing cache

If your Android is getting slow, or throw at you an “Insufficient storage” error message when trying to install an app, here’s a quick solution to free some storage space up quickly. In short, clear the Cached data in the Storage menu. Open the Settings app on your phone, and locate the Storage menu. Wait […]

Best hotel in Brussels

Going to Brussels, and wondering how to get free reward nights as fast as possible, which loyalty program to choose, or which hotel is best for your budget to get free nights in Brussels ? You will get one free night every 8 paid nights in Hotel Ramada Brussels Woluwe with Wyndham Rewards. See the table […]

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

Having two different data sets, for example a customers list and a products list, and want to combine them to get a new list with all possible combinations of customers and products ? The solution is pretty simple, feasible with MS Excel in a few minutes, and, even with thousands of entries, doesn’t require much […]

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

Creating a percentage discount code, meaning the customer enters a specific character string at the end of order process, and gets X% discount on his order, is pretty easy – and it is even a standard functionality of Prestashop, called a Cart Rule in latest 1.6 version. See more detail in Prestashop online documentation To […]

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

Being a frequent traveller, with silver FTL status at Miles&More for longer than 5 years, I never got to the Gold card – even though this year, I flew 122 flight segments with them. In short, to get faster to gold FTL within Staralliance, use Miles+Bonus (Aegean / Air Olympic). You will need about 18 […]

Phone frozen how to force restart it with a hard reset

Having a phone (or, most likely, smartphone) not responding, probably making noise that won’t stop until the non removable battery runs out of power ? Do not panic, there is a simple solution, which is called power cycling, hard reset, hard reboot, force reboot, depending on the source. Basically, it is equivalent to your computer’s […]

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this. More information on http://www.google.com/intl/en/policies/privacy/partners/

Close