DELETED_5350

wesimmo · 30 Nov 2017 at 18:24

smoove said:
I have a range of numbers ranging from 0 to 48 in rows.

48 being excellent and 0 being bad.

I want to reverse this:

0 to 48
1 to 47
2 to 46 etc

Anyone know how I would do this?

Thanks

Er, just take the current value away from 48?

4K8KW10 · 30 Nov 2017 at 18:57

http://www.makeuseof.com/tag/excel-quick-tips-flip-cells-switch-rows-columns/

Participant · 30 Nov 2017 at 20:04

wesimmo said:
Er, just take the current value away from 48?

LOL this op

dl8860 · 30 Nov 2017 at 22:33

=48-[corresponding cell]

Participant · 1 Dec 2017 at 05:58

smoove said:
Yeah thanks, i was just over thinking this lol.

Hmm yes that's one way of looking at it

.

dirtychinchilla · 1 Dec 2017 at 11:46

Thinking is an interesting word

4K8KW10 · 1 Dec 2017 at 16:37

dl8860 said:
=48-[corresponding cell]

Even though this will lead to a solution, I'm afraid that at more serious examination, it won't be considered as the true answer

gpuerrilla · 1 Dec 2017 at 18:21

Exelent.