Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF NO FOR ALL THEN.... (2000 sr-1)

    With macro ...
    Assuming for each line (range L:AC) is present the first 2 character = NO insert in AD "OK" else "KO"...

    on this case in line 15 all value init with NO insert in AD "OK"...
    in line 13 "KO"...

  2. #2
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    Hi there!

    I just want to make clear that I get this right. If any cell in Column AD is not no, you want the offset value in AD to be "KO"? Else it is to be "OK"?

    Darryl.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    acccccccccccc..... my english!!!!
    No...
    In effect scanning all cells in each line (rangeL:AC) and if in all cells of this line have first 2 carachter insert OK else KO

    explain:

    in cell L15, M15, N15...AC15 all cells have the first 2 character of value have NO, in this case the cell AD15 fil with OK...

    in cell L13, M13, N13...AC13 all cells have the first 2 character of value have NO, but the cell AB13 the first 2 character of value have VE..in this case the cell AD13 fil with KO...


    in other words,

    if all cells (in range) have NO....... insert OK
    if all cells (in range) have only one value different to NO insert KO
    clear...
    sorry me..

  4. #4
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    Don't worry about the English....It's my first language and still I can't talk it!

    Give me a few minutes...let me see if I can figure it out.

    Darryl.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    :-) same for my Italian...
    Tks for patience...

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    In cell AD2, enter the following array formula:

    =IF(SUM(1*(LEFT(L2:AC2,2)="NO"))=COUNTA(L2:AC2),"O K","KO")

    You must confirm the formula with Ctrl+Shift+Enter instead of Enter. Fill down as far as needed. See attached workbook.

  7. #7
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    I didn't have that in me

    Hans is da best.

  8. #8
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    wow!!!
    Tks as usual Hans, but with a macro?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF NO FOR ALL THEN.... (2000 sr-1)

    Why?

Posting Permissions

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