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 |
What Formula To Use?
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 "mommy2kh" wrote in message ... 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 |
What Formula To Use?
On Mar 6, 5:38 pm, mommy2kh
wrote: 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 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 |
All times are GMT +1. The time now is 11:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com