I only took over where John left off...Glad to have contributed...Tx for rep +![]()
I only took over where John left off...Glad to have contributed...Tx for rep +![]()
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
I just drop by and saw this. I've notice there's some typo and mismatch in john formula. Since most search feature are case sensitive, text like CAMPBELL SOUP COMPANY may not be detected by the search/find feature. Maybe you can try using this as formula.
Or this formula if you have a fixed search text range containing (Y) or (Y1) which in my case is K2:K3![]()
=IF(OR(ISNUMBER(SEARCH("(Y)",F2)),ISNUMBER(SEARCH("(Y1)",F2))),"NT-BDEALER","NON NT-BDEALER")
Final VBA code with thanks to sintek![]()
=IF(SUMPRODUCT(--ISNUMBER(SEARCH($K$2:$K$3,F2)))>0, "NT-BDEALER", "NON NT-BDEALER")
![]()
Sub J3v16() With Sheets("Master_Data").Cells(1).CurrentRegion.Resize(, 24) .Cells(1, 22).Resize(, 3) = Array("Date", "Name", "ISIN code") With .Offset(1).Resize(.Rows.Count - 1) .Columns(7).Formula = "=IF(OR(ISNUMBER(SEARCH(""(Y)"",F2)),ISNUMBER(SEARCH(""(Y1)"",F2))),""NT-BDEALER"",""NON NT-BDEALER"")" .Columns(22).Resize(, 3).Formula = Array("=TODAY()-5", "=IFERROR(VLOOKUP(J2,vlookup!A:B,2,0),"""")", "=E2") End With .Columns.AutoFit End With End Sub
Last edited by seercoven; 10-19-2022 at 05:33 AM.
Thanks Boss, great help!! Solved @Seecoven and @sintex.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks