Remove duplicates in column A, leaving the one with the highest number in column B?

A formula any use to you:

=LET(A,A2:A9,B,B2:B9,C,UNIQUE(A),D,MAP(C,LAMBDA(z,TAKE(SORT(FILTER(B,A=z),,-1),1))),HSTACK(C,D))

Yes. That's all's needed.

Or you could do this (make it future proof, - just don't go mad with the end point):

=LET(A,TOCOL(A2:A100,1),B,TOCOL(B2:B100,1),C,UNIQUE(A),D,MAP(C,LAMBDA(z,TAKE(SORT(FILTER(B,A=z),,-1),1))),HSTACK(C,D))

You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Originally Posted by Glenn Kennedy

Yes. That's all's needed.

Or you could do this (make it future proof, - just don't go mad with the end point):

=LET(A,TOCOL(A2:A100,1),B,TOCOL(B2:B100,1),C,UNIQUE(A),D,MAP(C,LAMBDA(z,TAKE(SORT(FILTER(B,A=z),,-1),1))),HSTACK(C,D))

You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Ok, ran into a problem here.

How do I increase the E/F columns from 88 to more like 500? When I click on the area at the top to edit the function, it disappears. So I can't edit it.

Given that there are only 2 columns in columns E & F, I have no idea where you get a figure of 88 from. I have absolutely no idea where 500 columns comes into it...

You will need to provide an updated sample. Did my formula work fully for the TWO columns in your original sample