pnuts's user avatar
pnuts's user avatar
pnuts's user avatar
pnuts
  • Member for 10 years, 6 months
  • Last seen more than 2 years ago
97 votes

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

43 votes
Accepted

Do ext4 filesystems need to be defragmented?

18 votes
Accepted

Transpose column to row

16 votes
Accepted

How to remove ** from my cells

9 votes

Two Excel Tables

9 votes

How to format a Microsoft Excel 2007 cell in hexadecimal?

7 votes

How to repair a corrupted Excel file

7 votes
Accepted

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

6 votes

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

5 votes

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

5 votes
Accepted

Macro may not be enabled in this workbook

4 votes

Weird Directory sort order

4 votes
Accepted

How does Internet link bonding work?

4 votes
Accepted

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

4 votes

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

4 votes
Accepted

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

4 votes
Accepted

Excel 2007: The empty look of a pivot table

4 votes

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

4 votes
Accepted

How to break a list of numbers into parallel blocks

4 votes

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

4 votes

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

3 votes

Formula to search array and return values

3 votes
Accepted

Using ISBLANK with SUMIF formula

3 votes

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

3 votes

How to total an Excel Formula

3 votes
Accepted

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

3 votes

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

3 votes
Accepted

How remove all characters after pattern in LibreOffice Calc

3 votes

Select each nth row in Excel

3 votes

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

1
2 3 4 5
11