How to delete a row if column B has data in i
Closed
mirrorrim
-
20 Nov 2009 à 00:05
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 20 Nov 2009 à 05:49
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 20 Nov 2009 à 05:49
Related:
- How to delete a row if column B has data in i
- How to delete a row in word - Guide
- Saints row 2 cheats - Guide
- How to copy data from one excel sheet to another - Guide
- Tmobile data check - Guide
- How to delete skype account - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
20 Nov 2009 à 05:49
20 Nov 2009 à 05:49
BEFORE DOING THIS SAVE THE DATA SOMWHERE SAFELY SO THAT EVEN IF YOU MESS UP THE DATA THE ORIGNAL DATA IS AVAIABLE
each column musts have column headings like this col A and B
size date
s 1-Nov
m
l 5-Nov
xl
highlight data inlcuding column headings
click data menu-filter-autofilter
you will get small arrows in the column headings.
click the colum B heading and choose non blank
highLIGHT the ROWS other than row 1
right click and click "delete rows"
again click datamenu-filter and click autofilter
you will have the required data . POST FEEDBACK
each column musts have column headings like this col A and B
size date
s 1-Nov
m
l 5-Nov
xl
highlight data inlcuding column headings
click data menu-filter-autofilter
you will get small arrows in the column headings.
click the colum B heading and choose non blank
highLIGHT the ROWS other than row 1
right click and click "delete rows"
again click datamenu-filter and click autofilter
you will have the required data . POST FEEDBACK
