Technology Compilation - Internet, Android and Windows

Searching for the existence of similar values between the excel worksheet columns manually is fine when we have few values in a column, but if you have thousands of values in a column which has to be compared with another column for identical values, it may take a decade to do so. Microsoft Excel is a powerful tool that can be used efficiently to do such a complex task in no time. Read Also: How to protect Microsoft Excel documents with password  How to Find Duplicate Values In Excel by Comparing Columns:- For example, in the below image representation, In an Excel worksheet, we have values in two columns A and column C. In order to identify and highlight the values of column A which are also available in column C, Microsoft's Excel tool has several built-in functions and techniques to do so, whereas not every option is simple and efficient, so here we share one of the easiest ways among them. Sample Data With Employee ID's in Column A and Column C Step...

Complete Action Using - Default Setting Every Android app developers wish to attain the maximum number of users for their app. To achieve this developer will append extra features into their application, making it capable to do multitasking, so an application which you downloaded for a specific task may do several others task as well, As a result of two or more application installed in the device, which will essentially do a similar task, hence when a file/link attempted to open, Application's capable of processing the file/link will be categorized and prompt to make a selection between two choices either Always or Just Once. When "Just Once" is opted then each time it will prompt to make choices between applications which one to choose with under which category either "Just Once or Always" . But if Always is selected, from then on the file/link will be opened in the same application every time without pestering for selection from the list of application...

Texting is easy and comfortable than speaking because you will have enough time to think what you want to send (or) sometimes you may find it creepy to speak straight looking into their eyes, because when you are not sure, what you're about to talk is right or wrong, we may face a lot of inconveniences to stay in a position to talk, so most of the people opt for texting rather than speaking. Perhaps even texting can also lead you to embarrassment when you text the wrong message to the right person (or) the right message to the wrong person. If you realize immediately that either the message was wrong or the recipient was not the appropriate one to receive before it reaches to their device, then it's not too late to recall it back in WhatsApp. Read Also: Know How to Recover Deleted WhatsApp Chat Messages What is the meaning for the Whatsapp Check Marks? Whenever a message is typed on WhatsApp and enter key is pressed, then the message will go through 4 different sta...

Internet banking is the efficient way to sit back relax and do all your transaction from home without waiting in queue for hours in the bank to do a single transaction, and also there is no guarantee that how much time it would take for a transaction to complete if you visit the branch directly. So in this modern era, people are in need of the internet banking facility to avoid wasting their precious time without doing nothing in banks. State Bank of India's net banking facility can be availed by any age category account holders and based on their age & account type their access level is classified into 3 different categories such as viewing, limited and full transaction rights. Read also: How to Get SBI internet banking Facility Without Visiting Branch What is Viewing, Limited and Full Transaction Rights in SBI Internet Banking? Account-holders with full transaction rights can enjoy full freedom over their account. Whereas account holders with viewing (or) limited tr...

The main intention to append the write protection switches in USB flash drives and SD cards is to prevent accidental file deletion and to avoid suspicious files such as malware/trojan etc. from unauthorized sources delivering/storing into the USB disk. If the USB disk is in read-only mode, any attempts to create (or) edit file into the USB disk will be denied, But when you really want to make changes in the USB disk to add some more information (or) to edit the information that is already present in it, the restriction that you added on your computer initially will now prevent you from making changes such as adding new files or deleting existing files from any USB disk drive plugged into it. However, you can still read the files available in it, but you'll not be allowed to make changes and format the disk. The disk is write-protected -  You cannot format Having a flash drive/ SD card which is not completely accessible even by the owner of that device, is like having a l...

Predict Your Train Travel  - Confirm Or Not Several apps, booking schemes, e-wallet and services were created by IRCTC to make Indian Railway passengers train ticket booking hassle-free and with all these efforts carried out by IRCTC, it somehow managed to make the train ticket booking fast and easy. With crores of investments made on the escalation of bandwidth, IRCTC has rectified the problem of login at the official IRCTC ticket booking portal in peak days such as weekends, festival times and take hours, In the past, during these days/hours passengers were not even allowed to do a login to IRCTC to check PNR status or make an inquiry for travel. Read Also: How to Remove Whatsapp Photos and Videos From the Gallery and Music App Why Online Train Ticket Booking Was a Hassle Before? Before the online ticket booking scheme, people have to stand in a serpentine queue at the appropriate ticket counter to book railway tickets. And then come's online booking system, in whi...

You might have seen pictures while playing mp3 audio files on media players, and also these pictures appear as a thumbnail icon in all intended devices (if thumbnail (or) icon view is enabled) . But sometimes you may find that pictures are irrelevant in some of the mp3 files played on the media player. For instance: You will see Justin Bieber pictures, hearing Miley Cyrus "It's a party in a USA" song. Besides relevancy, customizing your favorite mp3 songs album pictures is really great fun. You can prank your friend with irrelevant pictures on mp3 files, add your favorite celebrity image in the audio playlist, etc. Here in this post, we have described two ways to add an album cover/image tag for your mp3 files, they are. Add Image to Mp3 Files Using Windows Media Player(WMP) Customize Mp3 file Album cover and properties using Mp3Tag (Recommended) Read Also: How to download youtube videos using VLC media player, Easily How to Add Pictures in Mp3 Audio Files us...