8,838 questions
0
votes
2
answers
93
views
Check Active Cells from Multiple Column in Excel Online
I have an excel online sheet that I am building. I have list of projects in a sheet and another sheets contain working hours on each of these projects in each week. What I am looking for is a code ...
- 21
3
votes
5
answers
183
views
index/match equivalent in R for merging data frames in a tidy way
I have two data frames in R that share SOME columns and SOME rows in an arbitrary order.
I now want to create a third data frame that has the columns and rows of data frame 1 merged with the ...
- 11.6k
1
vote
2
answers
94
views
excel search array for partial string match; return cell adjacent to string
I would like to search an array for a cell in the function's row and return the cell adjacent to the matching array row. The array cells contain partial matches with the function's row.
clients
...
- 11
2
votes
0
answers
76
views
Neo4j complex label expressions inconsistencies
I'm running Neo4j 5.18.1 enterprise edition with a cluster of 6 servers.
I'm running 2 queries on all servers in the cluster, trying to find a specific node.
The node in question has the following ...
- 11
-1
votes
0
answers
52
views
Why does string match print True/False into output? [duplicate]
I have a test.ps1 PowerShell script with "a" -match "b"; inside.
I run it using powershell -ExecutionPolicy remotesigned -File test.ps1.
Why do I see False printed in console? (and ...
- 168
3
votes
3
answers
110
views
Find regex match separated by two semicolons
This is the type of text I'm working with:
* went to the building; opened the door; closed the door; picked up some money ($20)
* walked next door; knocked on a window; purchased an apple pie ($6.95)
*...
2
votes
5
answers
162
views
Find match value VBA on 4 conditions
Can anybody help with this? look at the picture I upload.
I have 2 stores with the same location in column "A" and "G", column "B and I" says condition on location. And ...
- 46
1
vote
2
answers
111
views
Using Application.Match and an array with wildcards
So I have some code similar to this and it works well and seems to be fast and simple. I like that I can place a few dozen words in the array for words to search for.
Dim ArrDataType As Variant
...
- 371
3
votes
3
answers
99
views
Type mismatch error when using match on an array in Excel VBA
This code works fine
Dim MyArray
MyArray = Array("fee", "fi", "fo", "fum")
If Application.Match("fee", MyArray, 0) Then
Debug.Print "Pass&...
- 371
0
votes
0
answers
91
views
VIM keywords in syntax regex
I am currently writing a c3 syntax file for vim and I have some issues with a highlight.
I have this line:
syntax match ModuleName "\<module\>\s*\zs[a-z][a-zA-Z0-9_]*\ze;" display
and ...
3
votes
3
answers
187
views
Excel formula doesn't match Excel cell
I have a game log that contains a running ELO score. I am attempting to search through this game log to retrieve the most recent ELO recorded for each player. I believe I have managed to do this ...
- 5,050
0
votes
0
answers
27
views
Sum of vlookups with a partial match: What is the formula, if it exists?
I'm trying to see if this is even possible. I am essentially trying to get a partial match vlookup with the added component of possibly a sumifs formula to get the total amount of pay for each store.
...
0
votes
1
answer
65
views
Find matching named folders (different paths) and move a specified file from one to the other in Windows
I have worked all week to get my data to this point and am stuck with the final move. I have a folder called "Batch" and within it are numerous subfolders with different names. I have ...
- 13
1
vote
1
answer
96
views
How to incorporate INDIRECT to reference a tab name Into a Index and match formula in google sheets
I am trying to create a search box in a google sheet that finds the value of a cell from the time row and the date column in a specific tab
I have found the formula to use when I can enter the ...
- 13
2
votes
1
answer
77
views
How to find all near-matches between values in the same data frame column in R?
I have a data frame of phonetic transcriptions of words, and for each transcription, I need to find all the words with the same transcription but with "1.M", "1.N", and "1.NG&...
- 21
0
votes
1
answer
107
views
If column B is True and column A matches array element, update column C
Sub AssignValue()
Dim ws As Worksheet
Dim lastRow As Long
Dim i As Long
Dim validValues As Variant
' Set the worksheet
Set ws = ThisWorkbook.Sheets("ReformattedData"...
0
votes
1
answer
91
views
How to simply match two cells that have a letter different, for compliance checking
This seems like such an easy solve, but Im just brain blanking on it.
Apologies on the picture, people say enter these things as an excel sheet and I don't see that option.
Currently my =MATCH(A1291,...
- 35
2
votes
4
answers
147
views
Is there a simple formula to count how many times a combination of two columns appears in excel?
I am trying to quickly count a competition in which teams play each other 2 times maximum.
Round
Date
Field
Time
Home
Away
R1
14/04/2025
F1
19:00
Apples
Oranges
R1
14/04/2025
F2
19:00
Pears
Grapes
R1
...
- 35
0
votes
3
answers
88
views
Compare date in one file to dates in another file to find the closest match and apply the label
I have two files:
> print (CVA_data)
Ticket timestamp AX DM DR FM FX HD IN MO MY SR TW
2 48904 2025-03-12 07:57:00 0 0.00 12.1 0.69 0 0 0 12.1 0 0 59.2
3 48905 ...
- 103
0
votes
1
answer
88
views
How to ignore a tag value while matching two json response payload in karate match
I am using Karate framework and trying to match two feature file json responses are similar, where the date tag has different values so I want to ignore the values but make sure the fields are present....
0
votes
2
answers
86
views
Trying to extract a number from a string and compare it to another number in a set of strings
I have the following set of data. In sheet A the data appears like "John D #23". In sheet B the data appears like "J Doe #23 (other info no numbers)".
I need to write an excel ...
- 9
-1
votes
1
answer
74
views
Align pasted data by columns
I'm having difficulty with aligning data in excel while using a macro.
The data in wb1 is for example like this:
Thomas 10
Jason 11
(blank) (blank)
Clara 14
The data in wb2 is for ...
4
votes
2
answers
60
views
Compare 2 Lists Return Matches
Just trying compare two lists in columns A B and look for text and integers that are matches in column C. Not sure what function makes sense xlookup or index/match? I only have 2019 excel capabilities....
- 221
1
vote
1
answer
51
views
Date Range Large Index/Match Duplicate
The results area is finding the largest top 4 costs in column A within the date range =IFERROR(LARGE(IF(Sheet1!$D$5:$D$4935>=$A$2,IF(Sheet1!$D$5:$D$20<=$B$2,Sheet1!$E$5:$E$20)),1),0)and then ...
- 221
0
votes
4
answers
134
views
Test range content
I have a range of cells in one row. I want to test if they all do not have content.
I found If Not IsError(Application.Match(ValueToSearchFor, RangeToSearchIn, 0)) Then
I fixed the ranges to be more ...
1
vote
2
answers
116
views
Aggregate/Match Conditions Based on Date Range
Need to retrieve matching Date, Type, ID, and reference Cost based on user input Date Range. In Data Set 1 and Data Set 2 inputs are not sorted, and the match conditions need to look at if it falls ...
- 221
4
votes
1
answer
87
views
Powershell -match returning System.Collections.Hashtable[1] in $Matches
I haven't the faintest what is going on here, so I am turning it over to the cloud mind to figure out, sorry.
I have a string (confirmed with .gettype()), an excerpt of which is below (\r\n at the end ...
- 950
1
vote
1
answer
78
views
INDEX MATCH Function Inconsistent
I have an excel table (Sales Table) that uses an INDEX MATCH function within a few columns. There are 2 specific columns (Product and Part Number) which are using a material number column to pull ...
- 37
1
vote
2
answers
78
views
What is the idiomatic way to handle code duplication in match bindings for Result? [duplicate]
I'll give some context here. The closure foo takes in a character and inserts it into a sorted vector. foo uses binary_search_by_key to insert the character into the vector at the correct index.
What ...
- 2,334
0
votes
1
answer
52
views
Find all matches between two columns and return values from another column horizontally [duplicate]
I am trying to figure out the most efficient way to find all matches of multiple values in one column and return values from another column. Let me try to explain it with images below:
Here I am ...
- 333
1
vote
1
answer
58
views
Tracking variable name changes within group in Excel
I am annually tracking the names of car models, which may or may not change each year (its random).
Suppose I start with three models in 2023 that all changes name in 2024 and 2025, thus producing the ...
- 153
1
vote
1
answer
67
views
Algorithm to find the best file match when the filename is often a substring of the search term
I'm making Chrome extension to find lyrics for song on YouTube. I have lyrics written in files in extension folder. Files are named Name of song.txt. What I'm trying to do is to match search term ...
- 1,152
0
votes
1
answer
53
views
Search Excel for multiple values based on column header and row filter
I have a table of data that gives the daily price of gas based on Supplier ID (column B) and Gas type (column C). As you can see, the price values are under a date column headers.
I'd like to to ...
0
votes
1
answer
43
views
Match data and return multiple fields
Looking for tips on what would be similar to a VLOOKUP but with the ability to return multiple fields. On excel file 1 is a list of customer names and addresses in my system. Excel file 2 is a list of ...
1
vote
1
answer
112
views
How do I get matched pairs of results (1 male and 1 female) with the same age at random?
I have a database/table with this structure:
Year
Age
Gender
OrderID
2012
18
M
4268
2021
75
M
7569
2015
56
F
5381
2018
29
M
2876
2014
33
F
3749
What I am trying to acheive is that I want 400 records/...
- 25
4
votes
2
answers
57
views
How to count the number of matches in a tibble list column to another data frame in R?
I have two sets of data:
The first data frame (small) is relatively smaller than the second data frame (large). Each data frame has an id column with unique identifiers. The smaller data frame has a ...
- 230
0
votes
2
answers
183
views
Merge dataframes with conditions using PySpark
Currently I'm making calculations using PySpark and trying to match data from multiple dataframes on a specific conditions.
I'm new to PySpark and decided to ask for a help.
My first dataframe ...
- 333
0
votes
1
answer
82
views
index match not working for a list of values starting with same text string
On a Workbook with two sheets, I need to retrive the value of "Application Group" column "B" in the first sheet into column "E" second sheet. The matching values are ...
- 1
-1
votes
1
answer
67
views
Match multiple strings in the same text with a single regex
I have the following regex entry
(?<Nr>3\d{6})(?=[\s a-zA-Z\r\n]|$)
to search for a specific sequence of numbers in a text (starting with
"3" and followed by 6 other digits). I need ...
0
votes
1
answer
148
views
Excel display first Occurrence Based on Multiple Criteria
So I have some payroll data and I have a formula in P and put a Y if it meets something.
what I want is to only have it show a Y for the first occurrence per check (H)
looking at the example it would ...
1
vote
1
answer
60
views
Excel: Using Index/Match Functions Instead of Vlookup
enter image description here
Could someone help me turn the following equation in Column I into one where it does not use Vlookup but rather Index/Match functions and gives me desired result please. I ...
- 11
0
votes
0
answers
40
views
Accidentally created a infinite loop while trying Match Case
I did an oopsie and made an infinite loop at the match case in the end:
import pyautogui
import cv2
import numpy as np
import time
def find_image(image_path, confidence=0.8):
screenshot = ...
- 1
1
vote
1
answer
58
views
If value matches x, enter new value into another table using row and column matches
I'm using Excel 365 and trying to take advantage of VisualBasic for this query. I'm working with two tables where if Table: EventDiary[Match] = 1 then I want to enter the [Actual] value (-30) into ...
- 159
0
votes
1
answer
378
views
OFFSET - MATCH with multiple criterias
I need to include another MATCH criteria inside this formula to add it in the Data Validation for a drop down list:
=OFFSET(Data!$Y$1,MATCH(J$4,Data!$X$2:$X$500,0),0,COUNTIF(Data!$X$2:$X$500,J$4))
...
0
votes
1
answer
68
views
Match lock deals with deadlocks caused by long-term tasks
I am confused by the results of running the following code. I can understand the logic of the behavior, but it seems a bit unreasonable to me (because I think it makes the variable lifetime confusing)
...
- 19
0
votes
2
answers
99
views
Using average, offset & match together
I'm creating a fitness tracker with daily inputs & a weekly summary on a dashboard. My daily input data looks like this:
Date
Miles
Intake
01-Dec-24
11
3130
02-Dec-24
0
2730
03-Dec-24
8
2930
04-...
- 127
0
votes
1
answer
60
views
A range where value is in the right of text randomly. I want to sum all the values by finding the text across all columns and rows
Need total value of a, b & c
I've tried with offset function with match & column nested. It worked but only for first matching value from a column.
Example: =IFNA(OFFSET($B$3,MATCH($L3,B$3:B$...
0
votes
2
answers
141
views
How to return the column and row headers for a lookup value?
I am trying to return the column and row headers for the different locations in an array. In this case the X and Y coordinates of S1 (2,2), S2 (9,3), and S3 (2,9). I have tried using the following ...
- 13
1
vote
1
answer
1k
views
Excel VBA Function with Match and Index
I am trying to write a function to use Match and Index to perform a lookup down a column and across two rows for a more complex lookup. I have a spreadsheet where row 3 uses the formula which works ...
1
vote
1
answer
216
views
Regex matching in a Splunk search query that involves a lookup table
I have created a lookup table in Splunk that contains a column with various regex patterns intended to match file paths. My goal is to use this lookup table within a search query to identify events ...
- 21