Current location - Training Enrollment Network - Mathematics courses - Excel table function value selection
Excel table function value selection
As shown in the figure:

Use the following formula to get the score of the first place in the total score of science:

=MAX((A2:A 1000= "science") *L2:L 1000)

Array formula, press CTRL+SHIFT+ ENTER to complete the formula.

Related articles
  • How about using "optimal design" in senior two? How about the new high school mathematics curriculum standard? Or the synchronized version of 5.3? Or a two-speed learning book?
  • Math problem 2 1-22
  • The title of the math contest
  • A girl answered a number of 2000. What do you mean? Please answer the girls.
  • Characteristics of College of Mathematics and Statistics of Northeast Normal University
  • Children have been tired of mathematics since the third grade and don't want to learn it. What should I do?
  • What does digital energy mean?
  • Which university in Taiwan Province Province has a better math major?
  • How to use modeling ideas in chemistry learning
  • 63.5กม88mm is a small card of several inches.

    • copyright 2024 Training Enrollment Network All rights reserved