hi guys, i have a problem with an excel sheet. In a few words, i have 2 columns.e.g F and G. In F are all possible scores of a football match and in G are the possibilities in %. (using poisson distribution). In the next column i have used LARGE function to row the first 5 possible outcomes. e.g 2-0,1-1,2-1,1-0,0-1 with their %possibility. e.g 22%,13% and so on. My problem is that, when the %possibility is the same for 2 scores e.g 12.5% for both 2-0 and 2-1, then it shows me in the column the one score twice. e.g two times the 2-0 or two times the 2-1, intead of showing both scores. What can i do???
You can sort the source data, but do not overwrite the source range but put the sort result to a different place (see Options tab). When you name the source range, you can update the sorted area without redefining the sorting. Then you can reference the top five lines for your target.