Filter out Ranking's Highest Number

[sdang]

I ranked Guest account based on their playdate. So a guest first playdate  is ranked as 1; second playdate is ranked as 2, and so on.  I got million of rows of data and I want to get the highest ranked number of the guest's.

Please see image below of the sample data.  Now what I want is to take GuestNumber 103726's highest ranked number which is 75 and bring it to another dataset.  How do I go about to do that ?

[sdang · Accepted solution]

Thank you all, I figured it out.