Posted to microsoft.public.excel.misc

jhk150

external usenet poster

Posts: 2

How to reverse code data (1=5, 2=4, etc.)?

I have data sets in only certain columns of my spread sheet that need to be
reverse coded, i.e. 1=5, 2=4, 3=3, 4=2, 5=1 . How do I get these new values
in Excel?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reverse Order of Data Set	Bekah1st	Excel Worksheet Functions	4	May 13th 23 03:46 AM
Can I reverse the order of data in a set of cells?	salwitt	Excel Discussion (Misc queries)	3	October 24th 05 11:14 PM
reverse data	megsie jack	Excel Discussion (Misc queries)	1	September 30th 05 06:00 AM
Reverse Data from bottom to top	Joman	Excel Discussion (Misc queries)	2	August 16th 05 03:30 PM
DATA VALIDATION IN REVERSE	Wayne	Excel Discussion (Misc queries)	3	March 22nd 05 12:29 PM

All times are GMT +1. The time now is 10:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us