View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mommy2kh mommy2kh is offline
external usenet poster
 
Posts: 9
Default What Formula To Use?

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