+ Reply to Thread
Results 1 to 4 of 4

Range Data Selection

  1. #1
    Registered User
    Join Date
    09-04-2024
    Location
    USA
    MS-Off Ver
    Latest
    Posts
    2

    Range Data Selection

    Hello! I'm having a bit of difficulty trying to figure out the proper equation or formula needed for the proper result. This is my work sheet:

    Excel Help 1.xlsx

    The first table are measurements taken of real life product and whether they pas of fail a range of criteria. The second table is a range of data that is used to verify if the measurements are in a acceptable range. So if a measured width is 0.25 or less, then the minimum thickness would be 0.125 or else it would be labeled a "Fail". Another Example is if the measured width is 0.25<Measurement>0.37, then the minimum thickness would be 0.25 or else it would "Fail". Hopefully this makes some sense?

    My issue is that I'm not sure what formula or equation would be best to use for the Criteria 2 column.

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2505
    Posts
    1,525

    Re: Range Data Selection

    Welcome to the forum.

    Try in G2, copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

  3. #3
    Registered User
    Join Date
    09-04-2024
    Location
    USA
    MS-Off Ver
    Latest
    Posts
    2

    Re: Range Data Selection

    Thanks!

    Ah, that makes sense now, thank you! I kept trying the IF, AND & OR in different forms but I couldn't get the to work properly. Thanks again.

  4. #4
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2505
    Posts
    1,525

    Re: Range Data Selection

    You’re welcome. Glad to help.
    Thank you for the feedback and for the reputation added.
    Have a blessed day.

+ 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. Chart data range selection with VBA
    By ArtZ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2023, 11:56 AM
  2. Need code for print and export for the dyanamic range selection if extended the data range
    By Pankaj jaswani in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-30-2022, 05:29 AM
  3. [SOLVED] Filtering Data by Using ListBox Selection to Display All Data in Set Range
    By IAMROBBERMAN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2020, 11:10 AM
  4. Replies: 0
    Last Post: 12-10-2014, 11:30 AM
  5. Range selection-row of data
    By kola5567 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2005, 09:54 AM
  6. [SOLVED] Selection Data from a Range
    By Mr M Walker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2005, 09:05 AM
  7. [SOLVED] Selection in data range
    By Dr.Schwartz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2005, 05:06 AM

Tags for this Thread

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