anubhavprabakar
New member
- Joined
- Jan 27, 2014
- Messages
- 1
- Programming Experience
- 1-3
Hi guys,
What I have:
I have an excel file which looks like this and I put data in it in a set of 10. This implies I put a particular amount of data For example in Header1 to Header10 and some other kind of data in header 11 to header20 and so on. (I have ATTACHED the file)
What I want
I wand to delete all the columns in a set of 10 if it contains only "s". (Example: I want to delete Header11 to Header20, all rows). However, I do not want to delete any other set of 10 columns which contains any other combinations with "s" (for example I do not want to delete headers 21 to 30 all rows, since it also contains blaa in it).
Can any one please help?
What I have:
I have an excel file which looks like this and I put data in it in a set of 10. This implies I put a particular amount of data For example in Header1 to Header10 and some other kind of data in header 11 to header20 and so on. (I have ATTACHED the file)
What I want
I wand to delete all the columns in a set of 10 if it contains only "s". (Example: I want to delete Header11 to Header20, all rows). However, I do not want to delete any other set of 10 columns which contains any other combinations with "s" (for example I do not want to delete headers 21 to 30 all rows, since it also contains blaa in it).
Can any one please help?