+ Reply to Thread
Results 1 to 5 of 5

Check if content of some cells is "off"

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Check if content of some cells is "off"

    Hi all,

    in the first row(A-AG) i have weekdays (mo-sun). In every other row (A-AG) of the used range i have working hours and sometimes "Off". What formula would i have to use to check whether any whole weekend is "off" for any row? I guess it would be an array formula but im not sure.
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Check if content of some cells is "off"

    Hi Bishonen,

    Please upload a sample workbook.. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Check if content of some cells is "off"

    weekends.xlsx

    Hi dilipandey,

    I've attached the workbook. Column "AM" states whether a whole weekend is off for one employee. row3 is OK since multiple whole weekends are off. Row 4 is not ok since no full weekend is off.

    Thanks

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Check if content of some cells is "off"

    Ηι

    Which is the minimum of weekends, that someone must be Off, so the result to be OK?

    Because in Row 3 not All weekends are off and you say that you need OK, as result.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Check if content of some cells is "off"

    Hi Fotis1991,

    you're absolutely right. The "OK" should appear already after only one weekend is "off". So it does not make any difference whether its 2,3,4.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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