grouping by model into laptop or desktop

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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,102,563
Messages
5,487,583
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top