How to Delete Duplicate Row Using Formula not Code

**hardeep.kanwar** · 06-22-2009, 04:43 AM

Hi! to Everyone

There are many Software and Add-in 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

Note : I Want to Use Formula or Function

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** · 06-22-2009, 05:08 AM

Originally Posted by Stormseed

How is your data layout ?

See The Attached

**DonkeyOte** · 06-22-2009, 05:11 AM

In cell B2 enter:

=IF(AND(A1=A2,A2=""),"X",1)

Now highlight column B -> F5 -> Special -> Formulas -> uncheck all but Text -> OK -> Edit -> Delete -> choose Entire Row Delete -> then delete formulae from column B

**hardeep.kanwar** · 06-22-2009, 05:15 AM

Originally Posted by DonkeyOte

In cell B2 enter:

=IF(AND(A1=A2,A2=""),"X",1)

Now highlight column B -> F5 -> Special -> Formulas -> uncheck all but Text -> OK -> Edit -> Delete -> choose Entire Row Delete -> then delete formulae from column B

Man You are a Genius!

Thanks Sir,

Brilliant!