------ Register to get rid of these "In Post" ads! ------


Hi,

You can try this. Assume that the data is in range C3:C11. In cell D3, use
the following formula and copy down till D11:

=IF(COUNTIF(D$2:D2,MATCH(LOOKUP(REPT("z",99),C$3:C3),$C$3:$C$11,0))>=2,"a",MATCH(LOOKUP(REPT("z",99),C$3:C3),$C$3:$C$11,0)).

This will show "a" against all cases where blank rows are more than 1. Now
select range D3:D11 and press F5 > Special. Under the formulas radio
button, select Text. This will highlight all the "a" values. Simply delete
the rows.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"hardeep.kanwar" <hardeep.kanwar.3u688p@thecodecage.com> wrote in message
news:hardeep.kanwar.3u688p@thecodecage.com...
>
> Hi! to Everyone
>
> There are many Software and Addin and Macro or Code to Delete or
> Eliminate the Duplicate Data
>
> But, I want to Delete The Duplicate BLANKS Row.I means to Say that
> Delete Every Repeated Blank row
>
> Example
>
> Hardeep
> Blank
> Renu
> Blank
> Blank
> ABc
> Blank
> DEF
> Blank
> Blank
> Blank
> Now i Want in this format
>
> Hardeep
> Blank
> Renu
> Blank
> ABC
> Blank
> DEF
> Blank
> and so on,
>
>
> Thanks in Advance
>
> Hardeep Kanwar
>
>
> --
> hardeep.kanwar
> ------------------------------------------------------------------------
> hardeep.kanwar's Profile:
> http://www.thecodecage.com/forumz/members/hardeep-kanwar.html
> View this thread:
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/worksheet-functions/108814-delet-duplicate-blanks-rows.html#post389360
> Delet Duplicate Blanks rows
>