User pnuts

97 votes

In Excel, how do I check if a cell is in a list of values (a range of cells)

answered May 29, 2013 at 20:47

43 votes

Accepted

Do ext4 filesystems need to be defragmented?

answered Jan 15, 2013 at 21:35

18 votes

Accepted

Transpose column to row

answered May 21, 2013 at 18:48

16 votes

Accepted

How to remove ** from my cells

answered Nov 28, 2013 at 15:56

9 votes

Two Excel Tables

answered Jan 11, 2013 at 18:21

9 votes

How to format a Microsoft Excel 2007 cell in hexadecimal?

answered Sep 26, 2012 at 17:20

7 votes

How to repair a corrupted Excel file

answered Jun 4, 2013 at 14:38

7 votes

Accepted

How can I sort a list of numbers, by its last 3 digits in Excel

answered Apr 10, 2013 at 9:46

6 votes

Plotting multiple series in a line graph in excel with different time values?

answered Jun 11, 2013 at 23:54

5 votes

How to position a table on Top of the text in MS Word

answered May 22, 2013 at 17:46

5 votes

Accepted

Macro may not be enabled in this workbook

answered Jan 15, 2013 at 8:35

4 votes

Weird Directory sort order

answered Jan 15, 2013 at 17:20

4 votes

Accepted

How does Internet link bonding work?

answered Jan 13, 2013 at 4:06

4 votes

Accepted

How do I expand columns of items in Excel so that each item is on its own line?

answered Jul 12, 2012 at 2:47

4 votes

How do I export only visible cells from Excel to CSV?

answered Sep 18, 2012 at 12:51

4 votes

Accepted

How to use countif, sumif across two sheets where the logical test is an equivalency?

answered Sep 24, 2012 at 15:40

4 votes

Accepted

Excel 2007: The empty look of a pivot table

answered Oct 11, 2012 at 11:41

4 votes

Excel sum function that returns zero, if any value in the sum range contains zero

answered Nov 28, 2012 at 10:22

4 votes

Accepted

How to break a list of numbers into parallel blocks

answered Jun 6, 2013 at 17:55

4 votes

How to change cell format from [ss] to number without changing values

answered Jan 30, 2014 at 1:19

4 votes

Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a Column

answered May 7, 2013 at 17:03

3 votes

Formula to search array and return values

answered Apr 29, 2013 at 11:29

3 votes

Accepted

Using ISBLANK with SUMIF formula

answered Apr 18, 2013 at 12:26

3 votes

How can I turn a Calculated Column back into a data column in an Excel Table?

answered Mar 20, 2013 at 16:52

3 votes

How to total an Excel Formula

answered Jun 6, 2013 at 17:33

3 votes

Accepted

Is it possible to copy & paste a pivot table in a spreadsheet?

answered May 23, 2013 at 12:37

3 votes

Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st

answered May 30, 2013 at 15:12

3 votes

Accepted

How remove all characters after pattern in LibreOffice Calc

answered May 23, 2013 at 22:21

3 votes

Select each nth row in Excel

answered Nov 8, 2012 at 12:23

3 votes

Excel - determine average using 1/2 value for flagged cells

answered Sep 24, 2012 at 16:58

Stack Exchange Network

319 Answers

In Excel, how do I check if a cell is in a list of values (a range of cells)

Do ext4 filesystems need to be defragmented?

Transpose column to row

How to remove ** from my cells

Two Excel Tables

How to format a Microsoft Excel 2007 cell in hexadecimal?

How to repair a corrupted Excel file

How can I sort a list of numbers, by its last 3 digits in Excel

Plotting multiple series in a line graph in excel with different time values?

How to position a table on Top of the text in MS Word

Macro may not be enabled in this workbook

Weird Directory sort order

How does Internet link bonding work?

How do I expand columns of items in Excel so that each item is on its own line?

How do I export only visible cells from Excel to CSV?

How to use countif, sumif across two sheets where the logical test is an equivalency?

Excel 2007: The empty look of a pivot table

Excel sum function that returns zero, if any value in the sum range contains zero

How to break a list of numbers into parallel blocks

How to change cell format from [ss] to number without changing values

Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a Column

Formula to search array and return values

Using ISBLANK with SUMIF formula

How can I turn a Calculated Column back into a data column in an Excel Table?

How to total an Excel Formula

Is it possible to copy & paste a pivot table in a spreadsheet?

Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st

How remove all characters after pattern in LibreOffice Calc

Select each nth row in Excel

Excel - determine average using 1/2 value for flagged cells