Rank Function

Thanks for the input data.

I want to help you but your description is too vague and jumbled.
Considering deleting this post and starting from scratch.  

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming

* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Avoid describing the problem in multiple, fragmented and conflicting posts. Try describe the problem with input data, output example and the step-by-step process in one post.