What are you doing RIGHT NOW???
Options
Replies
-
subcounter wrote: »subcounter wrote: »@subcounter okay another question: I have data for 3 timepoints, and I just made a column for pre, one for post, and one for follow-up, but they told me that all the datapoints within those columns need to be labeled with _pre, _post, and _fu before/after each variable name. Is there a way to not do that individually?
Hmm something like:
=CONCATENATE("Food - ",A1)
=Concatenate (A1, " - Fruit")
=Concatenate ("Food - ", A1, " - Fruit")
Depending on which side, just drag them down. Try them all to see which one you want, obviously change the names of Food and Fruit with _pre _post _fu
okay I can't figure that one out haha. thanks for trying though
Hmm like, paste the "code" I wrote on to the next cell of the data points you're trying to change, then simply double click the bottom right, or drag them down, it will change the whole data on the new cell. Then you can copy/paste the data.
I got it! I used your instructions, but google had more dumbed-down instructionsThank you!
Good, was about to remote control your PC.Lol its worse when you get to VBA codes of excel.
1 -
working, and reading your comments between phone calls0
-
subcounter wrote: »subcounter wrote: »@subcounter okay another question: I have data for 3 timepoints, and I just made a column for pre, one for post, and one for follow-up, but they told me that all the datapoints within those columns need to be labeled with _pre, _post, and _fu before/after each variable name. Is there a way to not do that individually?
Hmm something like:
=CONCATENATE("Food - ",A1)
=Concatenate (A1, " - Fruit")
=Concatenate ("Food - ", A1, " - Fruit")
Depending on which side, just drag them down. Try them all to see which one you want, obviously change the names of Food and Fruit with _pre _post _fu
okay I can't figure that one out haha. thanks for trying though
Hmm like, paste the "code" I wrote on to the next cell of the data points you're trying to change, then simply double click the bottom right, or drag them down, it will change the whole data on the new cell. Then you can copy/paste the data.
Dude dude..... this tech support is currency ..... you should trade it for a couple of newd bewb pics from her!!3 -
TheCounselorx wrote: »subcounter wrote: »subcounter wrote: »@subcounter okay another question: I have data for 3 timepoints, and I just made a column for pre, one for post, and one for follow-up, but they told me that all the datapoints within those columns need to be labeled with _pre, _post, and _fu before/after each variable name. Is there a way to not do that individually?
Hmm something like:
=CONCATENATE("Food - ",A1)
=Concatenate (A1, " - Fruit")
=Concatenate ("Food - ", A1, " - Fruit")
Depending on which side, just drag them down. Try them all to see which one you want, obviously change the names of Food and Fruit with _pre _post _fu
okay I can't figure that one out haha. thanks for trying though
Hmm like, paste the "code" I wrote on to the next cell of the data points you're trying to change, then simply double click the bottom right, or drag them down, it will change the whole data on the new cell. Then you can copy/paste the data.
Dude dude..... this tech support is currency ..... you should trade it for a couple of newd bewb pics from her!!
Considering this probably saved me several hours of work today, I'd pay up lol1 -
TheCounselorx wrote: »subcounter wrote: »subcounter wrote: »@subcounter okay another question: I have data for 3 timepoints, and I just made a column for pre, one for post, and one for follow-up, but they told me that all the datapoints within those columns need to be labeled with _pre, _post, and _fu before/after each variable name. Is there a way to not do that individually?
Hmm something like:
=CONCATENATE("Food - ",A1)
=Concatenate (A1, " - Fruit")
=Concatenate ("Food - ", A1, " - Fruit")
Depending on which side, just drag them down. Try them all to see which one you want, obviously change the names of Food and Fruit with _pre _post _fu
okay I can't figure that one out haha. thanks for trying though
Hmm like, paste the "code" I wrote on to the next cell of the data points you're trying to change, then simply double click the bottom right, or drag them down, it will change the whole data on the new cell. Then you can copy/paste the data.
Dude dude..... this tech support is currency ..... you should trade it for a couple of newd bewb pics from her!!
Considering this probably saved me several hours of work today, I'd pay up lol1 -
TheCounselorx wrote: »subcounter wrote: »subcounter wrote: »@subcounter okay another question: I have data for 3 timepoints, and I just made a column for pre, one for post, and one for follow-up, but they told me that all the datapoints within those columns need to be labeled with _pre, _post, and _fu before/after each variable name. Is there a way to not do that individually?
Hmm something like:
=CONCATENATE("Food - ",A1)
=Concatenate (A1, " - Fruit")
=Concatenate ("Food - ", A1, " - Fruit")
Depending on which side, just drag them down. Try them all to see which one you want, obviously change the names of Food and Fruit with _pre _post _fu
okay I can't figure that one out haha. thanks for trying though
Hmm like, paste the "code" I wrote on to the next cell of the data points you're trying to change, then simply double click the bottom right, or drag them down, it will change the whole data on the new cell. Then you can copy/paste the data.
Dude dude..... this tech support is currency ..... you should trade it for a couple of newd bewb pics from her!!
Considering this probably saved me several hours of work today, I'd pay up lol
If you press Alt and Tab.... you'll be able to quickly jump from one window to another...... does that qualify??? .... maybe?....1 -
listening to the boy figuring out a song on the piano1
-
Attempting to feed this monster his lunch. It has been a DAY.0
-
Just finished legs.. Bout to do abs...
Mfp'n between sets while climbing on the treadmill...1 -
Now I'm figuring out the songs...anyone wanna learn how to play Pokemon Sun & Moon Kahuna Battle music?0
-
TheCounselorx wrote: »subcounter wrote: »subcounter wrote: »@subcounter okay another question: I have data for 3 timepoints, and I just made a column for pre, one for post, and one for follow-up, but they told me that all the datapoints within those columns need to be labeled with _pre, _post, and _fu before/after each variable name. Is there a way to not do that individually?
Hmm something like:
=CONCATENATE("Food - ",A1)
=Concatenate (A1, " - Fruit")
=Concatenate ("Food - ", A1, " - Fruit")
Depending on which side, just drag them down. Try them all to see which one you want, obviously change the names of Food and Fruit with _pre _post _fu
okay I can't figure that one out haha. thanks for trying though
Hmm like, paste the "code" I wrote on to the next cell of the data points you're trying to change, then simply double click the bottom right, or drag them down, it will change the whole data on the new cell. Then you can copy/paste the data.
Dude dude..... this tech support is currency ..... you should trade it for a couple of newd bewb pics from her!!
Considering this probably saved me several hours of work today, I'd pay up lol
lol just the fact that it saved hours is good enough for me.2 -
Just watched this week's Walking Dead, was shite.0
-
bein hungry1
-
Chillin with DH and DS.0
-
Finally eating!1
-
-
Feeling all sassy like this about current rl boy situation lol
And watching my best friend play Uncharted 4 and get wing sauce on my PS4 remote0 -
-
Listening to Defying Gravity and belting it out like I know how and the kid isn't napping.0
-
Contemplating goofing off for the last hour of work. I did put in 7 good hours...0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392.1K Introduce Yourself
- 43.6K Getting Started
- 259.9K Health and Weight Loss
- 175.7K Food and Nutrition
- 47.4K Recipes
- 232.4K Fitness and Exercise
- 403 Sleep, Mindfulness and Overall Wellness
- 6.4K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.8K Motivation and Support
- 7.9K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.4K MyFitnessPal Information
- 23 News and Announcements
- 999 Feature Suggestions and Ideas
- 2.4K MyFitnessPal Tech Support Questions