Find cells with same values

[CobraLAD]

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

[Sintek]

What do you mean show?

Do you want this as the result....

"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"

do something and continue to the next set

And...Do what?

This will give you an idea to "SHOW" the address of each Sample Text

Please Login or Register  to view this content.

[CobraLAD]

Thank you sintek, but it must skip where there is only 1 value, in this case A10, A11 & A12 must be skipped, as there is no duplicates
And it must just show the address

Please Login or Register  to view this content.

[CobraLAD]

My end goal is to group the yellow rows with the yellow cells, so that only 1 cell of each value is shown in level 1

[CobraLAD]

i found the perfect macro on another forum

Please Login or Register  to view this content.

[Sintek]

Thank you sintek, but it must skip where there is only 1 value, in this case A10, A11 & A12 must be skipped, as there is no duplicates
And it must just show the address

This was not mentioned...It would have been so much easier if you were just more transparent with your requirement...
This red snippet skips that ...

Please Login or Register  to view this content.

Still have no idea what you really want to do as no clear explanation has been given...

My end goal is to group the yellow rows with the yellow cells, so that only 1 cell of each value is shown in level 1

So are you wanting theses rows hidden?
If so then this snippet can be used...

Please Login or Register  to view this content.

[jindon]

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"

Please Login or Register  to view this content.