Hyperlinks In Excel– Add Remove Links Formula – Get VBA Code
Get sample code to add Excel Hyperlink using formula or using the VBA Code. Get VBA code to add, remove hyperlinks from any Excel worksheet.
Excel Import Data – From another Workbook – Query External Source
Learn how to make Excel import data from another workbook using Microsoft query method in simple steps. Also learn external reference data import techniques
Non Repeating Unique Random Numbers – Fun with Excel
In Excel VBA or any programming language we have built in function to generate random number. With these functions there are possibilities that the function can generate same number any number of times. There is no limitation set on these functions. With the code in this article, we can generate… [Continue Reading]
Engineering Unit Converter Download – Excel Table – Feet To Meters
Get Engineering Unit Converter Excel Table that can convert any to any unit. Also get built in Excel function that can convert any Engineering Unit to any.
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.
How to Create Data Table Excel?
Create a Table that has at least 2 columns. First column filled with test values and second column header with calculation to be tested.
Select this table range, then click menu -> Data -> What-If Analysis. It will have options for Scenario Manager, Goal Seek & Data Table. Now, a Pop will ask for Row Input Cell and Column Input Cell. Choose appropriate cells for Row or Column Input. Then click ok.
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)))}
Create Random Numbers in Excel and Google SpreadSheets
Get Code & Formula to generate Random numbers in Excel Sheet, VBA & Google Spreadsheets. Create Non Sequential Unexpected series of numbers.
#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… [Continue Reading]
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.
