I am trying to use LARGE with VLOOKUP to rank items in a list so that I can create a Pareto chart. Everything works fine unless two of the items have the same value. Then I get a repeated value rather than a ranking.
example
A1=19 B1=X
A2=20 B2=Y
A3=19 B3=Z
I am trying to get these automatically sorted in ascending numerical order without having to manually run a sort(in another cell range).
example
A1=19 B1=X
A2=20 B2=Y
A3=19 B3=Z
I am trying to get these automatically sorted in ascending numerical order without having to manually run a sort(in another cell range).