priyanka retharock
New Member
- Joined
- Aug 2, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
i have columns which contains series of columns i have used this condition to do
Range("$M2:$M" & r & " ").Formula = "=IF(ISNUMBER(SEARCH(""appl1"",K2)),""laptop"","" "")"
where afggpl1,dfgl3,dfgg2. -->should be laptop and appl2,eggl4,fghl6 are to be in desktop how can i specify using search number formula
Range("$M2:$M" & r & " ").Formula = "=IF(ISNUMBER(SEARCH(""appl1"",K2)),""laptop"","" "")"
where afggpl1,dfgl3,dfgg2. -->should be laptop and appl2,eggl4,fghl6 are to be in desktop how can i specify using search number formula