33,114 questions
1
vote
1
answer
32
views
How to use a filter expression in PIconnect summary in python
I am pulling data from PI historian and plotting graphs to check environmental and quality performance. This used to be done in excel, but I am using python to make the job more automated and easier. ...
0
votes
3
answers
121
views
Excel - find the value in another column but filter on different columns [closed]
This one is complicated! Here's a table. Ultimately, what I need is a formula that will count how many rows have:
State is end
EndTier is a
Tier is NOT a
The problem - is there a formulaic way to ...
- 151
-2
votes
1
answer
106
views
How do I use cross-column references in a block of Excel spill formula rows?
I am making a dynamic spreadsheet for calculating steam consumption of turbines, where the user enters key inputs (inlet temperature, inlet pressure, outlet pressure, efficiency) at the top of each ...
- 319
-2
votes
4
answers
115
views
Excel Formula Sumif going through 3rd table
Need formula to list total sales by Region without changing the master or data lists/ tables. Have 3 lists.
Required report. Sales by Region.
xRef. Section to Region. Each Section is assigned to ...
- 5
-2
votes
2
answers
133
views
Lookup multiple criteria
Is there a formula to return results for abc+FY25? It would have to spill over 3 columns. I have tried if(or()), xlookup, index/match, and combinations thereof. Perhaps helper columns? I can also do ...
- 3,183
3
votes
1
answer
78
views
Excel LAMBDA + spill
I've created this LAMBDA function and called it STR2ARR (note: yes, I know there are other functions in Excel that can do this, but I'm trying a concept that I want to use in a bigger LET/LAMBDA ...
- 302
0
votes
1
answer
85
views
Issue with Formula in Excel to work with Table Drop Down
I'm trying to put together essentially what is a PAT Testing Sheet which contains a table on most sheets other than settings. However, on the appliance sheet - I have columns which essentially looks ...
1
vote
1
answer
72
views
How do I filter results from a list based on previously-filtered results?
I'm tracking test grades for courses in Excel. I filtered individuals that failed the first test for re-test. There are also elimination options that would remove them from retests if they failed ...
- 13
3
votes
5
answers
150
views
How to calculate percentage similarity between two comma-separated strings in Excel?
I'm trying to compare two comma-separated strings in Excel and calculate the percentage of similarity based on matching values at the same position.
For example:
Cell A2 contains: "1,E,E,E,E,E&...
- 51
3
votes
6
answers
198
views
Attempting to create a pivot-like report using a formula
I am working with this data and attempting to create a pivot-like report using a formula, with months displayed as columns, status categories as rows, and the corresponding status counts under each ...
- 589
2
votes
1
answer
193
views
Event change calculation formula
I have a formula in Sheet1 in J4 that looks at a timer in F4 that counts down. Once it hits 00:00:04 it then adds a 1 to J4 as:
IF(F4="00:00:04", "1", "0")
In Sheet1's ...
- 35
1
vote
3
answers
110
views
Additional quotes pasting from Excel function to Notepad [duplicate]
I am using the following funtion in Excel with no issues to auto generate needed text:
="<Test Loc=" & CHAR(34) & [@[Location Path]] & CHAR(34) & ">" & ...
- 47
2
votes
2
answers
92
views
Is there a function that lets me drag to the right, and change the row instead of the column, and vice versus? [duplicate]
I have this function =[Reference.xlsx]Sheet1!B1 which is referencing another sheet, when I drag the formula to the right I would like it to change the reference row instead of column, so when I drag ...
- 29
1
vote
3
answers
110
views
Excel Range IF fails with an AND
Trying to aggregate a list of names that are overdue. This works great until I add an AND to the IF, then everything falls apart and no results are returned.
I need to aggregate a list of names by ...
- 1,381
0
votes
2
answers
89
views
Trying to keep only the duplicate rows of data in Excel based on a single columns values
I've got 4 columns of data where some of the rows were accidentally duplicated, but the only duplicated value was column A. I need to basically find an identify all the duplicates, which Excel can do ...
- 87