I have a table (tbl) with columns of Site and Sale
I want to Rank the Sales where Site is not blank.
On Column C (Rank) I using =RANK.EQ([@Sale], [Sale], 1) but not sure how to exclude the Site where it is blank so that the resultset would be like Column D (Expected)
Site
Sale
Rank
Expected...