| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find a value and delete that row | Excel Discussion (Misc queries) | |||
| How to find the lowest number of a row and delete it automatically | Excel Discussion (Misc queries) | |||
| Help me please. How do I delete custom number formats? in Excel | Excel Discussion (Misc queries) | |||
| How delete formula bar and retain the computed number in a cell? | Excel Worksheet Functions | |||
| delete a number within larger number in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
