Excel: Formula or VBA help!!!

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
Any help is appreciated. Thank you in advance!!!! [TR] [TD][TABLE="width: 141"] [TR] [TD]Frank, LLC
[TABLE="class: grid, width: 500"]
[/TD] [TD]Residential Lending
[/TD] [TD] $ -
[/TD] [/TR] [TR] [TD]Frank, LLC
[/TD] [TD]Banking
[/TD] [TD] $ 52,793.34
[/TD] [/TR] [TR] [TD]Frank, LLC
[/TD] [TD]Lending
[/TD] [TD] $ 6,395,507.27
[/TD] [/TR] [/TABLE] [/TD] [/TR] [/TABLE]

This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of September 26, 2014.

For more resources for Microsoft Excel