LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fetching data and deleting original data prem New Users to Excel 3 January 10th 09 02:56 AM
MS2007 - deleting filtered data, deletes non-visible data too Nita Excel Discussion (Misc queries) 1 December 9th 08 03:42 PM
Deleting data chucksatt Excel Worksheet Functions 1 August 11th 08 02:08 AM
Deleting cell data without deleting formula Tom Hall Excel Discussion (Misc queries) 4 October 29th 06 04:07 PM
moving data in excel without deleting existing data jigna Excel Discussion (Misc queries) 1 January 30th 05 11:35 AM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"