In one of the earlier topics we learned how to generate Random numbers in Excel & Google Spreadsheet. Now, we will see how to get values from Random Columns using the same function. This is kind of applying the Rand function little bit different application that we usually do. These… [Continue Reading]
Select a worksheet, enter ‘=5-3’ in any cell and press Enter. Excel will calculate the difference and display result as 2. We have just entered a Formula in Cell that starts with ‘=’ sign. If we type anything in a worksheet starting with ‘=’ sign, Excel treats it as a formula, executes the formula and display the result only.
Assuming Table Range is A1:E10 with numbers and need to search for a number, in this case ‘2’, then enter this Array Formula** to get the Row and Column number.
Making of #N/A Error & Solve it If You are an Frequent MS Excel User, then you should have seen those Unexpected return codes from Formula that start with Hash(#). These are the Error Codes that those formula return when it could not process the Input Data or Invalid Data.This… [Continue Reading]
Learn how to use VLOOKUP with simple example. VLOOKUP usage directly in Excel and within VBA Macro code. Get VBA code to use this function in Excel Automation. A Vlookup function search for ‘value to search’ in the first column of ‘table Range’ and then returns a value from the same row.
Get VBA code for Excel IP address lookup. Using this Geoip Lookup code, you can find website ip to Geo Location address. Also do bulk Geoip lookup.
Free Excel template for harvesting email ids with explanation on the process of how to collect Email Ids from a text content or webpage. With this software, Email address list can be generated that can be used for business email marketing or mass mail communication. Use this ready to use code and template.
Usual Sorting of Data or Table in Excel To Sort a Column Data in Excel, the user has to select the data range or column and then choose option “Sort & Filter”. From here, they can choose either “Smallest to Larger or A to Z” or “Largest to Smallest or… [Continue Reading]
Login Automatically into Social Media Networks in IE using Excel These days’ people spend too much time in Social Media Networks like Facebook, Twitter, and Google+. We tend to Login and Logout so frequently into these accounts. Sometimes we get tired mentally, typing these Login IDs and Passwords either because… [Continue Reading]
- Block Apps in FaceBook print screen Excel Countif Record Macro Timer in Excel Task Manager VCF HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp Wordpress python