Hello all!
I need heeeeeelp! I thought I was good in Excel until I encounter this problem I'm trying to create a formula or if possible a VBA script that fulfills 3 conditions.
Let's say we have the table below, and what we need is to:
Any help is appreciated. Thank you in advance!!!!
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
I need heeeeeelp! I thought I was good in Excel until I encounter this problem I'm trying to create a formula or if possible a VBA script that fulfills 3 conditions.
Let's say we have the table below, and what we need is to:
- if a Name in column 1 appears more than once AND in the 2nd column appears "Residential Lending," then Remove All Rows Above and/or Below where the Same Name appears more than once
- if in column 2 appears banking but in column 1 the same name appears more than once Above or Below, then leave as is
- Else leave As Is
Any help is appreciated. Thank you in advance!!!!
<TBODY> </TBODY> | </SPAN> | |||||||||||||||||||
</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>