User ExcelEverything

5 votes

Accepted

Excel formula/solution for grading multiple choice questions with multiple answers

answered Apr 20, 2021 at 19:53

4 votes

Accepted

Excel Formula for optimizing a route where each row represents a different "station" that can do different things

answered Nov 22, 2020 at 20:31

4 votes

conditional formatting based on the cell above

answered May 15, 2021 at 16:54

4 votes

Accepted

Can i get excel to retain the format of this JSON cell?

answered Mar 8, 2022 at 11:20

3 votes

Excel: How to convert a column letter to the corresponding column number without using COLUMN() and INDIRECT()?

answered Mar 21, 2022 at 20:19

3 votes

Accepted

Excel: Get range address from single input (looking for compact formula)

answered Jul 21, 2021 at 13:14

3 votes

Why would a spreadsheet cause Excel to stop responding every other minute? No macros, manual calculations

answered Nov 18, 2020 at 8:56

3 votes

Accepted

Macro to create Line graph for each row in my table?

answered Mar 29, 2021 at 20:34

2 votes

Accepted

Find unique IDs which entries do not have a certain value in Excel

answered Mar 23, 2022 at 9:19

2 votes

How to get a running sum - floating above the cell

answered Apr 6, 2022 at 20:44

2 votes

.csv did not save all tabs

answered Apr 25, 2022 at 18:40

2 votes

Accepted

Finding the uses of a specific cell in Excel

answered Nov 14, 2022 at 8:32

2 votes

Accepted

How to concatenate multiple cells without typing each one and add a space after each value

answered Nov 11, 2022 at 14:45

2 votes

Accepted

In Excel can you write a function in a cell and stipulate that it should only be manually calculated

answered Mar 28, 2021 at 4:03

2 votes

Selecting the first row in excel where a column value equals a certain value

answered Mar 26, 2021 at 1:02

2 votes

Subtracting numbers in Excel - numbers in three columns, not all columns contain data, subtract latest data collected from earliest data collected

answered Mar 18, 2021 at 13:53

2 votes

Slow excel document verbose status

answered Apr 21, 2021 at 10:03

2 votes

Microsoft Excel - Copy entire row from different sheet based on multiple criteria

answered Apr 23, 2021 at 0:47

2 votes

Accepted

google sheet formula, if “yes”, copy to other sheet

answered Nov 19, 2020 at 15:15

2 votes

Accepted

Find duplicates within each subset of data

answered Nov 21, 2020 at 10:08

2 votes

group multiple IP ranges into respective subnets in Notepad++

answered Dec 8, 2020 at 7:33

2 votes

Formulas `A1:A` and `A1:Z` give invalid name error in Excel?

answered Dec 15, 2020 at 0:00

2 votes

Excel: Get range address from single input (looking for compact formula)

answered Jul 21, 2021 at 13:01

2 votes

Sum multiplications of horizontal ranges of cells, starting in different columns in Excel

answered May 27, 2021 at 22:32

2 votes

Accepted

255 characters limit in xlookup and choose function

answered Jan 25, 2022 at 10:47

2 votes

Accepted

Excel - Stacked Scatter Plot - digital signal timing

answered Mar 21, 2022 at 18:49

2 votes

Accepted

How to convert imported data into a workable format in Excel?

answered Mar 16, 2022 at 14:35

2 votes

Accepted

How can I export data without "Save As..."?

answered Mar 18, 2022 at 21:40

2 votes

Subtracting two apparently equal rounded numbers does not equal 0

answered Mar 2, 2022 at 11:01

1 vote

Accepted

Using excel to find missing daily logs for people

answered Nov 11, 2022 at 15:01

Stack Exchange Network

339 Answers

Excel formula/solution for grading multiple choice questions with multiple answers

Excel Formula for optimizing a route where each row represents a different "station" that can do different things

conditional formatting based on the cell above

Can i get excel to retain the format of this JSON cell?

Excel: How to convert a column letter to the corresponding column number without using COLUMN() and INDIRECT()?

Excel: Get range address from single input (looking for compact formula)

Why would a spreadsheet cause Excel to stop responding every other minute? No macros, manual calculations

Macro to create Line graph for each row in my table?

Find unique IDs which entries do not have a certain value in Excel

How to get a running sum - floating above the cell

.csv did not save all tabs

Finding the uses of a specific cell in Excel

How to concatenate multiple cells without typing each one and add a space after each value

In Excel can you write a function in a cell and stipulate that it should only be manually calculated

Selecting the first row in excel where a column value equals a certain value

Subtracting numbers in Excel - numbers in three columns, not all columns contain data, subtract latest data collected from earliest data collected

Slow excel document verbose status

Microsoft Excel - Copy entire row from different sheet based on multiple criteria

google sheet formula, if “yes”, copy to other sheet

Find duplicates within each subset of data

group multiple IP ranges into respective subnets in Notepad++

Formulas `A1:A` and `A1:Z` give invalid name error in Excel?

Excel: Get range address from single input (looking for compact formula)

Sum multiplications of horizontal ranges of cells, starting in different columns in Excel

255 characters limit in xlookup and choose function

Excel - Stacked Scatter Plot - digital signal timing

How to convert imported data into a workable format in Excel?

How can I export data without "Save As..."?

Subtracting two apparently equal rounded numbers does not equal 0

Using excel to find missing daily logs for people