• Ask a Question
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Top Contributor

      Excel formula

      can someone explain what is happening in this formula:

      INDEX(Data!$2:$65536,COUNTA(Data!$B:$B),COUNTA(Data!$2:$2)+1)

      Asked by Chait on April 26, 2017 in Excel.
      2 Answers
      Expert

      HI,

      Please find formuls and its explanation here

      Formula: INDEX(Data!$2:$65536,COUNTA(Data!$B:$B),COUNTA(Data!$2:$2)+1)

      Explanation:

      Index Function: INDEX function returns a value in an array based on the intersection of a row and column position within that array.

      Index function has 3 parameters.

      1st parameter (Data!$2:$65536)  represents an array

      2nd one( COUNTA(Data!$B:$B)) represents row number

      And 3rd one (COUNTA(Data!$2:$2)+1) represents  column number).

      Where ‘Data’ is a sheet name.

      Please find more details about index function here.

      Regards!

      Answered by Valli on April 27, 2017..
      Top Contributor

      iam not asking how index function works…im well aware of it…im asking you to explain the logic happening there and what that means

      Answered by Chait on April 27, 2017..