Loop with two statements

**elmnas** · 10-25-2016, 04:51 AM

Hello everyone!

I have got a excel file that looks the one below:

https://i.imgur.com/erW3inj.png

Now I need a loop that check each cell in Column "H", if there is two cells in column "H" that matches each other (in this case Cell 1 and Cell 6).
Check in Column "i" if there is any data in any of these cells, remove the cell that have no data in Column "i".See result result below:

https://i.imgur.com/MnaTwLe.png

Could someone help me with this?

Thank you in advance

**TMS** · 10-25-2016, 05:20 AM

You don't really need VBA. You could add a Helper column with a COUNTIF formula against column H. Filter the Helper column on >1 and the other column on blanks. Delete visible rows.

**elmnas** · 10-25-2016, 06:12 AM

I have already a VBA macro I need to implement the loop inside.

That's why it need to be VBA.

**TMS** · 10-25-2016, 07:22 AM

Ok, but rather than loop, add the Helper column in code and filter and delete in code

**elmnas** · 10-25-2016, 08:34 AM

Hi @TMS,

Could you please help me with a code snippet for this?

Thank you a lot in advance.

**JOHN H. DAVIS** · 10-25-2016, 08:39 AM

FWIW:

Please Login or Register  to view this content.

Loop with two statements

LinkBack

Thread Tools

Rate This Thread

Display

Loop with two statements

Re: Loop with two statements

Re: Loop with two statements

Re: Loop with two statements

Re: Loop with two statements

Re: Loop with two statements

Thread Information

Users Browsing this Thread

Similar Threads

New to Macros - Looking for help with simple loop statements

[SOLVED] For loop with mulitple if statements.

Repeat or Loop VBA Statements

Scrape XML with loop and if-then statements

How do I simulate a loop of if statements in excel?

VBA Syntax to loop and do if then else statements

VBA Do...Loop Statements

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions