i need to know how or if i can get a formula that will let me sort my beams that has been returned and the ones that hasn't. but when it sorts it i need the whole line to stay together. and i would like the ones that hasn't been returned to be put on a different page in a different work sheet. thanks for the help jennifer



7/24/2013
DATE # of day SET # BEAMS SHIPPED BEAMS RETURNED
1/17/2013 187 80219 A2826
1/17/2013 187 80219 A3731
1/17/2013 187 80219 A2019
1/17/2013 187 52335 A2162 3/25/2013
1/17/2013 187 52335 A2988 3/25/2013
1/17/2013 187 52335 A3723 3/25/2013
1/17/2013 187 52336 A3637 5/8/2013
1/17/2013 187 52336 A3632 5/8/2013
1/17/2013 187 52336 A3863 5/8/2013
1/17/2013 187 80223 A1306
1/17/2013 187 80223 A1768
1/17/2013 187 80223 A2790
1/17/2013 187 80227 A2028 3/25/2013
1/17/2013 187 80227 A1026 3/25/2013
1/17/2013 187 80227 A1842 3/25/2013