不常用，挺有用 ...

@zerofive 53

almost 4 years ago

不常用，挺有用 LARGE

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

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

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

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

cn wherein hive-193552 lifestyle marlians mediaofficials catnearn palnet whalepower upfunme actnearn neoxian zzan

0.000

1 comments

@hivebuzz 74

almost 4 years ago

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

0.000