How to show value a sales name by reference a high sales number

[eddorena]

Hi there,

I need help with the proper formula to show in F13 the name agent Tanjung with reference he have the highest commission 300,000, and F14 is amount 300,000

I already try with sum function, however, not work properly.

Thank you in advance for the help and advice

 

[Fluff]

In that case I have no idea why you are getting the results horizontally, rather than vertically.
If you put this into a cell

=SEQUENCE(3)

then click into the formula bar & hit F9 what exactly do you see?

 

[eddorena]

In that case I have no idea why you are getting the results horizontally, rather than vertically.
If you put this into a cell

=SEQUENCE(3)

then click into the formula bar & hit F9 what exactly do you see?

Here is the result

 

[Fluff]

Thanks for that. I have no idea why the formula I supplied is not spilling vertically, as it should do.

 

[eddorena]

Thanks for that. I have no idea why the formula I supplied is not spilling vertically, as it should do.

So in your excel the result is vertical not horizontal?

It's Ok Fluff, it's not a big deal and I may can ask to uncle "G" someday

Have a great day Fluff

 

[Fluff]

So in your excel the result is vertical not horizontal?

Yup.

+Fluff 1.xlsm
	E	F
1
2	a	73000
3	b	75000
4	a	68000
5	b	73000
6	c	92000
7	a	75000
8	b	76000
9	e	75000
10
11
12
13		b
14		224000
Primary

Cell Formulas
Range	Formula
F13:F14	F13	=LET(u,UNIQUE(E2:E11),INDEX(SORT(CHOOSE({1,2},u,SUMIFS(F2:F11,E2:E11,u)),2,-1),1,{1;2}))
Dynamic array formulas.