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

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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