CODEWITHSUNDEEP
excel
Mr.Riply
Mr.Riply

Reputation: 845

removing duplicate values from a column

I am having trouble removing duplicate values from a column, I would usually do this in python but I don't have access to the environment unfortunately.

I cant figure out how to remove duplicate values from this column.

DIR
Output
Output
Input
Output
Input
Input
Input
Input
Output

I need to remove the Output from the column and leave that place empty, so ideally the end result would look like this

DIR


Input

Input
Input
Input
Input

Thank you very much, I know this is a noob question, please forgive :)

Upvotes: 1

Views: 79

Answers (1)

zipa
zipa

Reputation: 27869

Select your data range and press Ctrl + F then click replace tab.

There you should insert the word Output and click Replace All enter image description here

Upvotes: 2

Related Questions