76 questions from the last 30 days
0
votes
0
answers
29
views
Dynamic Look Up with Multiple Criteria: <>, =, >, >=, <, <= as Sign Inputs and an Input Value Cell
I have a workbook with 2 tabs: an Override tab and a Calculation Detail tab. I am trying to create a formula that returns "Y" or "N" in the parameter_# field of the Calculation ...
- 89
0
votes
0
answers
25
views
Excel dynamic arrays not able to be multiplied together
I have two arrays that won't multiply together, I just get a single zero. I would expect the result to be an array.
Is there some behaviour of dynamic arrays that I don't understand here? The arrays ...
- 35
-4
votes
0
answers
32
views
Record editing Excel VBA [closed]
I have an Excel file and I need to record what I have been editing in a sheet named Record, like for example I edit some data in cells, so it records the timing of editing and in which sheet.
Is there ...
- 15
0
votes
1
answer
44
views
BeautifulSoup - Extracting content blocks after specific subheadings within a larger section, ignoring document introduction
I am scraping the Dead by Daylight Fandom wiki (specifically TOME pages, e.g., https://deadbydaylight.fandom.com/wiki/Tome_1_-_Awakening) to extract memory logs.
The goal is to extract the Memory ...
Advice
0
votes
20
replies
270
views
Date function vba how to
I have this code that works great except for when the end of the week comes up I have to change 8 to 15 or vise versa in order to get to the correct workbook. Is there another way? This code is to ...
- 9
2
votes
3
answers
128
views
How to add cells from different pages to a cell
I have a spreadsheet with 31 pages that keeps track of my bowling teams scores, points won, etc.
Each week (30 weeks total) is a separate page. I have a summary page in that spreadsheet that keeps ...
- 23
0
votes
0
answers
139
views
As part of a function, how could I create a variable number of sums one inside another based on a parameter?
I'm currently struggling on an assignment (probability class) which require creating a function (VBA excel) that contains a variable number of sums one inside the other based on a parameter. I'm not ...
- 1
0
votes
2
answers
51
views
Incorrect currency being displayed using Stock Data Type
The inbuilt stock data type in Excel is not correctly displaying the price of the stock. The issue is with stocks on the LSE as they are reported in pence and not dollars, Excel is reporting it as ...
- 1
1
vote
2
answers
106
views
Searching for a range of dates in Excel Using VBA
I have a problem in making a search for a range of dates with VBA. Using the start date as the default search in the date range and when find the same date start to count (x) in the range between the ...
- 15
1
vote
1
answer
60
views
Excel Conditional formatting tie breaking
I have a spreadsheet of prices from a selection of suppliers, with one supplier per column.
// Conditional Format code
=D2=MIN($D2:$K2)
I have used conditional formatting to highlight the cheapest ...
- 11
0
votes
3
answers
94
views
Nested Or statement IN Excel
I am looking for help with excel syntax. I am looking for if cell B4 = "Jan", "Feb" or "March" it returns Q1, if B4 = "April" ,"May" or "June&...
Advice
1
vote
3
replies
130
views
Best way to clean awkward Excel column headers in python/pandas?
I've got four years of daily school attendance data spread across 40+ Excel files (one for each month) and the sheets are set up in a truly annoying fashion, with each date in one merged cell in the ...
0
votes
1
answer
101
views
insert row with total where criteria count ends
i have excel sheet with 5 columns. i used following code for sorting. it works fine
lrow As Long
lrow = Application.WorksheetFunction.CountA(Sheet2.Range("A:A"))
Sheet2.Range("A3:E&...
- 11
2
votes
2
answers
69
views
How can I merge 2 arrays into a 3rd array when all 3 are derived using the FILTER function?
I'm building a workbook designed to isolate three different data sets from a single data source using Excel's FILTER function.
What I'm trying to do is combine filters 1 and 2, then subtract their ...
- 21
4
votes
3
answers
81
views
Excel array formula using if() with two rows from spilled array source
I have set of data that I am pulling from another sheet with filter() function, and then I'd like to use array formula if possible (with # operator) to have formula spill dynamically for as much rows ...
- 215