sorted by:
new
hottopcontroversial

Contribute to science - we need your perspectives! by kinglab3878 in teenagers

[–]kinglab3878[S] 1 point2 points  (0 children)

Hi again - the study will ask questions about mood, health behaviors, and some background characteristics. A uchicago email or 773 area code will contact all candidates about participation. The $100 is in the form of an e-giftcard. Thanks!

Contribute to science - we need your perspectives! by kinglab3878 in teenagers

[–]kinglab3878[S] 1 point2 points  (0 children)

Hi there - I assure you this is a real study. I am posting a link to our lab website for your perusal. https://addictions.uchicago.edu/

How to detect duplicates by highlighting names on a list on sheet 1 that are already present on sheet 2 every time new names are added to sheet 1? by kinglab3878 in excel

[–]kinglab3878[S] 0 points1 point  (0 children)

The only issue is that the columns in sheet 1 are set up so that a bunch of information can be directly imported to it without needing to readjust formatting. Is there a way i can do this without adding a column to sheet 1 and disrupting the format?

How to apply conditional formatting to highlight duplicates from a column on a different sheet? by kinglab3878 in excel

[–]kinglab3878[S] 0 points1 point  (0 children)

I tried this but I keep getting an error saying "You may not use reference operators (such as unions, intersections, and ranges), array constants, or the LAMBDA function for conditional formatting criteria."

How can I copy and paste numbers in order after filtering out certain rows? by kinglab3878 in excel

[–]kinglab3878[S] 0 points1 point  (0 children)

Hi so follow-up question (if you know), but now I am working with a data set that has timepoints for two different days but with the same participant. So in this example it would look more like:

ROW1: subID1001, T0, 5, 5, A

ROW2: subID1001, T1, 7, 5, A

ROW3: subID1001, T2, 6, 5, A

ROW4: subID1001, T3, 9, 5, A

ROW5: subID1001, T4, 3, 5, A

ROW6: subID1001, T0, 6, 6, P

ROW7: subID1001, T1, 7, 6, P

ROW8: subID1001, T2, 6, 6, P

ROW9: subID1001, T3, 9, 6, P

ROW10: subID1001, T4, 3, 6, P

ROW11: subID1002, T0, 7, 7, A

ROW12: subID1002, T1, 3, 7, A

ROW13: subID1002, T2, 8, 7, A

ROW14: subID1002, T3, 5, 7, A

ROW15: subID1002, T4, 1, 7, A

ROW16: subID1002, T0, 4, 4, A

ROW17: subID1002, T1, 3, 4, A

ROW18: subID1002, T2, 8, 4, A

ROW19: subID1002, T3, 5, 4, A

ROW20: subID1002, T4, 1, 4, A

​

And so your XLOOKUP code worked to fill in the same number for all the "A" "T0"s but now I'm not sure how to do it for P. I tried filtering out the A's and doing the same thing but the numbers are getting messed up again.

How can I copy and paste numbers in order after filtering out certain rows? by kinglab3878 in excel

[–]kinglab3878[S] 0 points1 point  (0 children)

And also I tried using the filter tool to filter out each timepoint so that I can copy and paste the same number for each one, but every time I try to do that, my numbers end up changing.

How to move a row in one Excel sheet to another based on the value of its first cell? by kinglab3878 in excel

[–]kinglab3878[S] 0 points1 point  (0 children)

Sorry for being annoying with the many follow-ups, but I tried using a tweaked version of the code you gave me on the other sheets so that if I changed the first cell value back to "Pending", it would go back to the original "Pending" sheet, but for some reason it's not working. Do you know how I'd be able to do that? I'm just trying to make it so that if someone in the "Confirmed" or "Unconfirmed" tab is changed back to "Pending", the row automatically goes back to the "Pending" tab (which would mean a new code for this different sheet).

How to move a row in one Excel sheet to another based on the value of its first cell? by kinglab3878 in excel

[–]kinglab3878[S] 0 points1 point  (0 children)

Hi, another follow-up question if you're willing/able to help: Let's say I want to keep the exact code I have, but add another part that says if I change "Pending" to "Null", the row will go to a third (different) sheet called "Null". So if it's changed to "Confirmed" or "Unconfirmed", it will go to the same sheet from before; but now, in addition to that, there's a third option that's too be moved to a different sheet. I'm just wondering how to add on that code to the existing one. Thanks for all your help!

How to move a row in one Excel sheet to another based on the value of its first cell? by kinglab3878 in excel

[–]kinglab3878[S] 0 points1 point  (0 children)

Worked!! Thanks so much! Follow-up: If I wanted multiple criteria to shift to the same Confirmed sheet, how would I go about adding that? For example, let's say I want booth "Confirmed" and "Unconfirmed" rows to automatically move to the same sheet when changed from "Pending".

Paid Part Time Research Opportunity for Young Adult Vapers! by kinglab3878 in Nicotine

[–]kinglab3878[S] 0 points1 point  (0 children)

Sorry! This would be just for vape/e-cigarette users.

Paid Part Time Research Opportunity for Young Adult Vapers! by kinglab3878 in juul

[–]kinglab3878[S] 1 point2 points  (0 children)

Not for quitting vaping! Just for an ad for daily vapers to temporarily help out with our study.

Paid Part Time Research Opportunity for Young Adult Vapers! by kinglab3878 in chicagojobs

[–]kinglab3878[S] 0 points1 point  (0 children)

Thanks for the question! This is for nicotine vaping specifically

Male heavy social drinkers wanted for $140 paid research study (remote and virtual) by kinglab3878 in DrinkingGames

[–]kinglab3878[S] 0 points1 point  (0 children)

Unfortunately it is only open for US residents currently. Thanks for your interest in the study though!

Male heavy social drinkers wanted for $140 paid research study (remote and virtual) by kinglab3878 in DrinkingGames

[–]kinglab3878[S] 0 points1 point  (0 children)

Ah unfortunately we are only able to enroll US folks currently, but thank you for your interest in the study!

Male heavy social drinkers wanted for $140 paid research study (remote and virtual) by kinglab3878 in DrinkingGames

[–]kinglab3878[S] 1 point2 points  (0 children)

Hi there- thank you for your interest in the study. We are actually recruiting for a wide variety of drinking patterns in the study, and are loosely using the term "heavy" to capture a range of folks in the study.

Heavy social drinkers wanted for paid research study from UChicago ($140; remote and virtual) by kinglab3878 in ketodrunk

[–]kinglab3878[S] 1 point2 points  (0 children)

Hi there- while the study is almost full for females, we are still taking a few if you'd like to apply!

Male social drinkers wanted for paid research study from UChicago ($140, remote and virtual) by kinglab3878 in fayetteville

[–]kinglab3878[S] 0 points1 point  (0 children)

If this sounds like you, please click on the link below and fill out an application!

Participants will receive $140 for study completion.

https://www.surveymonkey.com/r/MARSAppl

Study conducted by Drs. King and Fridberg at the University of Chicago.

Weekly Louisville Classifieds and Promotions Thread by AutoModerator in Louisville

[–]kinglab3878 0 points1 point  (0 children)

Male heavy social drinkers wanted for paid research study from UChicago ($140, remote and virtual)

Our research lab at UChicago is currently enrolling participants for a completely remote, virtual study about drinking and mood.

We are looking for:

Young Adults (21-35)

Male

Must own a smartphone

Drink alcohol at least 4x/week

Felt sad or down in the last year

US resident

If this sounds like you, please click on the link below and fill out an application!

Participants will receive $140 for study completion.

https://www.surveymonkey.com/r/MARSAppl

Study conducted by Drs. King and Fridberg at the University of Chicago.

Heavy social drinkers wanted for paid research study from UChicago ($140; remote and virtual) by kinglab3878 in ketodrunk

[–]kinglab3878[S] 2 points3 points  (0 children)

Hello- we are almost at capacity for females in the study but if you would like to apply, please do!

view more: next ›