<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-7958828565254404797.post755225879761334145..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: How to rank duplicates without breaking sequence in Excel</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.listendata.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/755225879761334145/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/05/ranking-duplicates-same-rank-without.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><author><name>Deepanshu Bhalla</name><uri>http://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>2</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8580072396036874413</id><published>2019-12-30T18:18:36.963-08:00</published><updated>2019-12-30T18:18:36.963-08:00</updated><title type='text'>thanks , this solved a big problem ,</title><content type='html'>thanks , this solved a big problem ,</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/755225879761334145/comments/default/8580072396036874413'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/755225879761334145/comments/default/8580072396036874413'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/05/ranking-duplicates-same-rank-without.html?showComment=1577758716963#c8580072396036874413' title=''/><author><name>GOG</name><uri>https://www.blogger.com/profile/11151924287174274578</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='18' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9Mqd74KllcTi8kqUS3L77Cd78vRDDRXZZcPOMR9R3twC-3bNSKR7Jp5iiaLsIbv0icj7Gg1guI69-GE9JSfKJz3Jkv8Dj23GZ0piUdb3WbneY5DKGfHzOXCu1-EahZfdGRI-13Fr94CzzWobXOLF5wdndZ80K5L4Mu-KxJhMjMLpJ3TI/s220/a3.png'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/05/ranking-duplicates-same-rank-without.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-755225879761334145' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/755225879761334145' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-923250642"/><gd:extendedProperty name="blogger.displayTime" value="December 30, 2019 at 6:18 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3843855334445078337</id><published>2016-10-10T00:02:39.701-07:00</published><updated>2016-10-10T00:02:39.701-07:00</updated><title type='text'>Hello..This is very helpful to me in ranking a ran...</title><content type='html'>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?   BJ</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/755225879761334145/comments/default/3843855334445078337'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/755225879761334145/comments/default/3843855334445078337'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/05/ranking-duplicates-same-rank-without.html?showComment=1476082959701#c3843855334445078337' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/05/ranking-duplicates-same-rank-without.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-755225879761334145' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/755225879761334145' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="October 10, 2016 at 12:02 AM"/></entry></feed>