Groups > microsoft.public.excel.programming > #111204

Need to create custom function of this formula

From	Dishant Rai <Dishant.Rai.18157b88@excelbanter.com>
Newsgroups	microsoft.public.excel.programming
Subject	Need to create custom function of this formula
Date	2019-11-16 09:19 +0000
Message-ID	<Dishant.Rai.18157b88@excelbanter.com> (permalink)
Organization	ExcelBanter.com

Show all headers | View raw

Can someone create a custom user defined function for this formula

The only thing variable would be the range / array i.e. C8:C57

=IF(COUNT(C8:C57<6,"",IF(COUNT(C8:C57<6),"",IF(MOD((50/100)*COUNT(C8:C57),1)>0,SMALL(C8:C57,INT((50/100)*COUNT(C8:C57))+1),AVERAGE(SMALL(C8:C57,INT((50/100)*COUNT(C8:C57))),SMALL(C8:C57,INT((50/100)*COUNT(C8:C57))+1)))))




-- 
Dishant Rai

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Need to create custom function of this formula Dishant Rai <Dishant.Rai.18157b88@excelbanter.com> - 2019-11-16 09:19 +0000
  Re: Need to create custom function of this formula superHamster <imUNDERSCOREreallyUNDERSCOREconfused@hotmailDOTcom.REMOVETHIS> - 2019-11-18 01:20 +0000

csiph-web