Ask Your Question

HELP with dublicate values

asked 2015-09-03 10:12:44 +0200

skoulikios13 gravatar image

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???

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-09-03 17:33:14 +0200

Regina gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-09-03 10:12:44 +0200

Seen: 79 times

Last updated: Sep 03 '15