李恩銘EXCEL函數MATCH,LARGE,COUNTIF,RANK,PERCENTRANK,PERCENTILE 

max	411	最大	=MAX(題目長度)		
min	32	最小	=MIN(題目長度)		
	126		=MATCH(最大,題目長度,0)		
1	411	=LARGE(題目長度,C510)			
2	332	1	=COUNTIF(題目長度,D511)		
3	281	1			
4	233	2	121	=MATCH(D513,題目長度,0)	
5	233	2			
6	225	1			
7	199	1			
8	188	1			
9	175	1			
					
PR	百分比	PERCENTRANK			
	百分位	percentile			
	四分位	quartile

留言

張貼留言

這個網誌中的熱門文章

李恩銘EXCEL串接字串concatenate試算表歷史

圖片
嵌入embed影片 嵌入網頁電子試算表發展歷史 excel常用函數 https://www.w3schools.com/excel/excel_functions.php Function Description =AND Returns TRUE or FALSE based on two or more conditions =AVERAGE Calculates the average (arithmetic mean) =AVERAGEIF Calculates the average of a range based on a TRUE or FALSE condition =AVERAGEIFS Calculates the average of a range based on one or more TRUE/FALSE conditions =CONCAT Links together the content of multiple cells =COUNT Counts cells with numbers in a range =COUNTA Counts all cells in a range that has values, both numbers and letters =COUNTBLANK Counts blank cells in a range =COUNTIF Counts cells as specified =COUNTIFS Counts cells in a range based on one or more TRUE or FALSE condition =IF Returns values based on a TRUE or FALSE condition =IFS Returns values based on one or more TRUE or FALSE conditions =LEFT Returns values from the left side of a cell =LOWER Reformats content to lowercase =MAX Returns the highest value in a range =MEDIAN Returns the middle v...
閱讀完整內容