help me to write formula

[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

 

[James Ravenswood]

Would you like to remove duplicate data or hide duplicates with a filter?

 

[Salmon Egg]

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.

--

Sam

Conservatives are against Darwinism but for natural selection.
Liberals are for Darwinism but totally against any selection.

 

[Zaidy036]

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.

free ASAP Utilities has a function to eliminate dupkicates