User Darren Bartrup-Cook

2 votes

Accepted

Creating a floorplan in Excel using an X-Y scatter

answered Mar 11, 2022 at 14:21

2 votes

Accepted

Excel find the maximum of visible cells

answered Jun 16, 2017 at 11:04

2 votes

Do not refresh date in IF Statement using TODAY()

answered Sep 19, 2018 at 9:18

2 votes

Accepted

Excel - how to convert table headers in rows to columns?

answered Apr 20, 2023 at 13:38

2 votes

How do I select 2 distinct columns using structured references in excel?

answered Jul 4, 2023 at 12:23

1 vote

Accepted

How to include a variable within M language PowerQuery

answered Oct 16, 2023 at 13:29

1 vote

IF Function has stopped working

answered Jan 27, 2023 at 11:30

1 vote

Accepted

How do I use a cell reference as a column in a table reference?

answered Dec 5, 2022 at 14:13

0 votes

Use Cell references within SUM function (Excel)

answered Dec 7, 2022 at 15:35

0 votes

Keep VBA code working if I run it from a button in another sheet, or replace the code with formula

answered Dec 19, 2022 at 10:02

0 votes

Summarize cost for each project while referering to values in list

answered Dec 22, 2022 at 14:29

0 votes

How to get Excel to use the relevant column?

answered Jul 27, 2021 at 9:40

0 votes

Make excel do multiplication across horizontal cells with stacked numbers within cells

answered Aug 20, 2021 at 8:06

0 votes

How to sum last N rows in a column?

answered Dec 6, 2021 at 10:58

0 votes

Using 'Sheet name' in Excel VBA instead of 'Tab name'

answered Mar 25, 2022 at 14:26

0 votes

VBA Code Help "goto & Select" Alternative

answered Mar 29, 2022 at 15:05

0 votes

Ambiguous name detected: Worksheet_Change when adding 2 change events

answered Jun 17, 2022 at 10:57

0 votes

It is possible to track back how many cells are merged with TEXTJOIN [Excel]?

answered Jun 21, 2022 at 9:58

0 votes

Accepted

Count number of strike-through lines

answered Aug 8, 2022 at 10:41

0 votes

Accepted

Highlight MAX and MIN values in Power BI table visual using DAX

answered Aug 15, 2022 at 13:25

0 votes

Excel VBA: Flipping cells horizontally along with their formatting

answered Oct 13, 2022 at 13:43

0 votes

Excel: How to reference every cell in array in spreadsheet based on upper left most cell primary key?

answered Oct 31, 2022 at 13:50

0 votes

Simplifying a summation with VLOOKUP

answered Nov 8, 2022 at 16:02

0 votes

Making the VBA code affect a specific range of pages

answered Nov 14, 2022 at 14:56

0 votes

Calculate % of total during drill-down

answered Jan 31, 2023 at 8:48

0 votes

Excel Finding a Range

answered Feb 3, 2023 at 13:27

0 votes

Is there a way to drag a SUMIF/(S) formula down vertically but pull information horizontally, and vice versa?

answered Feb 16, 2023 at 10:05

0 votes

Comparing cells in excel with the same text but different order

answered Apr 20, 2023 at 8:46

0 votes

If function not working when I add condition about cells with N/A

answered Apr 28, 2023 at 8:33

0 votes

Excel query issues with dates as column headers

answered Jun 2, 2023 at 7:54

Stack Exchange Network

37 Answers

Creating a floorplan in Excel using an X-Y scatter

Excel find the maximum of visible cells

Do not refresh date in IF Statement using TODAY()

Excel - how to convert table headers in rows to columns?

How do I select 2 distinct columns using structured references in excel?

How to include a variable within M language PowerQuery

IF Function has stopped working

How do I use a cell reference as a column in a table reference?

Use Cell references within SUM function (Excel)

Keep VBA code working if I run it from a button in another sheet, or replace the code with formula

Summarize cost for each project while referering to values in list

How to get Excel to use the relevant column?

Make excel do multiplication across horizontal cells with stacked numbers within cells

How to sum last N rows in a column?

Using 'Sheet name' in Excel VBA instead of 'Tab name'

VBA Code Help "goto & Select" Alternative

Ambiguous name detected: Worksheet_Change when adding 2 change events

It is possible to track back how many cells are merged with TEXTJOIN [Excel]?

Count number of strike-through lines

Highlight MAX and MIN values in Power BI table visual using DAX

Excel VBA: Flipping cells horizontally along with their formatting

Excel: How to reference every cell in array in spreadsheet based on upper left most cell primary key?

Simplifying a summation with VLOOKUP

Making the VBA code affect a specific range of pages

Calculate % of total during drill-down

Excel Finding a Range

Is there a way to drag a SUMIF/(S) formula down vertically but pull information horizontally, and vice versa?

Comparing cells in excel with the same text but different order

If function not working when I add condition about cells with N/A

Excel query issues with dates as column headers