How do I eliminate duplicate values in cells?
I have a column with the following values:
20
20
30
30
50
60
60
60
90
90
100
How do i eliminate the values that repeat in such a way that the table looks like this:
20
30
50
60
90
100
Namely, how do i make excel only recognize the first value that repeats, and replaces the other duplicate values with a blank cell.
Please help me, and also, what exactly does the "lookup" function do?
I have a column with the following values:
20
20
30
30
50
60
60
60
90
90
100
How do i eliminate the values that repeat in such a way that the table looks like this:
20
30
50
60
90
100
Namely, how do i make excel only recognize the first value that repeats, and replaces the other duplicate values with a blank cell.
Please help me, and also, what exactly does the "lookup" function do?