Hi
I have a Column (B) with 101 currency data entries listed within it.
Column (A) lists the office number.
I am trying to get column C to display the ranking of the Data in Column B With the highest value at the Top (Display a 1) to the Lowest (Display 101)
pic.JPG
I have tried a few things including Conditional Formatting but with no luck so far.
Any help would be much appreciated.
Thank you in advance
R
You can use a RANK function.
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks