Help unstanding this formula?
Results 1 to 2 of 2

Thread: Help unstanding this formula?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2017
    Location
    Derby. England
    Posts
    176
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Help unstanding this formula?

    Hi, please can someone help and tell me what this formula is looking for or doing?

    Code:
    =OFFSET('Current weeks data'!$A$1:$W$1000,,,COUNTIF('Current weeks data'!$K:$K,">"&0)+1)
    It's the last part I don't understand but if you could explain it all just incase im mistaken.

    Thanks

    Dan

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,113
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Help unstanding this formula?

    Try to test with a smaller data area, say, A1:D5, on Sheet1. Enter some data in A1:D5 and also some small numbers in F. Enter the adjusted formula in G1 as:

    =OFFSET($A$1:$D$5,,,COUNTIF($F:$F,">"&0)+1)

    Select the formula in G1, hit F9, and observe the result in the formula balk. Repeat the process by changing the values in F until you understand what the COUNTIF part does.
    Assuming too much and qualifying too much are two faces of the same problem.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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