+ Reply to Thread
Results 1 to 5 of 5

Fill in "x" (or leave blank) to many boxes based on 3 criterias (complicated?)

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Fill in "x" (or leave blank) to many boxes based on 3 criterias (complicated?)

    Hi guys, probably Z-Most complicated task ever yet... Would you figure?

    Excel and screenshots attached. Each box needs to have a formula, so that when selection is made, "x" should be filled in (or left blank) accordingly. All the "x" are already entered correctly, as they should be based on data entered. I also coloured them just to be able see what belongs where, more visually.

    This is kind of UFO task for my skills...

    Any possibilities to crack this one up?

    Thanking in advance!!

    https://www.excelforum.com/attachmen...1&d=1530564314 [Excel]

    2018-07-02_2238.png
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Fill in "x" (or leave blank) to many boxes based on 3 criterias (complicated?)

    I added a column of numbers (1-30) in AF8:AF37
    Then this formula in E8 : =IF(VLOOKUP($F$3,$AE$8:$AF$37,2,FALSE)>$AF33,"X",IF(($I$3+$M$3)>=Y$7,"X",""))
    Now copy formula and paste into E8:AB37

  3. #3
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Fill in "x" (or leave blank) to many boxes based on 3 criterias (complicated?)

    Hi,

    Columns B, D and Cell F3 are Text values, not numbers, so my formula has to convert these.

    Formula in E8 copied Down and Across to AB37:

    See attached sample file.

    =IF(OR(AND(LEFT($F$3,2)+0>=$B8+0,RIGHT($F$3,2)+0>=$D8+0),E$7<=$I$3+$M$3),"x","")
    Attached Files Attached Files
    Last edited by jtakw; 07-02-2018 at 05:37 PM.

  4. #4
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Fill in "x" (or leave blank) to many boxes based on 3 criterias (complicated?)

    I don't know how you guys do what you do, but this is genius.... Wow. Just wow.

    CRIMEDOG, jtakw... thank you, so much.

    Works perfectly. Signing off, with a big happy smile. And thanks, once again...

  5. #5
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Fill in "x" (or leave blank) to many boxes based on 3 criterias (complicated?)

    You're welcome vill.

+ 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. Replies: 6
    Last Post: 06-18-2018, 04:02 PM
  2. Replies: 0
    Last Post: 02-14-2018, 06:14 PM
  3. [SOLVED] Leave a cell blank if found "Cancelled" in adjacent column
    By jmklei0 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2017, 06:00 PM
  4. Replies: 6
    Last Post: 09-25-2013, 01:51 PM
  5. Replies: 8
    Last Post: 12-31-2012, 05:19 PM
  6. Replies: 3
    Last Post: 12-14-2006, 01:36 PM
  7. Replies: 6
    Last Post: 10-27-2005, 11:05 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