ExcelBanter - Is there a way to retain a formula while performing cut/paste?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Is there a way to retain a formula while performing cut/paste? (https://www.excelbanter.com/excel-worksheet-functions/22262-there-way-retain-formula-while-performing-cut-paste.html)

Earl

Is there a way to retain a formula while performing cut/paste?

Is there a way to retain a formula in column (3) (Proj. No. under
'Comparison') below while performing cut/paste?

If so, what would the formula be to place an asterisk on each side of the
data if it is not equal to the data in column (1) ?

Original Comparison
Proj. No. Proj. Desc. Proj. No. Proj. Desc.
02-03 xxxxx ???? ?????
02-14 yyyyyy
03-23 zzzzzz

TIA

Earl

Earl

Anybody? Please help.

"Earl" wrote:

Is there a way to retain a formula in column (3) (Proj. No. under
'Comparison') below while performing cut/paste?

If so, what would the formula be to place an asterisk on each side of the
data if it is not equal to the data in column (1) ?

Original Comparison
Proj. No. Proj. Desc. Proj. No. Proj. Desc.
02-03 xxxxx ???? ?????
02-14 yyyyyy
03-23 zzzzzz

TIA

Earl

All times are GMT +1. The time now is 04:07 PM.