All Questions
86
questions
0
votes
1
answer
30
views
Find the Rank 02 Matching element against the Given Key word
I have two tables, Table two with code and Key words.
Now I need to get the rank 02 separately
Table 01 With combination of Key words, SO need to find the 2nd Rank of height matching row of each ...
- 133
1
vote
1
answer
475
views
If cell equals condition, find next value in a column and return it's adjacent value
I need some help with an excel formula. In E2, I need to do a formula like this:
=if(A2=1,find-in-Column-C-starting-from-C2,where-next-"Fruit"-is, and-return-the-adjacent-cell-in-column-B, ...
- 740
-1
votes
1
answer
104
views
Comparing similar words in two different columns
I have list of different categories in same dataset in two different columns.
Example data how the comparison should be:
There are some similar words in the two columns. So by comparing the two ...
- 117
0
votes
1
answer
121
views
Index and Match multiple matches
I need help with the following query. There are 2 excel sheet and I need to find out in Sheet 1 in Column A what are the different accounts matching, the refernce is Sheet 2.
I am looking for a ...
- 21
0
votes
0
answers
34
views
Excel Online Cannot Match Multiple References At A Time
I am trying to use INDEX MATCH with 2 matches across two different sheets however multivariable matching only works on Excel Desktop and not Excel Online. I need this to work on the online version ...
- 1
0
votes
1
answer
899
views
Excel: compare two cells containing strings and return TRUE if multiple words match
I am trying to compare two cells containing strings. I can't use VBA for restrictive reasons on my computer so it's just formulas for me. This is what I have:
One cell is there to enter lots of ...
-3
votes
2
answers
73
views
Excel/Google Sheets - find matches if in 4 columns
I have 1 sheet with 4 columns (A,B,C,D), with each containing a list of emails.
I would like a way to create a new column of emails if they were found in all 4 of columns A-D.
Does anyone know of a ...
- 3
2
votes
1
answer
111
views
Excel matching 2 columns by text and numbers
I have 2 excel tables with data and i want from table 1 to get the item number and add it to table 2 based on item description thats contained in table 1 column itemName2.
Table1 data:
Table2 data:
...
- 103
0
votes
2
answers
1k
views
Formula Help to Find if Number between a Range in 2 Columns and then Offset 1 column
I have 2 groups of columns that are. The first group is a set of 2 columns: 1st column and 2nd columns are both numeric and have a set of search values. The 3rd and 4th columns represent ranges, with ...
- 21
0
votes
1
answer
152
views
Formula gives wrong result
i have a question about formula.
I am using 1 workbook as template for extracting data from another workbooks.
This picture show template workbook:
In the formula there are 2 ref values, ref value ...
- 51
0
votes
2
answers
681
views
Use index, match, and row/column excel functions in a formula to return a subset array with just cells with text and exclude the empty ones
I have this scenario where i want to extract a subset of a range in one row (using index, match and row functions preferably ) and return only smaller filtered array with cells that contain text/data ...
- 3
0
votes
1
answer
85
views
Extract a List of Values from an HTML string Based on a List of Cell Values
I have an export of our blog, and I'm trying to see which SKUs where listed in that blog post.
I have a list of SKUs and the Blog Content in a spreadsheet. I need to figure out how to get all the SKUs ...
-2
votes
1
answer
2k
views
Excel - Find a Cell in an array and its location
Looking to figure out how to determine the address of a cell in an array based on a previously determined max value. See the attached picture:
What I'm looking for in this image is the cell directly ...
- 1
2
votes
1
answer
16k
views
Excel - if cell contains text in a list then return value of another cell
I have 3 columns:
A - Lookup item
B - List
C - Link
D - formula goes here
I want to search column B for the text in each cell in column A.
For example, A2="bread" and with column B it has B2=...
- 21
0
votes
2
answers
50
views
Excel formula for summing all values situated right under each match of a string in a column
Here is my data:
I'm looking for an Excel formula that would calculate the sum of all values in a column, values situated right under every match of a string in that column.
So formula in B1 should ...
- 99