If your numbers are in Col A then enter this in B1 and copy down
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

This will leave only one instance of each number... Copy and past special as
values and then filter out the blank rows...

You can also use Data-Filter-Advanced Filter and choose 'Unique Values
only'....

"Salman" wrote:

Please help. If I have few numbers in a column and I want to delete pairs eg
following should only show 5+4 = 9 (ie delete/cancel off what makes a pair):
5
5
5
5
5
4
4
4

Thanks in advance.