Macro to organize information within clusters

Hi all,

I have information organized within clusters, that i'd like ordered lowest->highest within each cluster, and duplicates should be deleted.

There are two columns, the numbers in column E are associated with the ones in column F and should stick together.
Each number in column E corresponds to only one number in column F, per batch.

Other notes: gaps should be removed


This all probably sounds very confusing so I've attached an exact sample of what i'm looking for.


As always, any and all help appreciated!

That works great on the sample!

I pasted in more data to columns E and F (for context, it is >25,000 rows), and when I ran the macro, I got a "400" error.

How can I fix this?

Oooh, you're right. There was one problematic cell right after the last "Batch End"

Thanks!!!

Np, you deserve it