Most valuable professional
  • Hot Topics

Excel Formula or VBA help!!!

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: 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!!!! Frank, LLC Frank, LLC Frank, LLC

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel