8,829 questions
0
votes
1
answer
92
views
Excel Find cell value from a set of arrays
I am looking to write a formula that is able to take the value in B1, search for it within the array D3:J3, and return with Attribute 1 from the array below the cell where the match is found (ie. D4:...
- 9
Advice
1
vote
6
replies
102
views
How to match any amount of Unicode characters (letters, numbers, surrogate pairs) in regex?
How to match any amount of Unicode characters (letters, numbers, surrogate pairs) in regex:
😆
ẘ😆
😆😆
ẘaሴ
abc123
I am looking for an equivalent to /^(\[a-zA-Z0-9\]+$)/i that finds ASCII.
- 1,727
1
vote
1
answer
93
views
Syntax match issue with lookahead (regex \@=)
My understanding is the match resulting from \@= SHOULD NOT INCLUDE the lookahead characters. Here is an example that has me perplexed:
syn match InspectKeyword '\v(\+\s)\@=\w+'
Results in:
The ...
- 51
0
votes
2
answers
96
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
205
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
100
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
81
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
3
votes
3
answers
117
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
165
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 ...
- 47
1
vote
2
answers
115
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
108
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
98
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
189
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
31
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.
...
1
vote
1
answer
111
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