ybierling – Page 26

ybierling July 17, 2016May 31, 2018 cells, compare, en, Excel, format, how to do vlookup excel, list, master, simple, text, values, vlookup, vlookup excel, vlookup from another workbook, vlookup not working in excel, vlookup partial match, what is vlookup used for, why is my vlookup not working, why is vlookup not working

Master Excel values vlookup – How to do vlookup

When applying vlookup on lists from different sources, you might easily end up not being able to match values. Typical

Various

ybierling July 3, 2016May 31, 2018 data, duplicates, en, Excel, Excel 2013 order a list and remove duplicates, excel order a list, excel order list remove duplicates, excel remove duplicates, how to remove duplicates in excel, remove duplicates in excel, sort, useful, various

Excel 2013 order a list and remove duplicates

Ordering a list and removing duplicates is a common and useful operation, when working with data lists : email addresses,

International Various

ybierling June 12, 2016November 18, 2016 bank, calendar, en, Geneva, german, holidays, international, outlook, public, swiss, various, zurich

French, German, Polish, Swiss, Ukrainian bank holidays Outlook calendar entries

Always wondering when are the public holidays ? See below some useful Outlook calendars, that you can directly import either

International Various

ybierling December 13, 2015November 18, 2016 birthday, business, christmas, en, gentleman, gift, international, laptop, luggage, shopping, travel

Gift ideas for business gentleman

What to offer to a businessman, a gentleman, a white collar globetrotter ? This question never gets old… As a

Web-en

ybierling August 13, 2015November 18, 2016 browser, caching, css, en, google, htaccess, javascript, optimization, pagespeed, php, web

Fix Google PageSpeed Insights issues and get green

Google PageSpeed Insights [1] is a great tool to see how your website perform. In case you got a poor

Web-en

ybierling August 12, 2015November 18, 2016 apache, compression, en, google, gzip, htaccess, optimization, pagespeed, php, web

Fix Google PageSpeed enable compression in PHP and htaccess

Enabling gzip compression on your script / webserver will not only help you achieving a greater score on Google PageSpeed

Web-en

ybierling August 11, 2015November 18, 2016 browser, caching, en, google, htaccess, optimization, pagespeed, web

Fix Google PageSpeed leverage browser caching in htaccess

To optimize browser caching in htaccess, simply add the following code inspired by a Stack Overflow thread [1] in your

Web-en

ybierling August 10, 2015November 18, 2016 content, css, en, google, javascript, optimization, pagespeed, web

Fix Google PageSpeed Eliminate render-blocking JavaScript and CSS in above-the-fold content

The Google PageSpeed [1] test “Eliminate render-blocking JavaScript and CSS in above-the-fold content” propose you to delivers your site’s JS

Various

ybierling August 4, 2015November 18, 2016 batch, en, gimp, image, MASS, processing, update, various

Mass process and update a batch of images using GIMP

In various occasions, it is useful to update in one shot a batch of images. This operation takes a few

SAP-en

ybierling July 12, 2015May 6, 2016 bom, component, cs02, cs03, en, item, material, SAP

Add following material in an SAP BOM item

Following BOM item missing After a BOM copy or migration to a new plant, the following items might not have

Web-en

ybierling April 19, 2015July 11, 2018 en, how to import database in phpmyadmin, how to import sql file in phpmyadmin, import database phpmyadmin, limit, mysql, php upload max filesize, phpmyadmin, phpmyadmin import csv, phpmyadmin import ods, phpmyadmin import opendocument spreadsheet, web, xampp

Import a large SQL file in PHPMyAdmin

If you are wondering how to be able to import a larger SQL file in PHPMyAdmin[1], the solution is pretty

International

ybierling March 15, 2015August 14, 2017 comparison, en, flight, international, Kayak, search, Skyscanner, travel, useful, various

How to find a cheap flight

Searching for a flight, at the best price, and with the more convenient schedule ? Lot of possibilities are offered

SAP-en

ybierling October 2, 2013November 18, 2016 en, Forecasting, MAPR, MM03, MPOP, PROP, SAP

SAP extract Forecasting parameters (MPOP structure)

SAP MPOP structure is not a real table, and is not directly accessible, for example using SE16N (Fig 1). Fig

Various

ybierling July 19, 2013April 20, 2016 android, en, keyboard, settings, various

Android change keyboard input language

As I got a Nexus 7 Android tablet[1], I also acquired a bluetooth keyboard (the Logitech K810[2], which seems great

Various

ybierling July 7, 2013April 20, 2016 Access, database, en, oracle, various

Reach an Oracle table in Access

If you ever tried to retrieve data from an Oracle table in MS Access, you might have experienced the error

Web-en

ybierling April 21, 2013April 20, 2016 CSS3, en, HTML5, split, text

Split a text file with HTML5

It may happen to end up with a file (Fig 1) too big, that we want to split in smaller

SAP-en

ybierling November 4, 2012November 18, 2016 configuration, en, IDOC, LSMW, SAP

SAP define a Partner System for IDoc Inbound Processing

If it ever happened to you, when trying to generate IDocs, to get the information message “No partner exists with

SAP-en

ybierling October 7, 2012April 17, 2018 en, get rid of SAP security notifications, options, remove SAP GUI security notifications, SAP, SAP GUI security notifications, security

Remove SAP GUI security notifications

Are you getting annoyed by all these SAP GUI Security notifications (Fig 1), asking you all the time if you

Various

ybierling September 30, 2012July 30, 2018 compare, compare files, compare notepad++, compare text files, compare two text files, data, editor, en, file, notepad++, simple, text, two files notepad++, useful, various

Compare two text files with Notepad++

It often happens, when you have to work with a lot of data, to need to know differences between two

Various

ybierling April 22, 2012May 31, 2018 Access, compare, compare excel access, compare excel in access, Compare two CSV tables with MS Access, compare workbooks excel, csv, en, excel compare two lists and return differences, how to compare two excel files for duplicates, how to compare two excel sheets for differences, how to compare two excel worksheets, spreadsheet

Compare two Excel tables with CSV in MS Access

It may happen to end with two different tables, in which you just want to know what are the exact

YB.Digital

Author: ybierling

Excel 2013 order a list and remove duplicates

French, German, Polish, Swiss, Ukrainian bank holidays Outlook calendar entries

Gift ideas for business gentleman

Fix Google PageSpeed Insights issues and get green

Fix Google PageSpeed enable compression in PHP and htaccess

Fix Google PageSpeed leverage browser caching in htaccess

Fix Google PageSpeed Eliminate render-blocking JavaScript and CSS in above-the-fold content

Mass process and update a batch of images using GIMP

Add following material in an SAP BOM item

Import a large SQL file in PHPMyAdmin

How to find a cheap flight

SAP extract Forecasting parameters (MPOP structure)

Android change keyboard input language

Reach an Oracle table in Access

Split a text file with HTML5

SAP define a Partner System for IDoc Inbound Processing

Remove SAP GUI security notifications

Compare two text files with Notepad++

Compare two Excel tables with CSV in MS Access