Computer Science, asked by vaiku2656, 6 months ago

what is used to reverse the usual order for a formula.

Answers

Answered by Kamalegunjan89
5

Answer:

It takes a lot time and effort . But in excel , we can do it using three commonly used funtions , We can use the INDEX, COUNTA and ROW funtions together to reverse a list or string.

Explanation:

HOPE IT WILL HELPFUL TO YOU.

PLEASE MARK AS BRAINLIST...

THANKS

Answered by aryansuts01
0

Answer:

You can use a calculation based on the INDEX, COUNTA, and ROW operations to reverse a list, putting the elements in a list or column in the opposite order. The formula in D5, repeated down, in the illustration is as follows:

=INDEX(list,COUNTA(list)+ROW(list)-ROW(),1)

The named range B5:B14 with the name "list" is. If you are not using a named range, make sure to use an absolutely connection because called regions are relative connections by default.

Explanation:

Column B must be reversed in order for us to:

Enter cell B2. To choose it, simply click on it with your mouse.

The next step is to enter the following formula into cell B2: =INDEX(A2:A7,COUNTA(A2:A7)+ROW(A2:A7)-ROW(),1).

To replicate the equation to the columns following, we must lastly move the fill handles from cell B2 to B6.

The INDEX function, which receives the list as an array input, is the key component of this equation.

=INDEX(list

As the formula is replicated down, an equation in the second portion of the formula calculates the right row number:

COUNTA(list)+ROW(list)-ROW()

  1. The number of non-blank items is returned by COUNTA(list) (10 in the example)
  2. ROW(list) provides the list's first row's number 
  3. The method's row value is returned by ROW().

#SPJ3

Similar questions