Forum Discussion
Excel calculating modus is not always correct AGGREGATE(13;3;VALUES);
Hello, Given are the values 37, 38, 38 ,39, 40, 40. The aggregate function AGGREGATE(13;3;VALUES) returns 38 But the with the function table We see that the values 38 AND 40 ...
Thanks,
Now I get the different modi in different cells.
How can I collect these values in one string to show them together in one cell?
Hello SergeiBaklan,
It works pefect, thanks.
I have added the sort function in your formula to have the numbers always in a good numeric order.
Greetings
Erwin
You are welcome, glad to help
Hello SergeiBaklan
When you take a few numbers, all different from each other for example 2 ; 15 ; 28 ; 34 ; 17 (so all the numbers are only mentionned once)
then every of the next formulas Aggregate ( 13;3;... ) ; MODE.SNGL(values) ; MODE.MULT(values) give errors, none of them gives the right answer i.e. 2 , 15, 28 , 34 , 17
Greetings
Erwin