Need Excell Help Again

Reply #2

Sage — Sat, 24 Sep 2011 12:28:27 GMT

Thank you so much Iwill give this a try and let you know how I do! Thanks again and have a wonderful weekend

Reply #1

phileight — Sat, 24 Sep 2011 09:18:54 GMT

Sage this macro will show you doubles in a data set. I put in a lot of comments so hopefully you can follow what the code does and modify to suit your situation.

Sub show_doubles()

' assumptions

' data is in col a-d

'show results in col f, and g if more than 1

'clear output area in case there is something there

Range( f1:g7000 ).Select

Selection.ClearContents

Dim tn(10) ' work space, for me tn means test number

' start a loop

For x = 1 To 10000 ' if you have mo... [ More ]

Need Excell Help Again

Sage — Sat, 24 Sep 2011 04:29:33 GMT

Does anyone know the formula to search a cash 4 number for doubles. Say I have 1443 I want to be able to use a macro to search the 1443 and pull out the double 44's? Or if it can be done wihtout a macro that's fine also. Thanks so much in advance.