All Questions
34
questions with no upvoted or accepted answers
2
votes
1
answer
3k
views
Find position of first uppercase character in excel string
I need to find the position of the first uppercase character in an Excel string. There are lots of resources on the web that have the same (or effectively the same) solution for this:
=MIN(IF(ISERROR(...
1
vote
0
answers
87
views
Sum of array in one cell produces different result from sum of the array elements
I want to do a simple calculation (say, addition) on a set of values on the basis of some keys, as in:
Col A Col B Col C Col D Col E
Row 1 **Key** **...
1
vote
2
answers
11k
views
Excel INDEX MATCH looking between two dates of my choosing
I'm using Excel to log a list of items (name of items in column D) and then how long that item took to produce in column G.
I'm doing an INDEX MATCH to search for the worst performing product of the ...
1
vote
0
answers
30
views
Using an array to output results from a lookup criteria
I've tried searching the site, so sorry if this is a repeat. I'm not sure exactly how to phrase what I'm trying to do in excel.
Essentially what I have is a data sheet and a summary sheet. On the ...
1
vote
0
answers
74
views
MAX Result of multpiple results from INDEX and MATCH
I am working with 3 columns, fname, lname, & date. Where there will be multiple duplicates of fname and lname. I am trying to write an INDEX & MATCH that will display the MAX result or the ...
1
vote
0
answers
111
views
Excel : How to write everything I want on a single array formula
On Excel, I have a table with many numeric results on B column obtained by a array formula.
For example:
+---+------------+-------------+
| | A | B |
+---+------------+----------...
1
vote
0
answers
90
views
Excel: Conditional formatting, simplifying retrieving data from a range of rows
I am trying to create a schedule for a limited number of trainings (around 50) that are distributed between a limited number of venues (around 15), and I am looking for a smarter approach than the one ...
1
vote
0
answers
2k
views
Multi-cell array formula for array of unknown length
I have a range containing data on one sheet and want to slice out and manipulate various columns using array formulae in another sheet.
So as an example, I might want to reproduce one column using ...
0
votes
0
answers
52
views
Identifying a Specific Table Hierarchy... Don't Know Where to Start
I am trying to identify/mark records where an entry exists in a specific column. While that may be pretty straightforward using a loop, I must also mark those records representing the "Parent&...
0
votes
0
answers
96
views
Referencing and evaluating another cell's array formula to create master array using VSTACK, in Excel without VBA/Macros
I'm trying to accomplish this task in Excel without VBA, Macros, or Power Query.
Here is a workbook with example sheets of data, an intermediate sheet, and a sheet showing the desired outcome: https://...
0
votes
1
answer
117
views
look for empty cell between non empty cells in one row and then put 0
enter image description here enter image description here
A B C
abc 30 40
def 4646
ghi 45 3234
So, I want to write a macro code where it takes all three columns into consideration at once....
0
votes
1
answer
2k
views
Excel use formula to produce a conditional comma-separated list
I have a dataset in which the right 5 columns indicate with a Y/N if each row applies to that option of 5 potential options:
I am looking to add one final column that uses a formula to check for each ...
0
votes
2
answers
861
views
Excel nested dynamic array formula, filtering distinct differences only
I'm working with a big dataset with many types of products to be uploaded to Shopify
In order for the correct dropdown(s) to be displayed, I have to let Shopify know what the "children" (...
0
votes
2
answers
691
views
Excel VBA - Dynamic Array not Working
I am trying to make an array that stores all of the values in Column A from "Workbook B" so I can then reference and see if a cell's value is in that array in Column A from "Workbook A&...
0
votes
1
answer
519
views
Return column headers as array (no blank rows) if column sum is not zero
I have a table with columns of components needed to create various products. This table is populated automatically as output data from another table.
For this example, we'll use this one:
S Widgets
M ...