loop with 2 conditions

[vranjit138]

A B
Inv6542
Inv6542


Inv6541
Inv6541
Inv6541

Inv6543
Inv6543
Inv6543

In column i have data upto A11636 . Iam required to delete all the blanks in column A and then column b should show the count of the invoice numbers

I wanted to know can this be done using for Each... next loop

Please advise

Regards
Ranjit

 

[SteveO59L]

Dont need a loop, just sort col A

 

[ravishankar]

Hi
To delete blank cells, select col A > Edit > Goto > Special > Blank > OK
Edit (again) > delete >shift cells up.
Check your other thread (http://www.mrexcel.com/board2/viewtopic.php?p=1370522&highlight=#1370522) for countif and for - next loop
Ravi