View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kjsmom98 kjsmom98 is offline
external usenet poster
 
Posts: 1
Default Deleting recuring data

I have a spreadsheet where there is one invoice number with muliple
lines. The shipping charges are recorded in each row even if there was
only one charge. There are also invoice numbers with multple lines and
multple shipping charges. I want to delete the rows where there was
only one shipping charge but keep the row where there were multiples.

Current Spreadsheet
Print Job Order Id # ordered Cost Total Cost Shipping
34525 2271 5 0 175.54 48.04
34725 2271 65 0 175.54 48.04
34518 2271 1 8 175.54 48.04
24203 6910 500 0 1269.26 201.73
24203 6910 500 0 1269.26 49.8
24203 6910 500 0 1269.26 21.42

What I would like to get back
34525 2271 5 0 175.54 48.04
34725 2271 65 0 175.54 0
34518 2271 1 8 175.54 0
24203 6910 500 0 1269.26 201.73
24203 6910 500 0 1269.26 49.8
24203 6910 500 0 1269.26 21.42

and then ultimately I would like all the shipping costs for order 6910
to be added so I can use this information in my pivot table.

Thank you for any help you can provide.