+ Reply to Thread
Results 1 to 3 of 3

Formula to select ranges based on values in another column

  1. #1
    Registered User
    Join Date
    10-08-2018
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    89

    Formula to select ranges based on values in another column

    Hi,

    Please see the attached file.

    I am looking for a formula that can be used to define the ranges in column B based on values in Column A. I plan to use this to calculate percentiles for the population in column B, for each of the values in column A. Values in Column B are continuous measures in real data (not Y or N). I am looking for a non-VBA solution ("If" formula).

    Thanks

    Bharath Srivatsa
    Attached Files Attached Files

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071

    Re: Formula to select ranges based on values in another column

    Hi,

    Attached is your test file ...

    ="B"&MATCH(C4,A:A,0)&":"&"B"&MAX(IF($A$1:$A$36=C4,ROW($A$1:$A$36)-MIN(ROW($A$1:$A$36))+1))
    Attached Files Attached Files
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    10-08-2018
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    89

    Re: Formula to select ranges based on values in another column

    Thanks Carim!
    That was super quick. Really appreciate it.
    Have a nice day. Thanks again!

+ 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. [SOLVED] Creating ranges based on column values VBA
    By R12345 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2016, 10:14 AM
  2. [SOLVED] Auto-select cell ranges based on x column value to execute formula
    By jb257 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2014, 03:22 AM
  3. Replies: 1
    Last Post: 05-14-2014, 05:09 PM
  4. [SOLVED] Sum the values in a column based on the Date ranges
    By gl.shruthi in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-04-2012, 06:04 PM
  5. Replies: 0
    Last Post: 06-28-2010, 10:23 AM
  6. Programming a Macro to select row ranges based on a formula
    By workaholic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2009, 09:32 PM
  7. How to select a range based on values in 1 column
    By ForestRamsey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1