QUESTION : This seems simple to me but can not find the answer on-line. If I have several columns of […]

# Tag: microsoft-excel

## Excel Return Max Text Value Using VLOOKUP

QUESTION : I need to come up with a formula in excel that will identify the max and min software […]

## Solve systems of linear equations in Excel without using VBA

QUESTION : Suppose you have the following system of linear equations and want to solve for x, y, and z: […]

## Scoping a macro to current row

QUESTION : Brand new to VBA in Excel coming from HTML forms world and trying to understand how excel expects […]

## Copy formatted tabbed table trimmed in Excel

QUESTION : I have a text editor logbook and need to copy the contents into an Excel sheet. Logbook content: […]

## How to bulk convert Base64 to images in an Excel file

QUESTION : I have an excel file with 500 rows of image URIs in Base64 (as you can see in […]

## Highlight the duplicate rows in a Excel’s workbook

QUESTION : I have a workbook with multiple worksheets with values. The main values are A B C and in […]

## Convert text string to date/time format in Excel

QUESTION : I have a column with date/time info in following format stored as text: 03.01.2011 09:55. How can I […]

## SUMIF with multiple match criteria in Excel

QUESTION : I’m trying to create a formula so that if in cell E2 it says “Market”, “Limit”, or “Stop” […]

## Merge 2 sheets, always keeping the value from sheet 1 if there are duplicates?

QUESTION : I have 2 Excel sheets that I’d like to merge. They are an inventory file and are roughly […]