Hey All,
I am new to this forum. I am developing a report that requires me to rank users by their usage within a given company. I have looked at other threads, but I couldn't get the solutions to apply to my particular question. A sample from my data set:
1620I13CB5 tjohnston (1000323843) 7.00 1
1CINA1D209 chris (1000316692) 45,764.16 1
1STAA1CE71 dchristian (1000321065) 1,518.39 1
1STAA1CE71 dfalin (1073844954) 68.03 1
1STAA1CE71 mhiggins (1000343906) 15.00 1
1STAA1CE71 jsargent (1000310202) 557.33 1
1STAA1CE71 ewignall (1073844958) 134.34 1
The ranks should read 1, 1, 1, 4, 5, 2, 3. I tried using a rank if formula but I always got 1 for all lines. I tried using sumproducts and I got 1 for all lines as well. I am a little stumped so if anyone has suggestions that would be most helpful. Thank you so much!
Bookmarks