anubhav prabakar

anubhav prabakar

  • NA
  • 14
  • 7.2k

Delete data from excel file

Jan 27 2014 5:18 AM
HeaderMain1HeaderMain2Header1Header2Header3Header4Header5Header6Header7Header8Header9Header10Header11Header12Header13Header14Header15Header16Header17Header18Header19Header20Header21Header22Header23Header24Header25Header26Header27Header28Header29Header30Header31Header32Header33Header34Header35Header36Header37Header38Header39Header40
BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAA
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssssBlaaBlaaBlaaBlaaBlaaBlaablaablaablaaBLAABLAABLAABLAABLAABLAABLAABLAABLAABLAA
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssssBLAABLAABLAABLAABLAABLAABLAABLAABLAABLAA
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssssssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssssssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssssssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssssssssssssss
MAIN BLAAMAIN BLAABLAABLAABLAABLAABLAABLAABLAABLAABLAABLAAssssssssssssssssssssssssssssss

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 UPLOADED THE EXCEL 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?






Attachment: deletes.rar

Answers (4)