Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating non-matching cells
How do I eliminate the cells in COL A whose contents do NOT match the
contents of the cells in COL C. For the matching cells, I also need to know the contents of the cells in COL B. A B C 101170041-1 101180013-7 101170042-2 Y 101200001-7 101170043-3 101200004-0 101180013-7 A 101200005-1 101180014-8 Y 101200006-2 101180015-9 Y 101200007-3 101180016-0 C 101200008-4 101180017-1 C 101200009-5 101180018-2 C 101180020-3 Y 101180021-4 C 101180033-5 C 101190029-3 Y 101190034-7 Y 101190048-0 101190060-0 Y 101190064-4 101200001-7 Y 101200004-0 Y 101200005-1 Y 101200006-2 Y 101200007-3 Y 101200008-4 A 101200009-5 Y 101200010-5 Y 101200011-6 Y 101200012-7 Y 101210001-8 C 101210003-0 A 101210004-1 A 101210010-6 A 101210011-7 A |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating non-matching cells
Please don't crosspost. You just placed the same question to
microsoft.public.excel. JM "gary" wrote in message ... How do I eliminate the cells in COL A whose contents do NOT match the contents of the cells in COL C. For the matching cells, I also need to know the contents of the cells in COL B. A B C 101170041-1 101180013-7 101170042-2 Y 101200001-7 101170043-3 101200004-0 101180013-7 A 101200005-1 101180014-8 Y 101200006-2 101180015-9 Y 101200007-3 101180016-0 C 101200008-4 101180017-1 C 101200009-5 101180018-2 C 101180020-3 Y 101180021-4 C 101180033-5 C 101190029-3 Y 101190034-7 Y 101190048-0 101190060-0 Y 101190064-4 101200001-7 Y 101200004-0 Y 101200005-1 Y 101200006-2 Y 101200007-3 Y 101200008-4 A 101200009-5 Y 101200010-5 Y 101200011-6 Y 101200012-7 Y 101210001-8 C 101210003-0 A 101210004-1 A 101210010-6 A 101210011-7 A |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating non-matching cells
Already the third time this question is appearing.
Instead of doing this, provide more details about the problem since it's not clear to me. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Joerg Mochikun" wrote: Please don't crosspost. You just placed the same question to microsoft.public.excel. JM "gary" wrote in message ... How do I eliminate the cells in COL A whose contents do NOT match the contents of the cells in COL C. For the matching cells, I also need to know the contents of the cells in COL B. A B C 101170041-1 101180013-7 101170042-2 Y 101200001-7 101170043-3 101200004-0 101180013-7 A 101200005-1 101180014-8 Y 101200006-2 101180015-9 Y 101200007-3 101180016-0 C 101200008-4 101180017-1 C 101200009-5 101180018-2 C 101180020-3 Y 101180021-4 C 101180033-5 C 101190029-3 Y 101190034-7 Y 101190048-0 101190060-0 Y 101190064-4 101200001-7 Y 101200004-0 Y 101200005-1 Y 101200006-2 Y 101200007-3 Y 101200008-4 A 101200009-5 Y 101200010-5 Y 101200011-6 Y 101200012-7 Y 101210001-8 C 101210003-0 A 101210004-1 A 101210010-6 A 101210011-7 A |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating non-matching cells
Sorry for the multiple posts.
If, after posting a question to a group (like microsoft.public.excel), I find another, more-appropriate group (like microsoft.public.excel.programming), I'll post the question in the new group. Sometimes, I forget to remove the original posting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging cells and eliminating spaces for empty cells | Excel Discussion (Misc queries) | |||
Eliminating cells with a zero | Excel Worksheet Functions | |||
Eliminating blank cells | Excel Worksheet Functions | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Eliminating blank cells in a list on a ROW | Excel Worksheet Functions |