Results 1 to 6 of 6

using an if statement to compare 2 columns of data and return text information

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Warrington
    MS-Off Ver
    Excel 2010
    Posts
    11

    using an if statement to compare 2 columns of data and return text information

    Hi

    This may seem like a really simple but I am having a problem achieving the required result.

    I have 2 columns of data reflecting English and Maths Grades. If the grade for either English or Maths is a C- or below then they haven't achieved the required result in these two subjects so the the third column will indicate which subject they did not achieve in (English, Maths or Both). If the student achieved a C or above in both English and Maths my formula should return a blank cell.

    Please have a look at the attached spreadsheet as it will make more sense - I require a formula in the the third column please.

    I look forward to hearing from you

    kind regards
    Vanessa
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare data in columns of two worksheets and return value if match.
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2013, 10:38 AM
  2. [SOLVED] Compare data in columns and return separately
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2013, 07:36 PM
  3. Replies: 6
    Last Post: 02-28-2013, 11:27 AM
  4. Replies: 4
    Last Post: 02-12-2013, 12:15 AM
  5. Compare values in two columns and return text from adjacent cell
    By MrBorders in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-04-2009, 04:54 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1