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 […]
How To Subtract in Excel?
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.
Search for Value in Table using Beyond Vlookup
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.
{=MIN(IF(A1:E10=2,ROW(A1:E10)))}
{=MIN(IF(A1:E10=2,COLUMN(A1:E10)))}
#N/A Error In Excel – Generate, Analyze & Exclude
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 […]
How to do VLOOKUP?
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.
VBA Code – Create Index of Worksheets – with Links to each Sheet
Vba code to create list of worksheet names with hyperlinks. Once you create this Worksheet Index using vba code, it is easy to refer the sheets. Also display worksheet list tab with macro
Making SORT More Simple and Faster in Excel with Advanced Options
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 […]
Change WordPress Excerpt Length and Default Read More
Use this techniques to change the default WordPress excerpt length of 55 and increase it to your need. Also change the setting for Read more as explained.
Excel VBA Text To Speech – Voice Application Activation
Install Excel VBA Text to Speech & make Excel VBA Speak, Voice messages. Activate Text to Speech(TTS – SAPI Win32 Speech API or Microsoft Speech SDK)
Find Synonym for Selected Text using MS Word VBA
How do we refer Synonym for a word usually? To view synonym of a text in MS Word, We have to place the cursor on the word, then Right click to get the popup menu and Select option “Synonym”. Wouldn’t it be nice if we have a keyboard shortcut, to […]