FirstSortedValue for each name

[entsh]

hi

Please see the below table

name	id	number	level
teh	1	0	A
teh	2	0	A
teh	3	1	A
teh	4	1	A
SO	8	1	A
SO	9	1	B
SO	12	1	C
teh	15	1	B
teh	19	1	B
SO	20	1	C
teh	25	1	B
SO	26	1	C

I want the last level of each name (largest id)

I want this:

NAME	RESULT
teh	B
so	C

so I use this formula

=firstsortedvalue(level, -id, 1) and its ok ! 

but i want to use variable! vll=firstsortedvalue(level, -id, 1) and this variable return C for both names and this is wrong answer!

please help me 🙂

[Or]

Using your formula on your data returned this...

[entsh]

YES but I used variable ! vLL=firstsortedvalue(level, -id, 1) and use a variable in expressions

it returns C for both names!

how can I use a variable instead of write a formula?

[Or]

No idea! If you'd asked that in the first place I would have left this for someone else to try and answer... (;

[entsh]

I appreciate your attention 🙂

[Or · Accepted solution]

I'd give it a whirl with using a string variable and evaluating it within the expression. No idea if that'd work, but that's my best bet.

firstsortedvalue(level, -id, 1)

with no equal sign (so it's a string, not a formula)

Then, =$(vLL) in your expression.

[entsh]

THX A LOT 🙂