288,901 questions
0
votes
1
answer
46
views
VBA/Regex replace characters with groups using pattern
I have cells with times in them. The format I want to replace is something like "7:30:00 AM", though of course the hours could be double digits. After the regex replacement, I would want the ...
Advice
0
votes
1
replies
63
views
Filtering Excel / Google Sheet data across multiple workbooks with different data ranges and naming conventions
I'm looking for some advice on what would be the best way for me to tackle a specific problem. I'm doing a study that involves filtering through a large set of data. The data includes road ...
Best practices
0
votes
0
replies
90
views
What are the best tools to use when developing Pricing Calculators for Small Businesses?
What are the best approaches you have seen developing pricing calculators for small businesses. For example, I was able to build a small one for a window installment business a couple of months ago ...
- 1
0
votes
0
answers
90
views
How to create a "View Switcher" in an Excel Dashboard without using VBA [closed]
I am building an Excel dashboard for a client that needs to display two distinct data areas - Sales and Services - on the same worksheet. Because the client needs this to be mobile-friendly (Excel for ...
1
vote
1
answer
94
views
Troubleshooting creating a Word document in an Excel vba Class module
For various reasons, I am currently refactoring some code to a more OOP approach. I am immediately having the following problem: When the Create method of the class module creates the new Word ...
- 125
0
votes
0
answers
64
views
Excel PivotTable via external connection to Power BI dataset not filtering out deselected values from field heading dropdown
I have a PivotTable connected to a Power BI dataset (via Power BI' Analyze in Excel feature). In this dataset there are several string-based category fields which we pull into reporting for filtering ...
Advice
2
votes
6
replies
142
views
Excel - multiple values for one record
I have a pivot of Case Numbers and Record Numbers (one to many). I need to display the Record Numbers as columns so that they appear as Record1, Record2 etc.
Each Case Number may have several Record ...
- 1
Advice
0
votes
1
replies
71
views
Excel checking a box based off two columns in a different tab
Trying to track completed courses. Already have a sheet to show the percentage completed for individuals.
I need another sheet that will show which specific ones are completed. This sheet has a ...
Best practices
1
vote
7
replies
111
views
Excel: ordering unique values in order of last entered
I have two columns, one with an exercise and one with the date it was completed, example pic.
What I would like to do is create a dropdown list that puts the most recent done at the bottom, basically ...
- 1
0
votes
1
answer
97
views
Prevent `Selection.Clear` to clear borders
In Excel VBA, how can I prevent Selection.Clear from clearing cell borders?
- 6,038
1
vote
2
answers
223
views
Lookup User Info() Macro to return multiple results
I'm working on a database that tracks CashApp names for a prison. I'm a little lost with Excel Macros, so I had to google an example to use however, the example I have only returns one value and a ...
1
vote
2
answers
129
views
Get Alt Text of image that's inside a cell
I have a list of images inside cells in a column. All of the images have Alt Text.
How do I get this Alt Text into another cell? I have seen plenty of VB snippets that will do this for images outside ...
- 145
1
vote
0
answers
131
views
I'm getting this error message in my VBA code
I am getting an error "DOB Error:" shown in my code's error handler, and I am unable to fix it.
Please help me; this code is mostly used to validate a date available on a web page, and if ...
- 11
Advice
1
vote
3
replies
129
views
What is the purpose of the boolean return value from Excel.Range.Replace()?
What is the purpose of the boolean return value from Excel.Range.Replace()? I find it always returns True whether the target value is found or not.
The documentation at https://learn.microsoft.com/en-...
- 3,698
3
votes
7
answers
353
views
How to use MAP() , BYCOL() or BYROW() to return multiple arrays?
I have a matrix of interactions between items. Each row and column correspond to one item interacting with another (i.e. "col 1" and "row 4" represents the interaction of "...
- 33
Best practices
0
votes
6
replies
88
views
How to use the filter in the Calculate function?
I would like to calculate the rate (the division) of water consumption and minerals in a mineral procesing plant using a table that contains Date, Pant, classification, specific classification, and ...
1
vote
1
answer
70
views
Excel Power Query: Renaming Queries Already Associated with Pivot Tables
I created a massive workbook for a client and parameterized the geography and vintage of my queries in the Power Query Editor so that I can easily make a similar file with different parameters. The ...
Advice
0
votes
4
replies
82
views
How do I use INDEX and MATCH instead of VLOOKUP in Excel?
I’m trying to learn how to use INDEX and MATCH instead of VLOOKUP in Excel.
I have a table where:
Column A = Employee IDs
Column B = Names
Column C = Salaries
I want to look up a salary based on an ...
0
votes
0
answers
155
views
VBA incorrectly saying a cell is blank
I am writing a code to copy info from a single sheet into a new workbook with separate tabs for each month based on the date in a column titled Date on the source sheet. The code continues to tell me ...
- 11
Advice
0
votes
1
replies
66
views
how to use the last file in?
Code of how the web application picks the file:
#Load Data
this_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd()
wb_file_path = this_dir / 'vital_log_2026-03-13_21-20-51.csv'
data ...
0
votes
1
answer
86
views
Nested IF in Excel using Today() [closed]
I have a spreadsheet that tracks daily sales.
Column A is the date, and Column B is the buyer. I have this IF statement:
=IF(B24\<\>""TODAY(),"")
My goal is to enter the ...
- 13
1
vote
1
answer
119
views
How can I split comma-separated values in a cell and then count occurrences in Excel? [duplicate]
I am learning Excel and trying to work with data that contains multiple values in a single cell separated by commas.
For example, I have a cell like this:
A1: apple,banana,apple,orange
My goal is to ...
-4
votes
1
answer
163
views
VBA Excel update
My employer recently update our Excel. Now my VBA code is not working correctly anymore.
I open a .csv file from another program, so it opens in another instance and not being seen by the opened macro ...
- 1
Advice
0
votes
5
replies
101
views
Learning SQL through trail by fire
I have gotten into SQL in the past few months. Learning through Coursera. In the course it mentioned this website to go to and ask questions, instead of just using google or the source material.
I ...
Best practices
0
votes
2
replies
89
views
Autofill multiple entries for Combobox
I have a user form that uses a combo box to record the employee associated with a given task. I have a section of code that extracts employee entries from other tasks, and adds them to the combobox ...
- 1
0
votes
1
answer
86
views
Excel VBA macro seems to be "async-ing" loop
I have a VBA macro, attached to a specific sheet, with the following structure (all variables appropriately Dim'ed at the start of the subroutine). The lines following ' Debugging are lines I added ...
- 311
-2
votes
0
answers
68
views
Power Automate not recognizing script parameters properly
I try to write a Power Automate flow which copies data from one Excel sheet to another
In my destination Workbook, I have the following script
function main(workbook: ExcelScript.Workbook, aInput: ...
- 15
Advice
0
votes
3
replies
88
views
Is there a free .NET MAUI‑compatible library for creating XLS (Excel 97–2003) and XLSX files on all platforms?
I am developing a .NET MAUI application and need to generate XLS (Excel 97–2003 format) files at runtime.
I specifically need styling support (fonts, colors, borders, etc.), so CSV is not an option ...
- 339
3
votes
2
answers
109
views
Weighted Score in Excel
How do I build a weighted scoring model in Excel that calculates a final score from multiple columns, where some metrics are higher-is-better and others are lower-is-better?
Starting in Row 4
D - $ ...
- 31
Best practices
1
vote
6
replies
119
views
How can a beginner use Power Query in Excel effectively for data cleaning
I am a beginner learning Power Query in Microsoft Excel as part of my data analysis journey. I have started using it for basic tasks like removing duplicates, filtering rows, and changing data types.
...
-3
votes
3
answers
76
views
How to get a less than and greater than range in an IFS Statement using AND
I am trying to use an AND statement nested into a IFS statement to run a range check. I do not have any errors in my formula. However, the result of the output is not changing. It is only outputting ...
- 3,368
0
votes
2
answers
206
views
Create new row in Excel whenever you create a new Sheet in the Workbook
Okay so I'm trying to understand what is and isn't possible with excel. I know I may have to do some fun macro coding to make it work. My goal is to create a workbook with a sheet of all products (...
0
votes
1
answer
97
views
Excel VBA Outlook Error "Linked image cannot be displayed..."
I have code to compose and send, or display, an email with an image in it, but the image won't display. I have read a dozen plus blogs on this error and how to use CID in the HTML body, and it seems ...
Advice
1
vote
5
replies
121
views
Choose cell, by different values
I have following Data:
A
B
C
Result
1
10
1
7
9
9
3
2
1
6
7
1
5
1
1
and following Result Sheet:
Can I "connect" the Result column of the Date with the Result sheet without an endless if-when ...
Tooling
0
votes
2
replies
119
views
How can I get a Excel sheet in Word but the content is variable
I want to create a Word-Formular for a Quality Report which contains different dimensions of Steel parts. The Word-Doc should get its information via Excel an create a desired state and actual state ...
Advice
2
votes
2
replies
107
views
Starting out on GitHub to create a portfolio
Currently getting into SQL data cleaning and querying and looking forward to building dashboards and data visualization using BI tools.
As a beginner, how do I start with GitHub to create a portfolio ...
Best practices
0
votes
1
replies
115
views
How to use structured references in Excel tables for better formula accuracy?
When instructed to append a total to the table in Excel, what action does Copilot take?
It adds a sum to the top of the last column.
It adds a sum to the bottom of the first column.
It adds a sum ...
Advice
0
votes
4
replies
58
views
"Select related Tables" Power Pivot
I don’t understand how the option “Select related tables” works in the Power Pivot Import Wizard (when the source is an Excel file).
Here a detailed explanation of what I’m doing:
1. I open the Power ...
0
votes
1
answer
109
views
Unable to read sqlite table from "Python in Excel" [closed]
I'm trying to display the contents of a (local) sqlite table in Excel. I want to use "Python in Excel" for various reasons. This is the code I have written in cell A1 using the PY() formula:
...
- 27
Advice
0
votes
2
replies
93
views
PowerQuery - Reformat shortened date string to full date
I have a table of strings representing date buckets for part quantities
Attribute
ODUE
M2601
M2602
M2603
...
M2912
FUTURE
Looking for a function to provide this result
2025-DEC-31
2026-JAN-01
2026-FEB-...
Advice
0
votes
2
replies
93
views
Resizing two shapes simultaneously over time
Some time ago I've looked for a way to fade shapes in and out over time as a sort of animation. Now I successfully retooled this to resize and object over time.
Basically, I've made a quiz-style Excel ...
- 1
-1
votes
0
answers
179
views
Excel VBA 7.1 editor won't let me finish a line of code. Constant popups for syntax error, etc
I'm doing a project using Excel. It was working fine until recently. I can't edit any of the code. Every time I type something, I get a popup for syntax error or something else WHILE I'M STILL ON ...
2
votes
1
answer
90
views
How to transfer data from separate sheet to non-consecutive blank cells
Very new to VBA and I am trying to set up a way to format data in a very specific way.
Managed to get most of it working except for the last step.
I'm trying to get the system names in column G from ...
1
vote
1
answer
80
views
Filtering rows across multiple columns
I have a spreadsheet for trading cards. I am trying to filter out all the cards that have 0. The spreadsheet is set up to have a column for regular, holo, reverse holo, and promo holo. It is possible ...
Advice
0
votes
8
replies
118
views
Multi-Sensor Data Fusion for Pile Strain Analysis
I am working with two different measurement systems used to monitor strain/deformation in a bored pile. I need to consolidate these into a single representative curve using Excel/VBA.
System A (...
- 1
0
votes
0
answers
80
views
Chart Series Line Dash Style Displays Incorrectly When Set Programmatically via COM/VBA
I am experiencing a bug in Excel when programmatically formatting chart series via VBA/COM automation that causes line dash styles to display incorrectly with elongated patterns.
Steps to Reproduce:
...
- 2,383
Advice
1
vote
3
replies
115
views
Excel - paste special HTML option
hope you are doing well.
I'm trying to code in Excel VBA, and I need to call the HTML option from the menu in the image:
excel paste special options
This menu only shows up after I copy manually a ...
- 1
0
votes
0
answers
62
views
Why my Value Filters filtered out everything and included nothing?
I have a pivot table that looks like this. The numbers in this table are the number of grades.
The % in this table are the number of grades, but Show values as "% of Row Total"
I'm trying ...
- 135
0
votes
1
answer
94
views
Get the corresponding name of the max of a group of summed values
I have a table in Power BI in the following format:
I am currently learning how to use the software (and DAX) as I go and I have been trying to figure out if it is possible to get the course that has ...
- 303
0
votes
0
answers
106
views
Problem in editing Excel XLSX files programatically, with DocumentFormat.OpenXml
My ASP.NET Core web app outputs Excel files (.xlsx) when requested. There are two types of Excel file reports (two endpoints).
I start with a template Excel file (.xlsx) that is not empty and may have ...
- 170