Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
process of elimination of duplicate information
i want to delete side by side cells that have the same information and leave
the single entre information cells. cell 1 = 123 cell 2 = 456 cell 3 = 123 cell 4 = 456 cell 5 = 789 cell 1,2,3,4 would be eliminated and only cell 5 would remain. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
process of elimination of duplicate information
Manny
If you use a helper column alongside your current data and enter =COUNTIF($A$1:$A$1000,=A1) This assumes you data is in A1:A1000, this will put a number greater than 1 alongside all the dupes, you can then filter or sort by that and delete -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Manny" wrote in message ... i want to delete side by side cells that have the same information and leave the single entre information cells. cell 1 = 123 cell 2 = 456 cell 3 = 123 cell 4 = 456 cell 5 = 789 cell 1,2,3,4 would be eliminated and only cell 5 would remain. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
process of elimination of duplicate information
WHAT IS A HELPER COLUMN? DO I PUT THE FORMULA IN COLUMN A?
"Nick Hodge" wrote: Manny If you use a helper column alongside your current data and enter =COUNTIF($A$1:$A$1000,=A1) This assumes you data is in A1:A1000, this will put a number greater than 1 alongside all the dupes, you can then filter or sort by that and delete -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Manny" wrote in message ... i want to delete side by side cells that have the same information and leave the single entre information cells. cell 1 = 123 cell 2 = 456 cell 3 = 123 cell 4 = 456 cell 5 = 789 cell 1,2,3,4 would be eliminated and only cell 5 would remain. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
process of elimination of duplicate information
Select column B
Insert a new column (it'll be a new column B) Put the formula in B1 and drag down as far as you need it. But use this modified formula: =COUNTIF($A$1:$A$1000,A1) A helper column is just a column that you're gonna use to help you find the answer you want. For me, I usually insert my helper column right next to what I want to use. But you can do insert that column whereever you want--to the far right if you want it out of the way. Manny wrote: WHAT IS A HELPER COLUMN? DO I PUT THE FORMULA IN COLUMN A? "Nick Hodge" wrote: Manny If you use a helper column alongside your current data and enter =COUNTIF($A$1:$A$1000,=A1) This assumes you data is in A1:A1000, this will put a number greater than 1 alongside all the dupes, you can then filter or sort by that and delete -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Manny" wrote in message ... i want to delete side by side cells that have the same information and leave the single entre information cells. cell 1 = 123 cell 2 = 456 cell 3 = 123 cell 4 = 456 cell 5 = 789 cell 1,2,3,4 would be eliminated and only cell 5 would remain. Thank you. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Migrating Information | Excel Discussion (Misc queries) | |||
How does one sort a block of inter-related information in Excel? | Excel Worksheet Functions | |||
Required Information | Excel Discussion (Misc queries) | |||
Entering information from 1 worksheet to another, if criteria is m | Excel Discussion (Misc queries) | |||
add information from two columns | Excel Discussion (Misc queries) |