tag:blogger.com,1999:blog-7958828565254404797.post755225879761334145..comments2024-03-18T15:20:29.180-07:00Comments on ListenData: How to rank duplicates without breaking sequence in ExcelDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7958828565254404797.post-85800723960368744132019-12-30T18:18:36.963-08:002019-12-30T18:18:36.963-08:00thanks , this solved a big problem ,thanks , this solved a big problem ,GOGhttps://www.blogger.com/profile/11151924287174274578noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-38438553344450783372016-10-10T00:02:39.701-07:002016-10-10T00:02:39.701-07:00Hello..This is very helpful to me in ranking a ran...Hello..This is very helpful to me in ranking a range which has duplicate values. But when I copy the rank to another blank excel with values I get decimal value also ..For Ex. rank 3 showing as 3.000012 and 4 as 4.000036 aswell..how can I prevent this and get only the rank as 3 and 4 ..How to resolve it without a Round(,0)function wrapped your formula? BJAnonymousnoreply@blogger.com