All Questions
58
questions
0
votes
0
answers
35
views
How do I use Index and Small in excel sheet
I have three sheets in excel one is supplier sheet and other two sheets are customer sheet. I want that when I update the supplier sheet so the data automatically copy to customer sheet as well. For ...
0
votes
2
answers
99
views
Excel Formula or VBA to find next cell in a row with a wildcard value AFTER date column
I am trying to make a column that shows a student's next planned event. I have some code that works but I would have to copy paste it for every single line offset and update it every time a student ...
- 1
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
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
-2
votes
2
answers
558
views
Formula to Find if Number is between a Range in 2 Columns and then Pick 1st Column, or 2nd if Empty
There are 4 columns. 1st column has the result, 2nd column has a backup result if the 1st column is empty, the 3rd column has the low/floor value of range, and the 4th column has the high/ceiling ...
- 21
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
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
1
vote
2
answers
454
views
Add a formula to Excel cell using Apache POI XSSF workbook
I must add formulas to an Excel worksheet and I found out this is done in the following way:
String strFormula= "SUM(A1:A10)";
cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
cell....
- 11
0
votes
2
answers
524
views
Excel Formula Help: Lookup/Match string field from one table against another
Would appreciate any help with the following: I have a table that has a list of keywords, for example:
Table 1:
Keywords
Red
Blue
Orange
Green
I need to scrub a string field in another table, ...
- 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
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
1
answer
50
views
Index and match approximate in row and column formula not working
I have a table. In column "A" there are heights, and in row "2" there are widths. The initial input for width and height are given by the user. And the output should be a given ...
- 3
0
votes
0
answers
39
views
Search cell "address" in row based on last value in row in excel
I would like to ask for help.
I need to improve my order capacity system.
For each order, I have one row of "1","0" in timeline telling me the beginning & end of production. ...
- 11
0
votes
0
answers
160
views
Excel Table Formula loses it's row alignment - Inconsistent calculated formula
[ROW1059] =IFERROR(INDEX(tbl_ProjectList[[#All],[Engineering Project '#]],MATCH(Journal!$C1059,tbl_ProjectList[[#All],[Project Name]])),"")
[ROW1060] =IFERROR(INDEX(tbl_ProjectList[[#All],[...
- 1