Skip to main content
Super User
Darren Bartrup-Cook's user avatar
Darren Bartrup-Cook's user avatar
Darren Bartrup-Cook's user avatar
Darren Bartrup-Cook
  • Member for 10 years, 11 months
  • Last seen this week
Profile Activity

Stats

560
reputation
104k
reached
44
answers
14
questions
Communities
View all

About

Twenty-five years of Excel, Access and VBA experience.

Helpful Articles:
Writing the perfect question
Answering technical questions helpfully

Formatting:
Auto Indent
Markdown Table Generator

Sites:
MS Docs
Peltier Tech - Excel Charts
Chip Pearson

Useful answers:
FILTERXML

Badges

View all badges
This user doesn’t have any gold badges yet.
4
silver badges
18
bronze badges

Top tags

View all tags
18
Score
50
Posts
86
Posts %
6
Score
23
Posts
40
Posts %
4
Score
5
Posts
9
Posts %
3
Score
3
Posts
5
Posts %
2
Score
3
Posts
5
Posts %
1
Score
3
Posts
5
Posts %

Top posts

View all questions and answers
4
Formula to create a cartesian product from two data sets in a spilled range
Aug 27, 2021
2
Dynamic named range referencing table changing to static ref in chart
Oct 8, 2019
2
Translate Excel formula for power query (M language)
Mar 3, 2025
2
Add a blank with FilterXML
Sep 1, 2021
2
How do I select 2 distinct columns using structured references in excel?
Jul 4, 2023
2
Excel - how to convert table headers in rows to columns?
Apr 20, 2023
2
Excel find the maximum of visible cells
Jun 16, 2017
2
Do not refresh date in IF Statement using TODAY()
Sep 19, 2018
2
Creating a floorplan in Excel using an X-Y scatter
Mar 11, 2022
1
How do I parametrise the file location when loading data in an Excel power query?
Dec 15, 2025

Top network posts

View all network posts
21
Excel How to convert datetime into only date - m/d/YYYY format
14
How to open an excel without running the Workbooks.Open macro in it
10
How to deal with "Microsoft Excel is waiting for another application to complete an OLE action"
10
Excel VBA - Convert Date String to Date
9
count number of cells with a specific data type in MS Excel