All Questions
282
questions
0
votes
0
answers
20
views
How to find group pair duplicates in Excel (creating graph nodes)
I have a class of 40 students performing 5 group activities. Each group having 3-4 students per activity. My goal using Excel is to find and minimize the number of instances where students have the ...
-1
votes
0
answers
35
views
Google Map Result Scroll (VBA Selenium) [closed]
How do I scroll through Google Maps results to get more items in my list? I’m not sure whether I should use the class attribute or another method. Please help me with automatically scrolling until all ...
2
votes
2
answers
80
views
Range Property Not Returning Correct Value for Relative Named Range in VBA Excel 365
I've named a Range as ID and set its address as =Materiais!$B3. it is fixed for column but for the row, it will depend on the ActivateCell current position.
when I click on the G8 cell, for instance, ...
-1
votes
2
answers
52
views
How to Extracting Only Date and Amount from the Reference
I have a Column with reference information with date values and the amount; I need to extract only the Date and the Amount, A single reference Pattern Like below:
SIInv:HI-24-SIN-SOH-00948 Date: 12 ...
1
vote
2
answers
80
views
Remove 0's from a matrix
Hi I have the following data
December
January
February
March
April
0
0
0
0
116282
0
0
116282
116282
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
...
0
votes
1
answer
49
views
In Excel, I have to do a calculation in each row of a document, then sum the result for all rows. I need to do this in one cell though. How?
I have a file which has multiple rows. In each row, I need to do a calculation. For example, in cell D1, I write:
=(B1-A1)*C1
I then need to sum all the rows of that result, say:
=sum(D1:D30)
Is ...
1
vote
3
answers
104
views
Excel, generate a list of names depending on row and column values of another sheet
I have a similar excel sheet which has dates in Column A and Names in the Row 1. Each name has a value per day.
Date
Alice
Bob
Charl
Dan
01/01/24
E
L
E
E
02/01/24
E
L
L
A
I need another sheet that ...
2
votes
2
answers
102
views
Sum amounts based on criteria for unique combinations of fields in an Excel Table
I have a Table in Excel 365 called MyLongData that contains multiple rows. I would like to come up with a formula that tracks claims, where a claim is defined as a unique combination of fields [...
2
votes
3
answers
118
views
Nested Xlookup [if not found] not functioning as expected, returning results that don't exist with exact match
I have a multi-column spill with data where some of the information is reflected incorrectly. We created a table to search if it's one of the incorrect records, I would like to search if it exists in ...
2
votes
3
answers
182
views
EDIT : Excel( or Python) Formula to Recursively List All Ingredients and Sub-Ingredients of a Recipe
EDIT: The problem has already been resolved elegantly, one could say, using recursive Lambda. However, since Python has become available in Excel, I have begun learning Python and taking courses. Yet, ...
2
votes
2
answers
47
views
Comparing two dynamic ranges
I have the following summation table
Range 1 (expected output)
Responsibility Center
Authorized HC
# of Vacancies
Pending Approvals
County 1
26
1
2
County 2
7
21
1
County 3
53
35
1
County 4
53
35
...
0
votes
1
answer
117
views
Xlookup in excel doesnt function in Makearray?
There appears to be an error in excel formula when combining Xlookup with Make array formula:
e.g.
This is a simplified example. I have used y values of constant increments to make the formula ...
1
vote
2
answers
96
views
Filter out and delete multiple criteria
Posting in the hope I'm not flame grilled. Bluntly, I'm a novice and though I'm trying my best, Rome wasn't built in a day and I'm stuck.
I've had some help elsewhere and Kudos to the person, they are ...
0
votes
0
answers
53
views
Count distinct values in Excel in one column with criteria from other column
I want to count the total number of distinct properties (Property column) in the HZ locations (just the ones that have the text "hz" in any part of their name in the "UWI" column) ...
0
votes
1
answer
40
views
How to create a data entry box in excel that would navigate me to a specific sheet in my excel workbook?
I run a pool league and every player has their own separate sheet where their performance is entered.
Instead of using excels menu option (a bit bulky, scrolling through 100 players takes time) I ...