Posts

XLOOKUP in Microsoft Excel

Image
How to use XLOOKUP in Microsoft Excel instead of V LOOKUP? Basically,  XLOOKUP  needs 2 arrays, one for the lookup to search for the match and the second is the return array from which the value is returned, whereas VLOOKUP uses a single table array followed by a column index number. So we can use XLOOKUP if the value that is being searched for is not the first column of the table. In the below example, we can see that column I is the first array for the search to look for a match and this need not be the first column and column H is the second array which is the return array.  

Android - Screen Flash Notification

Image
Want your screen to light up for any incoming notifications, do the following: 1) Go to Settings 2) Use the search option to go to "Flash Notifications" 3) Select the option "Screen Flash Notification" Check out the below video Note: The steps provided are from a Samsung Device (A71) on Android 11.

Java - Shirts

Image
  Click Here to Buy

SAP ABAP - Shirts

Image
Click Here to Buy

Wallpapers for Android and iOS

Image
Below are a few Wallpapers which look great on Android & iOS. Note that these wallpapers are picked up placed at the below link from different sources and are not provided by this website.

SAP ABAP - Custom Enhancement Switch Framework

Image
Enhancement implementation process The execution of every enhancement will be controlled based on entries in tables, for module-specific parameters (Sales Org, Company Code, etc.). Each enhancement will check if a flag is active or not for the module parameters in the table, for that specific enhancement. Only if the flag is active, the enhancement is executed. Features    1) Custom BADIs: We may come across requirements for which our custom logic can be implemented in a user exit or customer exit. However, so as to create multiple implementations and provide flexibility for country-specific logic, no code will be written directly in the exit. Instead, custom BADIs will be used.  2) Enhancement points inside custom programs: Custom programs for which country-specific logic is expected in the future roll-outs, enhancement points will be created and embedded in required sections of the program. This will ensure that the original program logic will not be changed for each co...

Get your signature from a paper to word document

Image
Follow the below steps to your signature from a physical hard copy onto a word document. Also ensuring that the background matches. Step 1: Put your signature on a piece of paper and take a snap of it with your mobile camera. Below is what you will have    Step 2: Open a word document that would basically have contents of a letter that you are drafting needing your signature on it and paste the signature pic from step 1 in the appropriate location. Step 3:  The next step is to ensure that the background of the signature is changed so that it matches with the rest of the content on the word document. Right-click on the image and select 'Format Picture' Go to the option of 'Picture Corrections' and set the contrast as '100' The end result is the following: