Excel BI Challenge Workout 189

Workouts Excel BI Challenge
21

LinkedIn post by:
Hussein SATOUR

Thank you Excel BI

=LET(n,A2:A20,MAP(n,LAMBDA(x,COUNTIF(x:TAKE(n,-1),">"&x))))

22

LinkedIn Post by:
Guillermo Arroyo

=MAP(A2:A20,LAMBDA(a,SUM(--(a:A20>a))))

23

LinkedIn Post by:
Liz Larsen, P.E.
 

=BYROW(A2:A20,LAMBDA(x,COUNTIF(x:A20,">"&x)))
24

LinkedIn post by:
Caroline Blake
 

=BYROW(A2:A20,LAMBDA(x,SUM(--(x:A20>x))))
25

LinkedIn Post by:
Alejandro Simón

adjunto otra query, utilizando funciones de listas…

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Sol = List.Transform({0..List.Count(Source[Numbers])-1}, each
let
a = List.Skip(Source[Numbers], _),
b = Source[Numbers]{_},
c = List.Difference(a,{ b}),
d = List.Count([List.Select](http://list.select/)(c, each _ > b))
in d)
in
Sol
26

LinkedIn post by:
Abdul Said M K.

Forgive my Non-Elegant solution :joy::joy::joy:

=COUNTIF($A$2:$A$20,">" & A2) then fill-down