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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I retain a formula in the cell pasted to? 1
How do I set up a formula to give me an average based on IF? 1
Help Creating A Formula To Cut and Paste Text 7
Is there a way to use Formula to resolve 5
Is there any way to auto-insert a row? 4
Is there an Excel formula to show the highest letter in a row? 1
Is there a way to use a multiple column array in SUMPRODUCT? 2
Cut-and-paste problem 1

Back
Top