Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Determine If Character Exists In Cell

1. I agreed to these rules
Join Date
22nd September 2007
Posts
1

## Determine If Character Exists In Cell

Hello, I'm wondering if you can advise me on how to accomplish this in excel.
The data is from a simple memory task where people sit in front of the computer and see a string of letters flashed in front of them (i.e. VCBDLIWE) briefly, then they are shown one letter (i.e. I) and they need to press 1 if they think that letter was in the original string, and 2 if they don't think it was. I have the data in an excel table but I can't figure out how to score it. Here's how the table is set up
ID Trial EventType Code
1 1 Picture VCBDLIWE ---> the string
2 1 Picture 8_delay
3 2 Picture I ----> the letter
4 2 Response 1 ----> their response
5 3 Picture RAMEUHTZ
6 3 Picture 8_delay
7 4 Picture N
8 4 Response 1 --> they got it wrong
etc

There's one more field (TTime) with the time it took to hit the button (reaction time) that I want to keep in there, but basically I need a query to just select out all the ones who got it right, and tell me how long it took them to hit the button (TTime).

Where I'm running into problems is that the string, the letter, and the response is all in the same column (Code).

I have made a new column called 'Score' and I'm trying to come up with a formula that will take the letter (i.e. N) and search if it is in the string 2 rows above it, and then return true/false if it is?

Thank you!

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: True/false If A Letter Is Contained In A String?

B5: RAMEUHTZ
B6: 8_delay
B7: N
B8: 1

C8: =IF(ISERR(FIND(B7,B5))=FALSE,1,0)

Gives a "0" for wrong, "1" if answered correctly...

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno