User nutsch

87 votes

How to split a string based on ":" in MS-Excel?

answered Oct 3, 2012 at 16:34

9 votes

Formatting a column based on another columns cell TEXT (not value) in Excel

answered Oct 2, 2012 at 20:58

9 votes

Extracting Data Between two Characters in Excel

answered Oct 23, 2012 at 16:43

8 votes

Accepted

Is it possible to rope pictures in Excel

answered Nov 2, 2012 at 16:03

5 votes

How to "unpivot" or "reverse pivot" in Excel?

answered Sep 21, 2013 at 5:47

5 votes

How to add up all values in column F that has the same value in column A?

answered Sep 24, 2012 at 23:42

3 votes

Excel: count number of unique/distinct row in range with condition

answered Sep 28, 2012 at 22:56

3 votes

Averaging values in Excel with < symbol

answered Oct 1, 2018 at 20:56

3 votes

Excel combining INDEX and MATCH

answered Mar 14, 2013 at 19:23

2 votes

Accepted

How to exclude ranges overlap from a range ? (Move cell contents macro)

answered Oct 4, 2018 at 21:14

2 votes

How can I remove 'blank' or ' ' data in my excel spreadsheet?

answered Oct 2, 2012 at 20:54

2 votes

Microsoft Excel maintain formatting when importing

answered Oct 4, 2012 at 16:00

2 votes

Accepted

How to group excel data by date and then pick a max reported value for each day?

answered Oct 3, 2012 at 16:38

2 votes

What is the best way to graph this in excel

answered Oct 4, 2012 at 23:33

2 votes

Attendance marking in Excel

answered Nov 28, 2012 at 17:46

2 votes

Accepted

Excel: Sort table on one sheet sum up on the next

answered Nov 2, 2012 at 18:27

2 votes

How to edit a formula that I already have to take into account another cell's data

answered Nov 2, 2012 at 15:58

1 vote

Automation for filling in sets of numbers in each row

answered Oct 22, 2012 at 16:01

1 vote

Accepted

Pull Data from Pivot Table to Grid on Different Worksheet

answered Oct 30, 2012 at 17:39

1 vote

Find the different two Excel sheets when having identical row

answered Oct 30, 2012 at 20:36

1 vote

Create shortcut key to insert new row using Excel 2010

answered Oct 31, 2012 at 22:11

1 vote

Accepted

Locking cell range in Excel

answered Oct 24, 2012 at 16:07

1 vote

Accepted

2D Lookup without unique column values

answered Oct 25, 2012 at 19:27

1 vote

Named Ranges, Cell References and Validation

answered Nov 7, 2012 at 18:34

1 vote

Accepted

Excel Condition

answered Nov 13, 2012 at 21:59

1 vote

Automatically copy / clone column to other columns in Excel 2007

answered Nov 2, 2012 at 16:09

1 vote

Trying to put up a one liner in Excel

answered Nov 28, 2012 at 22:34

1 vote

How to stop Excel 97 from prompting that file was created with a later version

answered Oct 5, 2012 at 1:25

1 vote

How to filter source sheet in Excel pivot table drill down?

answered Oct 5, 2012 at 19:00

1 vote

Collapsing rows of duplicate dates in a column leaving one row with a subtotal?

answered Oct 6, 2012 at 22:20

Stack Exchange Network

48 Answers

How to split a string based on ":" in MS-Excel?

Formatting a column based on another columns cell TEXT (not value) in Excel

Extracting Data Between two Characters in Excel

Is it possible to rope pictures in Excel

How to "unpivot" or "reverse pivot" in Excel?

How to add up all values in column F that has the same value in column A?

Excel: count number of unique/distinct row in range with condition

Averaging values in Excel with < symbol

Excel combining INDEX and MATCH

How to exclude ranges overlap from a range ? (Move cell contents macro)

How can I remove 'blank' or ' ' data in my excel spreadsheet?

Microsoft Excel maintain formatting when importing

How to group excel data by date and then pick a max reported value for each day?

What is the best way to graph this in excel

Attendance marking in Excel

Excel: Sort table on one sheet sum up on the next

How to edit a formula that I already have to take into account another cell's data

Automation for filling in sets of numbers in each row

Pull Data from Pivot Table to Grid on Different Worksheet

Find the different two Excel sheets when having identical row

Create shortcut key to insert new row using Excel 2010

Locking cell range in Excel

2D Lookup without unique column values

Named Ranges, Cell References and Validation

Excel Condition

Automatically copy / clone column to other columns in Excel 2007

Trying to put up a one liner in Excel

How to stop Excel 97 from prompting that file was created with a later version

How to filter source sheet in Excel pivot table drill down?

Collapsing rows of duplicate dates in a column leaving one row with a subtotal?