Here, I have column D2 in which I used a formula (as shown in picture below) which basically tells me at which rows the duplicates are. For example, texta is repeated in rows 2,5, and 6.

Now, what I'm looking for is a method for me to not show the D2 column but instead when I select texta (B2) it gives me a pop-up window or an output message/comment stating at which rows the duplicates are (i.e 2,5, and 6).