sorting Id for unique records

Hi Everybody

i have a problem in Excel 2010

For example my sheet is like that. i have coped it from other sheet .

Id Name

1 Turan
1 Turan
1 Turan
2 Roma
2 Roma
2 Roma
3 Qarabagh Azeri
3 Qarabagh Azeri

now i would like to create formula or other for not reapet "Id"
like that

Id Name

1 Turan
2 Roma
3 Qarabagh Azeri

Please help me...thanks in advance

You can do this without formulas, using Advanced Filter.

Assuming your data is in Sheet1, A1:B9:

Go to Sheet2, A1, and then go to Data menu, select Advanced from the Sort & Filter section.

Click the icon to the right of the blank List Range field, then go to Sheet1 and select A1:B9

Select Copy to Another Location button from top... enter cell A1 of Sheet2 in the Copy to field.

Then check the Unique Records Only box, and click Finish.

That's it.

If you have to have a formula, then in Sheet2 enter the same headers (Id and Name) in Row 1.

Then in A2 of Sheet2 enter formula:

Please Login or Register  to view this content.

copied down as far as you need to get all unique data and then copy to next column over.

Adjust ranges to suit.