Reverse numerical values
 

If I had a spreadsheet with numerical values down one column, integers
between 1 and 9. I want to be able to "reverse" each number so that 1
will become 9, 2 becomes 8, 3 becomes 7, etc, down to 9 becoming 1.

It's so that I can analyse a survey where people have been asked to
give a 1 for their first choice, 2 for their second choice etc.
Sometimes they have 6 choices, sometimes 9, sometimes 5 depending on
the question. Blanks not filled in get zero. I'm allocating 9 points
to the 1st choice, 8 points to the second choice etc, then adding them
up. Maximum points is the most popular.

Is there a formula you can think of that would do the reversing
automatically? Or something in the Paste Special that would work?

Steve Wylie
United Kingdom

Reverse numerical values
 

Steve,

Try

=ABS(10-A1)

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
If I had a spreadsheet with numerical values down one column, integers
between 1 and 9. I want to be able to "reverse" each number so that 1
will become 9, 2 becomes 8, 3 becomes 7, etc, down to 9 becoming 1.

It's so that I can analyse a survey where people have been asked to
give a 1 for their first choice, 2 for their second choice etc.
Sometimes they have 6 choices, sometimes 9, sometimes 5 depending on
the question. Blanks not filled in get zero. I'm allocating 9 points
to the 1st choice, 8 points to the second choice etc, then adding them
up. Maximum points is the most popular.

Is there a formula you can think of that would do the reversing
automatically? Or something in the Paste Special that would work?

Steve Wylie
United Kingdom

Reverse numerical values
 

Here is soln.

https://oncourse.iu.edu/access/conte...bau/answer.xls

Cr

Reverse numerical values
 

=10-your number
--
Gary's Student


" wrote:

If I had a spreadsheet with numerical values down one column, integers
between 1 and 9. I want to be able to "reverse" each number so that 1
will become 9, 2 becomes 8, 3 becomes 7, etc, down to 9 becoming 1.

It's so that I can analyse a survey where people have been asked to
give a 1 for their first choice, 2 for their second choice etc.
Sometimes they have 6 choices, sometimes 9, sometimes 5 depending on
the question. Blanks not filled in get zero. I'm allocating 9 points
to the 1st choice, 8 points to the second choice etc, then adding them
up. Maximum points is the most popular.

Is there a formula you can think of that would do the reversing
automatically? Or something in the Paste Special that would work?

Steve Wylie
United Kingdom

Reverse numerical values
 

Thanks very much C. Roenbaugh and others - this is just what I wanted.

Steve