Hi,
Not entirely sure what you mean by item 3.
Seems to me you need two macros. One to remove duplicated rows and then one to sort the data.
I'd be inclined to use a helper column to decide if a row is a duplicated although I'm confused by your reference to identifying a duplicated row if the cells in column A & B are equal. Do cells in column A & B identify duplicates with other rows?
Filtering data with a macro is quite simple. Just identify a two cell vertical criteria range where cell 1 contains the column label and cell 2 defines the value that identifies a duplicate. Then use something like
Once you've filtered the duplicate rows and want to delete them use something like
Bookmarks