很久以前收藏起来常用的EXCEL小函数，分享一下

vsong · 发表于 2016-6-24 11:21:11

:sweat:我还没有权限发附件么:sleepy:，如果有需要的亲联系我，给我邮箱或者站内加好友应该可以给吧。

不能发图片，复制的排版很乱，大家将就看吧{:1_1:}，需要的我再发给你们

字母索引

	返回目录
	A	average	averagea	ABS	address


	B


	C	counta	count	countblank	ceiling	countif	concatenate	clean

		column	columns	code

	D	date	day	datevalue


	E	exact


	F	find	floor


	G


	H	hour	hyperlink	hlookup


	I	indirect	istext	isnontext	isblank	int	isna	info

		isnumber	islogical	index	if
	J


	K


	L	left	leftb	len	lower	large	lookup


	M	mid	max	maxa	min	mina	month	minute

		mod	match

	N	now


	O	offset


	P	proper


	Q


	R	right	rightb	replace	round	rept	roundup	rounddown

		rows	random	rank	row

	S	search	sustitute	sum	sumif	sign	subtotal	second

		sumproduct

	T	text	today	timevalue	trim	trunc


	U	upper


	V	value	vlookup


	W	weekday


	X


	Y	year