Grouping code Maj_Rock

[iraidotel]

hi, all
I have a table that I want to group
with the provisions on the field maj_rock same code sequence and if the code is the same in writing his Depth_from smallest and on his Depth_to greatest number.
if no other code is treated the same as well.

attechment attached.

thank you

Regards, Ira

 

[dianacris]

Good thing you attached a file because your description of your problem was less than clear. After reviewing your attachment, I'm not sure how you'd group and get the result you're looking for.

Can you output a "final" table with the desired result like what you have in B37:F37? If you can create the "desired data" on another sheet and keep the raw data for reference, then you could write some vba that would generate the result. You need code that will remove the unneeded rows and update the depth_to value to the max value found.