Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |