Formula or VBA help!!!

[Luchano]

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:

1. 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
2. if in column 2 appears banking but in column 1 the same name appears more than once Above or Below, then leave as is
3. Else leave As Is

Any help is appreciated. Thank you in advance!!!!

Frank, LLC</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> Residential Lending</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> $ - </SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> Frank, LLC</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> Banking</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> $ 52,793.34 </SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> Frank, LLC</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> Lending</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> $ 6,395,507.27 </SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> <TBODY> </TBODY>	</SPAN>
		</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

 

[oldbrewer]

I want a very clear statement of what you are trying to do, with a data table before and a modified table after your rules have been applied.

 

[ztodd]

Thanks for the reply!

Not quite though.
Using that approach I would be getting rid of banking and residential, and if the client has more than one acctount, then my data would still have the other client's acccounts.

That's not what I designed it to do... now, I didn't test it, but I'm curious if you tested it or not- or are you just making assumptions about what it will do?

 

[oldbrewer]

ztodd - I am not the OP

 

[ztodd]

ztodd - I am not the OP

I'm not sure why you said that... did you think I was replying to you? I was replying to Luchano- After all, I did quote him.

 

[oldbrewer]

ok sorry ztodd - I forgot you put the quote in at the front of your post.

 

[Luchano]

I'm sorry ztodd, but I when I tested the formula I was doing something wrong. BUT you're absolutely right, it works like a charm! THANK YOU!!!!

 

[ztodd]

No problem- glad it works for you!