Remember Me?

#1
November 19th 05, 12:18 PM posted to microsoft.public.excel.worksheet.functions
 viktor Posts: n/a
double records

Hi,

How can i get the double records from one column with multiple
records(thousends)?

thanks!

#2
November 19th 05, 12:36 PM posted to microsoft.public.excel.worksheet.functions
 Niek Otten Posts: n/a
double records

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
Hi,

How can i get the double records from one column with multiple
records(thousends)?

thanks!

#3
November 19th 05, 04:23 PM posted to microsoft.public.excel.worksheet.functions
 Bruno Campanini Posts: n/a
double records

"viktor" wrote in message
...
Hi,

How can i get the double records from one column with multiple
records(thousends)?

The following writes from TargetSource down, all duplicates found
in SourceRange down.
Just set your Source and Target ranges in Definitions.
=========================================
Sub WriteDuplicates()
Dim SourceRange As Range, TargetRange As Range
Dim i, j As Long, TestColl As New Collection

Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

' Definitions
' ---------------------------------
Set SourceRange = [Sheet10!AA189]
Set TargetRange = [Sheet10!AB189]
' ---------------------------------
If Not IsEmpty(SourceRange(2, 1)) Then
Set SourceRange = SourceRange.Resize _
(SourceRange.End(xlDown).Row - SourceRange.Row + 1)
End If
For Each i In SourceRange
On Error GoTo WriteDuplicate
Continue:
Next

Exit_Sub:
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Exit Sub

WriteDuplicate:
j = j + 1
TargetRange(j, 1) = i
Resume Continue

End Sub
==========================
Ciao
Bruno

#4
November 20th 05, 01:01 AM posted to microsoft.public.excel.worksheet.functions
 Roland Posts: n/a
double records

Viktor,

Here's a technique that I use.

Assume your list is in column A starting with a header in cell A1, data
in cel A2, and as you said, runs over a thousand rows.

In cell B11 type this formula

=VLOOKUP(A11,A\$1:A10,1,FALSE)

Copy the formula up and down column B to match your data.

A #N/A will appear next to the first instance of each data value. A
repeat of the data value will appear next to the 2nd and subsequent
occurances.

"viktor" wrote:

Hi,

How can i get the double records from one column with multiple
records(thousends)?

thanks!

#5
November 20th 05, 08:13 AM posted to microsoft.public.excel.worksheet.functions
 viktor Posts: n/a
double records

thank's, Roland! the formula was very usefull!
For Niek: when i will have some free time, i will study the forward site
that you give me! The thank's are for you, alsow!

"Roland" wrote:

Viktor,

Here's a technique that I use.

Assume your list is in column A starting with a header in cell A1, data
in cel A2, and as you said, runs over a thousand rows.

In cell B11 type this formula

=VLOOKUP(A11,A\$1:A10,1,FALSE)

Copy the formula up and down column B to match your data.

A #N/A will appear next to the first instance of each data value. A
repeat of the data value will appear next to the 2nd and subsequent
occurances.

"viktor" wrote:

Hi,

How can i get the double records from one column with multiple
records(thousends)?

thanks!

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post snbahri Excel Worksheet Functions 8 December 1st 06 07:18 PM Ian Smith Excel Worksheet Functions 1 September 28th 05 08:00 PM [email protected] Excel Discussion (Misc queries) 4 August 22nd 05 11:45 AM jophy j via OfficeKB.com New Users to Excel 3 July 25th 05 12:42 PM [email protected] Excel Discussion (Misc queries) 6 June 22nd 05 11:35 PM

All times are GMT +1. The time now is 01:48 PM.