norwoodkd2001
New Member
- Joined
- Jun 30, 2015
- Messages
- 10
I am trying to locate all the instances of a list of values in one column in another column that contains text strings.
Below is an example of my data (in worksheet Column A is 240 rows and Column B is 1115 rows
Column A Column B
iif([#1177] >0,"Y", "N") 762
iif([@762]>#01/01/2013#,DateAdd("d",-15,[@762]),"") 356
iif([1039]="203K",iif([384]="Refinancing",([#1109]/min([#1092]+[#967],[#356])*100),([#1109]/min([#136]+[#967],[#max23k.x6])*100)),0) 1177
(([#2213] + [#2212])/([#2211]/100)) + 100 967
I need to find every row in Column A that contains the value in Column B
I have tried these formula's: =IF(SUMPRODUCT(--(A$1:A$240<>""),--ISNUMBER(FIND(A$1:A$240,B3))),"Yes","No")
=INDEX($B$1:$B$1115, SMALL(IF($B$48=$B$1:$B$1115, ROW($B$1:$B$1115)-MIN(ROW($B$1:$B$1115))+1, ""), ROW(A1)))
But neither of them work. I believe it has something to do with column A being a text string that contains the values I want to find.
Any suggestions? I"m using Excel 2013.
Below is an example of my data (in worksheet Column A is 240 rows and Column B is 1115 rows
Column A Column B
iif([#1177] >0,"Y", "N") 762
iif([@762]>#01/01/2013#,DateAdd("d",-15,[@762]),"") 356
iif([1039]="203K",iif([384]="Refinancing",([#1109]/min([#1092]+[#967],[#356])*100),([#1109]/min([#136]+[#967],[#max23k.x6])*100)),0) 1177
(([#2213] + [#2212])/([#2211]/100)) + 100 967
I need to find every row in Column A that contains the value in Column B
I have tried these formula's: =IF(SUMPRODUCT(--(A$1:A$240<>""),--ISNUMBER(FIND(A$1:A$240,B3))),"Yes","No")
=INDEX($B$1:$B$1115, SMALL(IF($B$48=$B$1:$B$1115, ROW($B$1:$B$1115)-MIN(ROW($B$1:$B$1115))+1, ""), ROW(A1)))
But neither of them work. I believe it has something to do with column A being a text string that contains the values I want to find.
Any suggestions? I"m using Excel 2013.