Thread: Dropping lowest 2 values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default Dropping lowest 2 values
Suppose the 24 columns are A-X and your current
sums are in Y, e.g.with formula ==SUM(A1:X1).
Then change that formula to, or put in another cell:
=SUM(A1:X1)-SMALL(A1:X1,1)-SMALL(A1:X1,2)

HTH,
Merjet


Reply With QuoteReply With Quote