Thread: Subtract from X formula?
View Single Post
 
Old 06-25-2019, 12:03 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
1. Into row 1 of some free column enter the formula
Code:
=6-$A1
2. Copy the formula down until row with last entry in column A;
3. Copy all cells with formula. Right-click on cell A1, and select Paste Special and then the option Values from dropdown menu;
4. Delete formulas. It's done!
Reply With Quote