+ Reply to Thread
Results 1 to 4 of 4

Formula to check Groups of same value and return a value based on another Col

  1. 03-29-2017, 12:28 AM #1
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Formula to check Groups of same value and return a value based on another Col

    Hi Folks

    Col A in my Workbook has groupings of the same value, these can vary in number.
    Col Y has numerical values which can range from 0 to 80
    If any of the values in Col Y are <= 3 then I need the formula to return 'NB' in Col AA or simply "B" if all values are above 3.

    Example Workbook with notes attached.

    Cheers
    hammer
    Attached Files Attached Files
    If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
    No idea why I need Rep, other than feeling left out....
    Reply With QuoteRegister To Reply
  2. 03-29-2017, 12:51 AM #2
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Formula to check Groups of same value and return a value based on another Col

    Hi,

    in AA2 to be copied down

    =IF(COUNTIFS(A:A,A2,Y:Y,"<4"),"NB","B")

    Regards
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 03-29-2017, 01:00 AM #3
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Formula to check Groups of same value and return a value based on another Col

    So simple--- just like me...

    Many thanks canapone
    Reply With QuoteRegister To Reply
  4. 03-29-2017, 01:02 AM #4
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Formula to check Groups of same value and return a value based on another Col

    Ciao,

    you're welcome.

    Thanks for proving feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula review three columns and return variance based on one value in the three columns
    By kre30a in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2017, 12:54 PM
  2. [SOLVED] Formula to RANK groups of Values and return letter
    By hammer2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-19-2016, 04:36 AM
  3. Check URL for specific path, return value based on that
    By Windsong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2015, 09:57 AM
  4. [SOLVED] check a date and return different values based on time and day of week
    By garyfahy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2014, 07:26 AM
  5. [SOLVED] Formula to search for a value in groups of cells and return the name of the smallest group
    By PeterR in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-13-2014, 08:23 PM
  6. Need a Formula to Check an Audit Log Against a List of Groups of People
    By badmoon75 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-22-2012, 11:44 AM
  7. I want to return a value based on the status of a check box. If .
    By JROD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1