Creating a Filter based on variable data

[sfawzy]

Hello, I'm working on an assignment to create a reaction time (RT) filter that is based on a given participant's reaction time data. So I will have a column for each participant where each row represents the reaction time of a given trial. I will want to create a cutoff for RTs that are slower than a user-defined point. The equation for this is slowestRT = meanRT + (StdDv * Mult) where "mult" is defined by the user and the rest is obtained from the participant's data. What I have is below. It doesn't generate an error, but nothing happens when I run it.

Please Login or Register  to view this content.

I'm sure I've done several things wrong here, but if anyone could get me on the right track it would be very much appreciated. For now I've set the mean and std. dev to set values, but once I've got the loop functioning I will figure out how to make them variable for each pariticipant.

Thanks in advance.

[dflak]

I am jumping on this before an Admin does. It will speed the process if you comply now.

This also sound like something that might be accomplished with a named range.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

Also:


Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Code tags and sample workbook will speed the solution along!

[xladept]

Maybe:

Please Login or Register  to view this content.

* I figured that you don't want to delete but just clear the contents?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[sfawzy]

Sorry for the bad form in my original post. I've updated now and included the attachment.

xladept, What happens to the contents isn't actually that important, as long as the user would know not to use the content of that cell. So clearing them would be fine, or I would maybe have it read "reject" but I imagine that should be a straightforward adjustment.

It looks like you've created another variable for the loops. Is that the major difference between yours and mine?

The workbook I've attached is set up for multiple participants, but I don't know if I'll extend it to that, depending on how difficult it looks to be. As long as I can at least set up the function for a single subject's data I should be alright. So, ideally, the user pastes in a column of RT data and clicks "filter" button that holds the macro code, and it runs through each cell with the "slowestRT" equation, rejecting any cell that is greater than "slowestRT." It seems very basic, not sure why I'm not getting any output.

Thanks,

[xladept]

Variables are the major difference but using Row as a variable seems unwise that's why I tagged it with the underscore and For Row= 7 to Row seems self-defeating

[dflak]

I decided to be non-destructive and rather than overwrite the data, I overwrote a copy of the data so you can go back and try with different Multipliers for the same data or check the results.

I also eliminated the need to prompt for the number of trials and the number of subjects. I "hard coded" up to 25 subjects (Columns B to Z) you don't have to fill these in. What the code does is get the last row in each column (eliminating the prompt for trails) and if the row is less than 7, it means there is no data for that subject and that column gets skipped.

The consequences of this are, you can have as many trials as you want and you can have a different number of trials for each subject. Subjects do not have to be contiguous.

When you click on Filter RT Data, you will be prompted for the multiplier and the program takes off from there.

Please Login or Register  to view this content.

[sfawzy]

I think that does it, dflak! Thank you so much!! I'm going to mark this as solved, but I might follow up with a question or two if I can't figure out how something works, if you don't mind. Thanks everyone for the feedback.

[dflak]

Glad to be of service and I'll explain anything I can.