Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: Determine If Character Exists In Cell

  1. #1
    Join Date
    22nd September 2007

    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

    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. #2
    Join Date
    19th January 2005
    Michigan, USA

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

    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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Determine If Custom Commandbar Exists
    By The Dutchman in forum EXCEL HELP
    Replies: 2
    Last Post: April 2nd, 2008, 08:21
  2. Determine If Cell Value Exists In A Range
    By JohnDrew in forum EXCEL HELP
    Replies: 3
    Last Post: March 17th, 2008, 11:44
  3. Replies: 3
    Last Post: February 19th, 2008, 01:53
  4. Determine Left Most Character in Cell Text
    By salparadise in forum EXCEL HELP
    Replies: 2
    Last Post: August 17th, 2006, 02:17
  5. determine if file exists with input box
    By saban123 in forum EXCEL HELP
    Replies: 1
    Last Post: February 20th, 2006, 20:01


Posting Permissions

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