Difference between LARGE function and MAX function in EXCEL

Reverse the current year

Favorable reply

When only one maximum value is returned from a set of data, the LARGE function can play the same role as the MAX function, but if you need to return several maximum values, you can only use the LARGE function.

Operation method

1. The LARGE function returns the kth maximum value of the data group.

2. The MAX function returns the maximum value in a set of data.

3. The LARGE function has two parameters. The first parameter is the numerical region, and the second parameter is the largest value to be returned.

4. The MAX function can return a maximum value from 1-255 data. The following figure shows a data area and returns a maximum value in that area.

5. If only one maximum value in the data needs to be returned, then the LARGE function and MAX function have the same results.

6. If it is necessary to use LARGE function to return several maximum values in the data, it is a convenient method to write formulas nested with LARGE function and ROW function.

7. If the data area is defined as a name, it will be faster to write formulas, and it is also convenient to reduce the error rate.

hot tip

You must master the method of function nesting.

Reverse the current year 2024-05-23 13:50:45

The above contents quoted, excerpted or reproduced on this website are only for the exchange or reference of website visitors. The views or information in the text have nothing to do with Aiwen, and any matters and legal liabilities related to it have nothing to do with Aiwen.

Latest answers Change

one

Q: What does psychology touch the ear represent

Answer:

A: In psychology, touching the ear represents anxiety, opposing the other party's views, wanting to stop the topic, dismissing, etc. Psychology is a science that studies human psychological phenomena and their mental functions and behavioral activities under their influence, giving consideration to both outstanding theoretical and practical aspects. Psychology includes basic psychology and applied psychology.

two

What technical schools are there in Nanchang 2020-08-08

three

Where is Leishayuan 2020-01-16

four

What is the period of Chinese papermaking 2020-02-07

five

How to mix big fruit noodles 2020-04-06

Related recommendations

From which year to which year during the 11th Five Year Plan period

From 2006 to 2010, the "Eleventh Five Year Plan" is the 11th Five Year Plan for the National Economic and Social Development of the People's Republic of China. The "Five Year Plan" is a part of the national economic plan of China, which mainly focuses on major construction projects, productive forces, etc

Details>

Question time: March 28, 2020

How many stools are there in one year and two months

For one year and two months, it is normal to defecate three to five times a day. During this period, you should pay attention to nutrition supplement and prevent constipation. When feces are full of rectum, it stimulates the receptors of intestinal wall, sends out an impulse to the lower defecation center in the lumbosacral spinal cord, and at the same time, it is uploaded to the cerebral cortex and

Details>

Question time: February 5, 2020

Why is Dragon Boat Festival called Dragon Boat Festival

May is the month of poison. The fifth day is the day of poison. The noon of the fifth day is also the time of poison. It is the end of the three poisons. The Dragon Boat Festival is also called the end of May. Dragon Boat Festival, also known as Duanwu, is one of the largest traditional festivals in China. The meaning of Duan is the same as that of Chu. To call Duanwu is just like that of Chu. The five characters of Duanwu are connected with Wu

Details>

Question time: July 17, 2020

Butt measurement, body temperature, normal

The buttock temperature is between 36.5 and 37.5 degrees, and the temperature of the baby's normal anus is between 36.5 and 37 degrees, which is normal. Generally, the anal temperature is higher than that of the armpit. The normal temperature of the armpit is 36-37 degrees, and that of the anus is 36.4-3 degrees

Details>

Question time: January 21, 2020

How many noodles are there in a bowl of Lanzhou noodles

Lanzhou beef noodle, also known as Lanzhou beef noodle soup, is one of the "top ten noodles in China" and a local snack in Lanzhou, Gansu Province. It has the unique flavor of "clear soup mirror, fragrant meat, fine noodles" and "clean, clean, three red, four green

Details>

Question time: June 12, 2020

When did black people carry coffins

Black people carry coffins in 2020. Black people carrying coffins is a popular word on the Internet. Several black people carrying coffins perform a very nice dance, which has been matched with music and released online. The word comes from a black coffin dance team in the original video "Ghana black coffin dance"

Details>

Question time: August 10, 2020

How to repair the damaged zipper

If the zipper lock is broken, you can only replace it. If it is not broken, the following steps should be followed: first, remove the top tooth of the zipper with pliers, and pull it on both sides; Then pull the lock of the zipper to the top, merge the teeth on both sides, and then pull

Details>

Question time: January 2, 2020

How does Apple 6s turn off the headset mode

The way for Apple 6s to turn off the headset mode is as follows: 1. First click "Settings" on the iPhone 6s desktop. 2. Then select the "General" option in the setting interface. 3. Then open "Auxiliary Functions" to enter. 4. After entering, click "Audio caller..."

Details>

Question time: December 31, 2020

How to bake sweet potatoes in microwave oven

Wash the sweet potatoes, dry the water on the surface with kitchen paper, put them into a microwave dish, wrap them with a microwave preservative film, put them into the microwave oven and microwave for 10 minutes. Sweet potato contains a variety of vitamins, has the function of smoothing intestines, can reduce fat absorption, and eating sweet potato can increase satiety

Details>

Question time: 2019-09-17

Which street does Jiahe Road in Siming District, Xiamen belong to

Jiahe Road, Siming District, Xiamen, Fujian Province belongs to Jialian Street. Siming District, under the jurisdiction of Xiamen City, Fujian Province (formerly Tong'an County, Quanzhou Prefecture), is located in the south of Xiamen (Xiamen Island), 24 ° 26 ′~24 ° 28 ′ north latitude

Details>

Question time: 2021-10-23

What does 5gnr mean

5GNR is the abbreviation of 5GNewRadio. It is the hottest research and development focus in the communication industry today. In addition to the competition among enterprises, the competition between countries in industrial policies is also very fierce. The spectrum is the battlefield of direct confrontation. 5GNR is the base

Details>

Question time: January 28, 2021

How College Students Choose Employment

First, confirm the direction of employment. Second, understand the industry information. Third, be clear about your ability. Fourth, improve yourself. If you want to work, you must know your own employment direction, what you want to do, what you can do, if you don't know your own ideas

Details>

Question time: December 2, 2019

Under what conditions is tofu white

Normally, the bean curd is white when it is cold and sealed, and the white moldy bean curd is hairy bean curd. This is the artificial fermentation of tofu to make its surface grow a layer of white fuzz (white mycelium), so it is called "hairy tofu". Tofu is usually covered with straw to hide

Details>

Question time: November 11, 2019

Are Empress Hu and Empress Sun sisters

In the TV drama "Ming Dynasty", Empress Hu and Empress Sun are sisters. They are both the daughters of the imperial doctor Jing Qing. But after the battle of Jingnan, the imperial doctor's family was destroyed. Hu Shanxiang and his sister Sun Ruowei were separated in the war. The sisters were taken by different people

Details>

Question time: July 24, 2020