Identify duplicate values and provide list

[sharky12345]

I want to be able to run a code that will bring up a list of all duplicate entries in Column B. It must show how many times that entry exists and then take the user to the last entry for whichever duplicate value the user wants to look at,

Is it possible?

 

[SteveO59L]

I and then take the user to the last entry for whichever duplicate value the user wants to look at,

Is it possible?

How is this defined ?

 

[sharky12345]

It is possible on the sheet for a number of entries to be duplicated over time, because the sheet is a database which does not get deleted or changed, only data is added to it.

So when the user searched for duplicates and finds them , there could be several - they must have the ability to go to the last occurrence of whatever duplicate they choose, which is likely to be one of the last entries.

The duplicated data is random - not numbers or letters but a combination of both. Case is not an issue because I've formatted the textbox on the input form to convert it to the correct case.

Is this what you needed to know?