Results 1 to 9 of 9

Thread: count weeks since last wash

  1. #1

    Cool count weeks since last wash



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

    hi. i have a problem with a list. what i want is to find out how many weeks since last wash was done by any of the residents. the list is partly here. i need to count the zeroes back in time....week 10- week 9- week 8 and so on, until week 7 where JE has done his part and marked that with a 1....the answer should be in number of weeks since....this will solve a lot of arguments between nighbours
    Navn Uke 1 Uke 2 Uke 3 Uke 4 Uke 5 Uke 6 Uke 7 Uke 8 Uke 9 Uke 10 Sum weeks since
    JE 0 1 0 0 0 1 0 0 0 0 2 need forula
    AR 1 0 0 0 0 0 0 0 0 0 1
    FL 0 0 0 0 0 0 0 0 0 1 1
    ACG 1 0 0 0 0 0 0 0 0 0 1
    RS 0 0 1 0 0 0 0 0 1 0 2
    GH 0 0 0 0 0 0 1 0 0 0 1
    JK 0 0 0 1 0 0 0 0 0 0 1
    TVA 0 0 0 0 1 0 0 0 0 0 1
    VLO 0 0 0 0 0 0 0 1 0 0 1
    SLH 0 0 0 0 0 1 0 0 0 0 1
    OM 0 0 0 0 0 0 0 0 1 0 1

  2. #2
    Try this array formula

    =COLUMN(L2)-MAX(IF(B2:K2<>0,COLUMN(B2:K2)))-1

  3. #3

    nope..... getting some wired numbers

    Navn Uke 1 Uke 2 Uke 3 Uke 4 Uke 5 Uke 6 Uke 7 Uke 8 Uke 9 Uke 10 Sum weeks since
    JE 0 0 0 0 1 0 0 0 0 0 1 9
    AR 1 0 0 0 0 0 0 0 0 0 1 10
    FL 0 0 0 0 0 0 0 0 1 0 1 8
    ACG 1 0 0 0 0 0 0 0 0 0 1 10
    RS 0 0 1 0 0 0 0 0 1 0 2 9
    GH 0 0 0 0 0 0 1 0 0 0 1 9
    JK 0 0 0 1 0 0 0 0 0 0 1 9
    TVA 0 0 0 0 1 0 0 0 0 0 1 9
    VLO 0 0 0 0 0 0 0 1 0 0 1 9
    SLH 0 0 0 0 0 1 0 0 0 0 1 9
    OM 0 0 0 0 0 0 0 0 1 0 1 9

  4. #4
    I get 4,9,0,9,1,3,6,5,2,4,1

  5. #5
    strange. i still get the same wired numbers.....can it be that i run on exel 2007, i have changed from comma to semi colon in order to make it work, but is there more differens then that?

  6. #6
    No, I use 2007 too on this machine. Semi-colon is just because you have a continental version of excel, so that should not matter. Can you post the workbook with your formula in it?

  7. #7

    woorkbook

    this is the file. have tried to change things, but nothing seem to work
    Attached Files Attached Files

  8. #8
    You replaced the colon (:) between B2 and K2 with a comma (,), you should not have done that. Change it back, and ARRAY enter it (Ctrl-Shift-Enter).

  9. #9

    Cool solved

    thanks a lot, everything is working smootly.....great forum

Posting Permissions

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