I have an Excel sheet holding four columns, each containing a number between 1 and 10. The first two columns contain proper values, however, column three and four do not. Instead, they contain inverse values due to a mistake in data collection. I would like to invert the values once more in order to adjust for the mistake. An example would be a cell holding the value 7, which should be 3, as the limit is 10. In similar fashion, the number 3 should be inverted to 7 and so forth. How would I go about in order to achieve this result for a whole column?

  • 3
    In a new Column E, enter =10-C1 in E1. Also enter =10-D1 in F1. Fill both of those formulas down as far as necessary. If you want to then eliminate Columns C & D, first copy Columns E & F and choose "Paste Special...", selecting "Values" in the dialog box. Check that the formulas are gone in E & F and that they contain only the correct data values. Then you can delete Columns C & D. – Bandersnatch Aug 17 '17 at 20:11
  • This solved my problem. I sure feel dumb, considering how easy it was. Anyway, thank you! – MihkelPajunen Aug 17 '17 at 20:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.