Find cells with same values

Hello All

I want to find cells in 1 column with the same value and show the range from the second cell up until the last cell with the same value, do something and continue to the next set

I attached a sample file.

For example, in Range("A1:A7") is "Sample Text 1". Find all the same cells, but show Range("A2:A7")

"Sample Text 2" must show "A9"
"Sample Text 6" must show "A14:A15"
"Sample Text 7" must show "A17"
"Sample Text 8" must show "A19:A24"

Thank you