Thread: How to reverse code data (1=5, 2=4, etc.)?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jhk150 jhk150 is offline
external usenet poster
  
Posts: 2
Default 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 QuoteReply With Quote