View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna[_2_] Donna[_2_] is offline
external usenet poster
 
Posts: 76
Default Keep lines when one column equals certain criteria

Thanks for taking a look at this one.
I have a worksheet with invoice amounts, payments, voids and adjustments
each on a separate line. Each line has an invoice reference in Col F. If
Column K has "Adj" in it I would like for it to keep all the corresponding
lines for that invoice.
Col F Col K
12344
12345
12345
12345 Adj
123456
123456 Adj
123457
123457

I would want it to keep all the lines for inv. 12345 and all the lines for
123456

Thanks