help with macro

[Ejohnny]

Hi all,

I have been using this forum for quiet a while and finding what i need without posting. This I am stuck on:

I have a speadsheet with 30K rows and not organized as good as i want it to be.

In coloumn E i have have a mix of values and text. I want a macro - or any other way of doing the following :

Grab the first value in coloumn E and search coloumn E for that same value. If it is found i want it to return the value and the text. For example

Column E

Company ABC
1.15
2.10
3.50
Company DEF
9.10
3.15
2.20
Company GHI
3.12
1.15
1.00

OUTPUT WOULD BE

Company ABC
1.15
Company GHI
1.15


I want it to go down that coloumn and output ALL Duplicates
Thanks

 

[texasalynn]

will the format always be text followed by three lines of numeric?

 

[Ejohnny]

will the format always be text followed by three lines of numeric?

Sorry. No it ranges from 1 to i think 50