Convert Formula Result
I am using the following formul
=IF(A1=A2,B2,"") I want to be able to delete Row 2. How can I get the results of the formula into a cell as a value and not a formula. Thanks. |
After using the formula to display values, you can copy the cell or range of
cells and then Edit/PastSpecial/Values. Alok "Christina" wrote: I am using the following formul =IF(A1=A2,B2,"") I want to be able to delete Row 2. How can I get the results of the formula into a cell as a value and not a formula. Thanks. |
Thank You!!!! c
"Alok" wrote: After using the formula to display values, you can copy the cell or range of cells and then Edit/PastSpecial/Values. Alok "Christina" wrote: I am using the following formul =IF(A1=A2,B2,"") I want to be able to delete Row 2. How can I get the results of the formula into a cell as a value and not a formula. Thanks. |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com