How to delete a row if column B has data in i Closed

Question

Hello,

I have 2 columns. Column A has t-shirt sizes. Column B has dates shirts were picked up. I need to delete rows that have dates in Column B.

Basically, I want to see all the t-shirt sizes I need to order that havent been picked up by customers already.

Example:

A       B
XL      10/1          <-want this deleted
M                       <-want to see this
S        12/2         <-want this deleted

Thanks.

venkat1926 · Answer

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

How to delete a row if column B has data in i

1 response

Similar discussions

Subscribe To Our Newsletter!