Hello all! I need heeeeeelp! I thought I was good in Excel until I encounter this problem :banghead: 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
|[TABLE="class: grid, width: 500"]|
This question generated 27 answers. To proceed to the answers, click here.
This thread is current as of September 26, 2014.