Results 1 to 4 of 4

Thread: Help with Array with multiple ranges and criteria

  1. #1
    Banned Grizraz's Avatar
    Join Date
    Jan 2020
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Help with Array with multiple ranges and criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Attached is a workbook containing two worksheets, "Data" and "Map". Data has multiple tables, basically two tables for each day of the week.
    "Map" contains a section for each day, each containing an area for each type of array, FLOOR (#1 Below), 1400 (#2 Below) and 1700 (#3 Below).

    1) My goal has been to use an array that will generate a list of:

    "1400" from first table of day
    "1700" from first table of day
    "*p" from second table of day
    "*-F" from second table of day
    These criteria would list the corresponding names that match the above criteria.


    2) Next, do the same for:
    "1400" from second table of day
    (so far my results for "1400" also include "*p" and "*-F" where I only want "1400".

    3) And again for:
    "1700" from second table of day.
    (so far my results for "1400" also include "*p" and "*-F" where I only want "1700".

    Sample.xlsx

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,682
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://www.mrexcel.com/board/thread...teria.1119583/
    and this looks similar:
    https://www.reddit.com/r/excel/comme...atch_from_one/
    Grizraz, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  3. #3
    Banned Grizraz's Avatar
    Join Date
    Jan 2020
    Posts
    2
    Articles
    0
    Excel Version
    2016
    Yeah I donít care, this states submitted 9am which is inaccurate. When originally posted, did not appear, looked like it didnít go through so yes, I took the post elsewhere.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,682
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by Grizraz View Post
    Yeah I donít care
    A shame, because I have an answer for you; never mind.

Posting Permissions

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