Excel formula

can someone explain what is happening in this formula:

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

Top Contributor Asked on April 26, 2017 in Excel.
Add Comment
2 Answer(s)

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!

Expert Answered on April 27, 2017.
Add Comment

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

Top Contributor Answered on April 27, 2017.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.