Hi

I have a problem that im not able to solve. In col A in sheet 1 i have some data, number of rows will vary. If the data occurs more then one time i want to be informed about it in another sheet. I want to know which rows that are "infected" and the value in col A. Like this:


sheet 1
A
1 490
2 390
3 700
4 700
5 700
6 600

Then in sheet 2:

Rows Value
3 700
4 700
5 700

Hope someone can help me!

/Masun