QUESTION : Struggling with obtaining a row of data based on the value within the row. I have my data […]

# Category: Ms-Excel

## Excel: Automatically extending conditional formatting to a new row added above data

QUESTION : I have a bunch of values across multiple rows and columns. They are structured so that each row […]

## Excel version confusion

QUESTION : I got an Excel file, actually it’s a zip file which contains many folders and files including sheets […]

## Looking for the mathematical equiv of the PMT function in excel

QUESTION : I have a question which I am analysing for a university paper, which is asking for the monthly […]

## I have a list of names, and tags per row (each tag is in a new column), how do I get a pivot of names per tag

QUESTION : My data is set up in such a way where I have John alpha beta gamma Mary beta […]

## .Borders(xlInsideVertical).LineStyle = xlNone

QUESTION : ANSWER :

## Auto (drag)incrementing only one cell value in Excel

QUESTION : For example, I have one table with values: 14.10% 1.60% 2.80% and I have a cell with value […]

## (How to) Average columns in Excel to display error bars in chart?

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

## 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: […]