![]() ![]() Table 1 B2 =IFERROR(INDEX(Table 2::A,MATCH(LARGE(Table 2::C,ROW(cell)−1),Table 2::C,0),column-index,area-index),"")Ĥ) One question remains: do you care if there are ties? The list appears to be rank ordered but could contain ties and you would not know. You can eliminate them by trapping the error. Table 2 C2 = IF(B2="","",COUNTIF(A,B2)+ROW()÷100000)ģ) There may be some error triangles if MATCH does not find a match. ![]() Adding the row number (divided by a large value) to each count will make each count unique so that all top results end up in the results. Table 2 B2 =IF(COUNTIF(A$1:A2,A2)>1,"",A2&"")Ģ) If there is a tie, only one of those words will be in the results and it will be listed more than once. This will have no effect on the strings but will turn blanks into null strings so they transfer over looking empty. In Table 2 B2 I would add &"" to the strings. ![]() They might not be an issue with a large list of words but you never can tell.ġ) If you are looking for four top results but there are fewer than that, there may be some zeros in the list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |