CODEWITHSUNDEEP
excel
Alex
Alex

Reputation: 5685

Change value for multiple cells in Excel

If I have an Excel sheet with lets say 2 columns Name | Age, and in the Name column I have some 2000 entries and some of them repeat more than once in a random order, how can I populate the Age column inserting the value only once for each unique record from the Name column?

Excel noobie, so sorry if the question seems stupid.

Thanks!

Upvotes: 1

Views: 1051

Answers (2)

Alex
Alex

Reputation: 5685

Solved with pivot tables and VLOOKUP!

Upvotes: 1

iDevlop
iDevlop

Reputation: 25262

One solution could be to use the advanced filter to copy unique values.
Alternatively you could use a countif() to identify the duplicates.
Sorting by name could also be of help.

Upvotes: 0

Related Questions