Hello everyone,

I have a quick question for anyone knowledgeable on the subject. I need to sort couple of columns and hopefully edit them out when they are sorted.

What my table looks like.

Value Name
1000 Joe
1000 Brian

What I need to do is first sort my whole table (>5,000 names) by value and then if I have any overlapping numbers (there can be a max of three overlapping values, i.e. Three people can have a value of 1,000), I need to edit them all our into a new sheet with a space between each group. Please help.