Ranking in pivot table - to rank base on best price offer

[limfungkeat]

Hi Gurus out there , read about the Rank() functions and also lots of example . However , those are like Rank on the highest value ..how to display something like the below in a pivot table ? 

[lironbaram · Accepted solution]

hi 

if you want to rank according to the smallest value 

there is a simple trick (assuming all values are positive ) you can just use 

rank (-priceoffrer)

[limfungkeat]

Thank you so much Lironbaram !  ...it will be my best Christmas present . 

[lironbaram]

hi 

glad i could help 

merry Christmas