QUESTION : How can I pair two rows on a spreadsheet, so that for each data entry I can sort […]

# Tag: microsoft-excel-2011

## Create a form as a worksheet in Excel that adds records to another worksheet

QUESTION : I am trying to create a form in Excel for vehicle requests. What I want to happen is […]

## How do I seed another data table’s records with category information in another Excel data table?

QUESTION : I have a data table, of which one of the columns is ‘Categories’. It is a basic text […]

## Error in importing the numbers in scientific notation

QUESTION : I am importing(copy-paste) values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is […]

## Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?

QUESTION : Does anyone know how to create a formula that causes the row colour to alternate when using conditional […]

## Merge two sheets on two columns into a new sheet in Excel?

QUESTION : I’m using Excel 2011 on OSX. I have Sheet1 that looks like this: pupil_id date test_score 1 2015/10/01 […]

## How come I can only forecast a trendline 5 periods backwards, while I can forecast it 1000+ forward?

QUESTION : It doesn’t make any sense. I can do it in Excel 2010 on Windows, but not Excel 2011 […]

## Getting the name of a named cell in MS Excel 2011

QUESTION : I am using a formula in Excel, which involves cell names. The formula is =MIN(name1,name2,name3) name1 is the […]

## How can I create this column chart in Excel?

QUESTION : Well, I’m trying to create a column chart from this simple piece of data and I don’t quite […]

## How to use non-contiguous range arguments in Excel’s XIRR?

QUESTION : The XIRR requires range arguments. I would like to know how I can somehow use ‘split’ ranges which […]