+ Reply to Thread
Results 1 to 5 of 5

How to return values/text in cell if condition is met?

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    bhutan
    MS-Off Ver
    Excel 2007 $ 2010
    Posts
    12

    How to return values/text in cell if condition is met?

    Hi,
    Anybody would like to help me in finding subject topper using excel formula. Excel worksheet is attached RESULT.xlsx


    Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to return values/text in cell if condition is met?

    What would an expected answer look like? Please give more details of what you want, and where to find it
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    Re: How to return values/text in cell if condition is met?

    is that what you're after?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-25-2013
    Location
    bhutan
    MS-Off Ver
    Excel 2007 $ 2010
    Posts
    12

    Re: How to return values/text in cell if condition is met?

    I wanted to find name list of subject topper using excel formula. For. e.g. to find Subject (English) topper, i need to look maximum marks in English and at the same time i need look at name who secured maximum marks in English. That is how i do manually to find subject topper. I would like to try using excel formulae which would be very easy.
    Thanks

  5. #5
    Registered User
    Join Date
    07-25-2013
    Location
    bhutan
    MS-Off Ver
    Excel 2007 $ 2010
    Posts
    12

    Re: How to return values/text in cell if condition is met?

    I wanted to find name list of subject topper using excel formula. For. e.g. to find Subject (English) topper, i need to look maximum marks in English and at the same time i need look at name who secured maximum marks in English. That is how i do manually to find subject topper. I would like to try using excel formulae which would be very easy.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Look up several values in a cell and return a specific text
    By peterromer in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-27-2014, 12:03 PM
  2. Return values if more than 1 condition are met
    By jleblanc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2014, 10:12 AM
  3. [SOLVED] Makro with if condition to check for numeric and text values in a cell range
    By Postlki1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2013, 07:53 AM
  4. Store cell values in an array and return values on specific condition
    By gmalpani in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 11-27-2011, 06:43 AM
  5. Return Top Ten values when condition is met?
    By jarvo in forum Excel General
    Replies: 1
    Last Post: 02-17-2005, 11:28 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