What Formula To Use?

M

mommy2kh

I've got a series of values. If there are two values together, I want to
delete the second one. Using the example below, I would want to keep the
value $58.00 and delete the value $60.00. All the other values in the column
that I want to keep (such as the $51 and $12) have a blank cell before and
after it. Any ideas? Thanks!!
A
row 1
row 2 $51.00
row 3
row 4 $12.00
row 5
row 6 $58.00
row 7 $60.00
row 8
 
V

vezerid

I've got a series of values. If there are two values together, I want to
delete the second one. Using the example below, I would want to keep the
value $58.00 and delete the value $60.00. All the other values in the column
that I want to keep (such as the $51 and $12) have a blank cell before and
after it. Any ideas? Thanks!!
A
row 1
row 2 $51.00
row 3
row 4 $12.00
row 5
row 6 $58.00
row 7 $60.00
row 8
Click to expand...

Maybe...
In B2 enter:

=IF(A1="",A2,"")

Copy the formula all the way down. Copy all cells in B:B, and Edit|
Paste Special... select Values.

Does this help?
Kostis Vezerides
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Look Up Formula With Veried Search Range 2
Tricky one 1
Rearranging Data 0
Index/Match Functions to Return Concatenated Response 4
Excel VBA macro, search - accumulate - delete original 0
Match and delete rows on two different sheets from reference numbers 4
Arriving at totals 2

Top