Hello, I use Excel 2003 working on a very large spreadsheet that details all the items sold by the company I work for over a 12 month period. The data is exported from Crystal and is so large that it automatically groups the pages (68,000 rows, 6 columns).
The problem I have is the number of identical entries but cost and values are debit & credit(see below for example). I would like to delete all of the negative and matching positive rows to free up space and possibly allow whole lot to fit onto one page. I use this data to create a pivot table so others can use it but excel crashes when I attempt to so do with a group so I need to remove some of the items that are inter company transfers.
Date Invoiced Customer Product No. Cost Value
23/10/07 A Green CA24 19 16.2 307.8
23/10/07 J Smith CA24 16 33.20 531.20
23/10/07 J Smith CA24 16 (33.20) (531.20)
23/10/07 P Black CA12 16 12.53 200.48
24/10/07 J White CA36 35 16.75 586.25
If you can help with this it would be much appreciated.
The problem I have is the number of identical entries but cost and values are debit & credit(see below for example). I would like to delete all of the negative and matching positive rows to free up space and possibly allow whole lot to fit onto one page. I use this data to create a pivot table so others can use it but excel crashes when I attempt to so do with a group so I need to remove some of the items that are inter company transfers.
Date Invoiced Customer Product No. Cost Value
23/10/07 A Green CA24 19 16.2 307.8
23/10/07 J Smith CA24 16 33.20 531.20
23/10/07 J Smith CA24 16 (33.20) (531.20)
23/10/07 P Black CA12 16 12.53 200.48
24/10/07 J White CA36 35 16.75 586.25
If you can help with this it would be much appreciated.