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