User Andi Mohr

0 votes

Excel: Autofill Col2 cell of tableB from Col2 of tableA (if Tab 1 Col 1 matches Tab 2 Col 1)

answered Dec 11, 2015 at 10:16

4 votes

Find largest value, Nth largest and others before it? (while ignoring duplicates)

answered Dec 8, 2015 at 11:42

17 votes

How to generate random string from a set of available strings in Excel?

answered Nov 12, 2015 at 15:50

1 vote

Manually-generated excel files versus computer-generated reports/files

answered Oct 30, 2015 at 11:55

2 votes

How can I sum a column with cells containing text?

answered Oct 29, 2015 at 12:43

2 votes

Accepted

Excel Help - Is it possible to return the column number of the 2nd match within a horizontal array?

answered Oct 27, 2015 at 18:03

2 votes

Accepted

Row Reference instead of Cell Reference

answered Oct 21, 2015 at 10:03

2 votes

Accepted

Avoiding one broad column in PivotChart in Excel

answered Oct 20, 2015 at 11:56

1 vote

Excel Lookup for work sheet comparison

answered Oct 20, 2015 at 10:48

2 votes

I need an elegant way to decode a series of codes into a single Excel cell

answered Oct 16, 2015 at 16:45

3 votes

Build a lookup query in Excel using named ranges stored in a cell

answered Oct 13, 2015 at 12:40

0 votes

Accepted

Most recent date for ID in Excel 2003 Pivot Tables

answered Oct 12, 2015 at 16:15

0 votes

How can I filter out only those values that have appeared more than once in a column?

answered Oct 12, 2015 at 15:58

30 votes

Accepted

Why can I see a font even if it is not installed

answered Sep 4, 2015 at 10:48

3 votes

Accepted

Can I customise the new Timeline slicer in Excel 2013?

answered Jul 20, 2015 at 9:16

0 votes

How to show most common multiple data across values in excel

answered Jul 6, 2015 at 11:28

0 votes

OneNote 2010 keeps crashing on Windows XP

answered May 27, 2015 at 9:29

2 votes

Is there a way to fit two pages on one page in MS Excel when printing?

answered Apr 23, 2015 at 12:33

3 votes

How to merge two Excel columns into one (the other way)

answered Mar 25, 2015 at 10:56

2 votes

Accepted

Win 7: Changing Desktop Background Colour (but not image)

answered Mar 20, 2015 at 13:39

2 votes

Using AVERAGEIF, how do I exclude Zeros?

answered Dec 23, 2014 at 12:13

1 vote

Inserting specific number of rows in Excel

answered Dec 10, 2014 at 17:02

11 votes

Accepted

Combining address function and cell function in Excel

answered Dec 5, 2014 at 13:09

1 vote

Accepted

Excel 2010 : How to compute the number of non blank cells in a column among the entire workbook

answered Dec 2, 2014 at 11:31

6 votes

Accepted

Count the number of rows with equal values in two specified columns

answered Nov 28, 2014 at 11:30

0 votes

Appending Group Labels to Discrete Values in Excel

answered Nov 18, 2014 at 17:18

7 votes

Accepted

How to keep Excel line graph from incorporating dates that are not in my range

answered Nov 18, 2014 at 17:08

3 votes

Freezing a header row until another header scrolls on screen

answered Nov 17, 2014 at 11:56

1 vote

Conditional Formatting Cells with Different Values for Rows with the Same Value in Specific Column

answered Oct 30, 2014 at 18:38

1 vote

Excel scatter chart to show crossbar on selected point

answered Oct 28, 2014 at 17:17

Stack Exchange Network

117 Answers

Excel: Autofill Col2 cell of tableB from Col2 of tableA (if Tab 1 Col 1 matches Tab 2 Col 1)

Find largest value, Nth largest and others before it? (while ignoring duplicates)

How to generate random string from a set of available strings in Excel?

Manually-generated excel files versus computer-generated reports/files

How can I sum a column with cells containing text?

Excel Help - Is it possible to return the column number of the 2nd match within a horizontal array?

Row Reference instead of Cell Reference

Avoiding one broad column in PivotChart in Excel

Excel Lookup for work sheet comparison

I need an elegant way to decode a series of codes into a single Excel cell

Build a lookup query in Excel using named ranges stored in a cell

Most recent date for ID in Excel 2003 Pivot Tables

How can I filter out only those values that have appeared more than once in a column?

Why can I see a font even if it is not installed

Can I customise the new Timeline slicer in Excel 2013?

How to show most common multiple data across values in excel

OneNote 2010 keeps crashing on Windows XP

Is there a way to fit two pages on one page in MS Excel when printing?

How to merge two Excel columns into one (the other way)

Win 7: Changing Desktop Background Colour (but not image)

Using AVERAGEIF, how do I exclude Zeros?

Inserting specific number of rows in Excel

Combining address function and cell function in Excel

Excel 2010 : How to compute the number of non blank cells in a column among the entire workbook

Count the number of rows with equal values in two specified columns

Appending Group Labels to Discrete Values in Excel

How to keep Excel line graph from incorporating dates that are not in my range

Freezing a header row until another header scrolls on screen

Conditional Formatting Cells with Different Values for Rows with the Same Value in Specific Column

Excel scatter chart to show crossbar on selected point