niladri20052006
Board Regular
- Joined
- Dec 3, 2010
- Messages
- 121
Hi All,
I have a set of data where there are innumerable titles like below..Everyday day I work the same thing. I try to find first Network titles from my list then information technology Director then information technology Manager, information technology Executive and then any titles related with Systems.
Network Administrator
Software Engineer
Software Architect
Information Technology Director
Information Technology Manager
Chief Information Officer
Channel Manager
Account manger
Systems Executive
I want the list where the network title should be then Information technology and then Systems.
I am doing it applying contains from Filter tab. It works but takes a long time.
I have also added custom option in Sort function. It is not working.
As I am doing the same thing I created a micro but after running the data is completely mixed up.
Is there any formula can help me to get it done in a hassle free way?
Thanks in advance
I have a set of data where there are innumerable titles like below..Everyday day I work the same thing. I try to find first Network titles from my list then information technology Director then information technology Manager, information technology Executive and then any titles related with Systems.
Network Administrator
Software Engineer
Software Architect
Information Technology Director
Information Technology Manager
Chief Information Officer
Channel Manager
Account manger
Systems Executive
I want the list where the network title should be then Information technology and then Systems.
I am doing it applying contains from Filter tab. It works but takes a long time.
I have also added custom option in Sort function. It is not working.
As I am doing the same thing I created a micro but after running the data is completely mixed up.
Is there any formula can help me to get it done in a hassle free way?
Thanks in advance