help me to write formula

  • Thread starter Thread starter excelbee
  • Start date Start date
E

excelbee

I have values like 7,4,3,4,7 in a given column.
How to avoid duplicates from this?
It has to show only 7,4,3.

Please help.

thanks in advance
 
This request is half baked. I presume your input is a column of numbers.
What do you want your output to be? Where does it get put?

To be truly a solution, you probably need a macro. When I need such
modest requirements, I just sort the column and look for where two
adjacent cell in the column differ. Take care of the first and last cell.
Click to expand...
free ASAP Utilities has a function to eliminate dupkicates
 
Back
Top