What Formula To Use?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Insert a new blank column B, then use this formula in cell B2:

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

and copy down to match you column of data in A

HTH,
Bernie
MS Excel MVP
 
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

Excel Help to copy information from one row at a time to another sheet 1
Scrabble Value calculation for Welsh words 0
Average non-consecutive cells excluding zero 8
Complex 2 table formula 4
Lookup Formula 4
What is the "--" (double dash) in MS Excel formula? 2
COUNTIF 2
Match and delete rows on two different sheets from reference numbers 4

Back
Top