Mrrrr's Forum
Lista Forumurilor Pe Tematici
Mrrrr's Forum | Lista de useri | Inregistrare | Login

POZE MRRRR'S FORUM

Nu sunteti logat.
Nou pe simpatie:
anais21
Femeie
21 ani
Iasi
cauta Barbat
21 - 36 ani
Mrrrr's Forum / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Top 10 (or more/less) Most Frequent Values in Range/Array Moderat de TonyTzu  
Autor
Mesaj Pagini: 1
Mrrrr
AdMiN

Inregistrat: acum 12 ani
Postari: 1520
Source:
https://www.excelforum.com/excel-genera ... mbers.html

If I wanted to extract the top 10 most frequent values in a range or an array, I would have to do the following array formula:

=MODE(IF(ISNA(MATCH($C$3:$H$1836;$AJ$28:$AJ28;0));$C$3:$H$1836))

To enter this formula press CTRL+SHIFT+ENTER.

Note that almost all cell references are absolute, the one in color is not absolute for the row, only for the column.


_______________________________________


pus acum 2 luni
Site  
Pagini: 1    
Mergi la