Skip to main content

Index formula in excel

Index Formula:

index formula in excel

Array: is a range of cells or an array constant.

    If array contains only one row or column, the corresponding row_num or column_num argument is optional.
    If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array.

Row_num : Selects the row in array from which to return a value. If row_num is omitted, column_num is required.

Column_num : Selects the column in array from which to return a value. If column_num is omitted, row_num is required.

Labels:

Comments

Post a Comment

Popular posts from this blog

Join the Beauty Course for Massage Beauty License Training

Massage Beauty School of California: Massage beauty program is one of the top ten beauty courses which are well recognized and sought after in the beauty sector. Several students from various cities and states enroll in this training program to get better learning opportunities and understand the minute technicalities of beauty massaging services. Certified schools and beauty institutes located in Los Angeles are offering cutting-edge training to the students who are eligible for the program. Palace Beauty College is an accredited beauty school that does offer a massage therapy program and also offers holistic learning facilities to the students. The college has years of experience in providing massage therapy license training in Los Angeles for more than half a decade now. The college maintains its official website to reach out to distant students and provide them relevant information related to the available beauty courses. The college takes pride in its impressive infrastru...
Post a Comment
Explore More »

Former President APJ Abdul Kalam Died at 83

"Missile Man is no more" A.P.J Abdul Kalam died in Shillong. He was brought into the hospital without a pulse or BP. There was no sign of life John Sailo Ryntathiang, director of Bethany Hospital," told the Quint. About Abdul Kalam: Abdul Kalam was an Indian scientist who was the 11th President of India from 2002 to 2007. Kalam was born and raised in Rameswaram(Tamil Nadu) and studied physics and aerospace engineering. He worked as a scientist and science administrator, mainly at the Defence Research and Development Organisation (DRDO) and Indian Space Research Organisation (ISRO) before he became president. The Centre has declared national mourning for seven days. Kalam served as president for five years from 2002, enjoying the support of both the ruling BJP and the opposition Congress. He graduated from Saint Joseph's College, Tiruchirappalli in 1954 but not satisfied with his degree, he left for Madras later next year to study aerospace engineering. He enrolled ...
Post a Comment
Explore More »

Cryptocurrency: The future currency and bitcoin investment

What is Cryptocurrency? Cryptocurrency is a digital or virtual currency that uses cryptography for security. A cryptocurrency is a medium of exchange that uses cryptography to secure transactions and control the creation of additional units. Cryptocurrency uses a decentralized system of records called a blockchain to track transactions instead of using a traditional database like a conventional currency. The crypto world is full of surprises. New coins and tokens are being launched almost every day. Some of these go on to change the world, while others will fizzle out and be forgotten. It’s impossible to predict which ones will thrive and which ones will fail, but crypto is a great way to keep up with the latest developments in technology and finance. Cryptocurrency is a digital or virtual currency that uses cryptography for security. A cryptocurrency is difficult to counterfeit because of this security feature. A defining feature of a cryptocurrency, and arguably its most alluring ass...
Post a Comment
Explore More »