Colorado Nesties
Dear Community,
Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Substituting/Replacing/Reversing in Excel
Is there a way to swap values in a rating scale in an Excel spreadsheet? Like, participants scored something from 1 to 6, with 1 being low and 6 being high. But I want to change all the 1's to 6's, the 2's to 5's, the 3's to 4's, the 4's to 3's, the 5's to 2's, and the 6's to 1's. Find and Replace doesn't work because once it changes the 1's to 6's, then later it wants to goes back and find the 6's (that used to be 1's) back into 1's. Does that make sense? Can you do a find and replace all at once? Or is there some other formula (vlookup, substitute, etc) that does this?
Re: Substituting/Replacing/Reversing in Excel
I'd probably find/replace twice-
So, change the 1s to 12s and then the 6s to 1s and then the 12s to 6s, and so on.
Ditto.
Actually, instead of changing to another number, I'd do a letter. But, you get the idea.
Maybe I'm not understanding this correctly but I thought this is what I did. I did a F&R 6 times essentially. I changed 1's to 6's, 2's to 5's, and so on but then when I get to change the 6's to 1's, it changes all the current 6's (some of which used to be 1's but that I just changed into 6's) back into 1's. Maybe I'm not explaining it right. Argh, head hurts!
ETA: so there is no formula that will essentially "sawp/reverse" a rating scale (like 1 to 6) like that?
Yeah, the idea is that you want to change the things that will be duplicated to something entirely different. So your list looks like this:
1
1
1
2
2
2
3
3
3
and then, you change the 1s to As:
A
A
A
2
2
2
3
3
3
and then the 3s to 1s:
A
A
A
2
2
2
1
1
1
and then the As to 3s
3
3
3
2
2
2
1
1
1