Conditional MAX and RANK of 18-digit text numbers using dynamic array formulas

Hi,

Please see attached workbook. I have a list of 18-digit numbers stored as text that I want to apply conditional MAX and RANK functions to, resulting in a dynamic array as output. One challenge is that when the 18-digit numbers are converted from text to numbers, Excel will only keep the 15 first digits and replace the rest with zeroes. After running these numbers through a MAXIF function to get the largest number within each category, I want to rank all the numbers in the resulting list. This ranking should give ties the same rank, but increase the rank incrementally for increasingly larger numbers. In the attached workbook, I want to skip helper columns C and D and go directly from the data in column A and B to the result in column E.

Best regards,
Marbleking

Please try

=MMULT(--(VLOOKUP(A2:A33,SORT(A2:B33,{1,2},-1),2,)>TRANSPOSE(VLOOKUP(UNIQUE(A2:A33),SORT(A2:B33,{1,2},-1),2,))),SEQUENCE(ROWS(UNIQUE(A2:A33)))^0)+1

Post deleted.