Archive for LARGE function
The LARGE function calculates the k-th largest value from an array of numbers. Use the LARGE function, for example, to extract […]
Here comes another post about the MMULT function, today I made a dynamic scoreboard. There are five women competing and there […]
Calculate average of last 10 data with possible blank cells
Question: Answer: This array formula creates a dynamic range, filtering the 10 last data. Adjust cell ranges $A$1:$A$25 in formula below. […]
Dynamic team generator in excel
Mark G asks: 1 - I see you could change the formula to have the experssion COUNTIF($C$1:C1, $E$2:$E$5)<5 changed so […]
Overview This article describes how to create a random playlist of four teams total. Column A contains four teams. Each […]
Extract largest values from two columns
Question: How do I extract the five largest values from two or more columns? Answer: Formula in A12: =INDEX(tbl, SMALL(IF(LARGE(tbl,ROW(A1))=tbl, […]
How to create a list of random unique numbers
Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and […]
Create a unique distinct list and sort based on frequency
Question: How do I create a new unique distinct list from a column. I also want the list sorted from large […]
Extract unique distinct values from a multi-column cell range
Question: I have cell values spanning over several columns and I want to create a unique list from that range. […]
