how can i find samelest number and delete them
 

hi,
i have multi rows with numbers, what i need is to compare between them and
the same numbers will be deleted
thx.

how can i find samelest number and delete them
 

One or many COLUMNS?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ghost" wrote in message
...
hi,
i have multi rows with numbers, what i need is to compare between them and
the same numbers will be deleted
thx.

how can i find samelest number and delete them
 

many

"Bernard Liengme" wrote:

One or many COLUMNS?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ghost" wrote in message
...
hi,
i have multi rows with numbers, what i need is to compare between them and
the same numbers will be deleted
thx.

how can i find samelest number and delete them
 

Suppose you numbers are in A1:C20
In E1 enter =IF(COUNTIF($A$1:$C$20,A1)1,A1,"")
Copy this across to G1 and then copy E1:G1 down to row 20
If a number in A1:C20 is unique the corresponding cell in E1:G20 will be
blank, otherwise it will display the number
Something to get started with?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
One or many COLUMNS?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ghost" wrote in message
...
hi,
i have multi rows with numbers, what i need is to compare between them
and
the same numbers will be deleted
thx.

how can i find samelest number and delete them
 

hi,
i did it but there is nonthing change
should i change any name of the cells in the funcetion
IF(COUNTIF($A$1:$C$20,A1)1,A1,"")
"Bernard Liengme" wrote:

Suppose you numbers are in A1:C20
In E1 enter =IF(COUNTIF($A$1:$C$20,A1)1,A1,"")
Copy this across to G1 and then copy E1:G1 down to row 20
If a number in A1:C20 is unique the corresponding cell in E1:G20 will be
blank, otherwise it will display the number
Something to get started with?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
One or many COLUMNS?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ghost" wrote in message
...
hi,
i have multi rows with numbers, what i need is to compare between them
and
the same numbers will be deleted
thx.