How to delete a row if column B has data in i
Closed
mirrorrim
-
Nov 20, 2009 at 12:05 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2009 at 05:49 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2009 at 05:49 AM
Related:
- How to delete a row if column B has data in i
- How to delete a row in a table in word - Guide
- How to delete whatsapp account without login - Guide
- Saints row 2 cheats - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 20, 2009 at 05:49 AM
Nov 20, 2009 at 05:49 AM
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