不常用，挺有用 ...

[zerofive]

不常用，挺有用 LARGE

一般计算某个东西比较好，或者说最早，自然是最大值。Excel里面用MAX，我也是常用MAX，但是前两天要我找第二大、第五大的值。我一下纳闷了，平常没接触这个，我也不好去筛选排序，这会改变别人的表格。

还想着百度一下怎么用MAX计算第二、第五的值，发现这个不常用的函数LARGE。

用法也简单，LARGE(array,k)，array是你要比较的区域或者数组，k就是你要算第几大。不过还是优缺点的，相同的本来是同一个等级，但是它会分为两个等级。不过嘛，对我够用了，也没想怎么去优化这个缺点。

来自于 [WhereIn Android] (http://www.wherein.io)

Comments

[hivebuzz]

Congratulations @zerofive! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You published more than 150 posts. Your next target is to reach 200 posts.

_{You can view your badges on your board and compare to others on the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP}

Do not miss the last post from @hivebuzz:

	The Hive Gamification Proposal
	Hive Revolution - Mission 1 - Communication