<?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.post1595476221860965345..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: Count Duplicate Values in a range</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/1595476221860965345/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/03/count-duplicate-values-in-range.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>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4965940231194723716</id><published>2020-07-08T05:32:25.626-07:00</published><updated>2020-07-08T05:32:25.626-07:00</updated><title type='text'>Code Name EndDate ExpiryDate
1 Deepa 31/07/2020 ...</title><content type='html'>Code Name EndDate ExpiryDate<br />1 Deepa 31/07/2020 Expired or expiring within 6 months<br />1 Anu 31/08/2022 Expiry 2-3 years<br />2 Trishika 30/04/2020 No Expiry Date<br />2 Trishika No Expiry Date<br />3 abc 31/08/2024 Expiry 5 years or more<br />3 abc 01/09/2022 Expiry 5 years or more<br />4 asd No Expiry Date<br />4 asd No Expiry Date<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/4965940231194723716'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/4965940231194723716'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/03/count-duplicate-values-in-range.html?showComment=1594211545626#c4965940231194723716' title=''/><author><name>Free Bird</name><uri>https://www.blogger.com/profile/16181406245963054877</uri><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/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2014/03/count-duplicate-values-in-range.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1595476221860965345' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1595476221860965345' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1009017338"/><gd:extendedProperty name="blogger.displayTime" value="July 8, 2020 at 5:32 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7957839916029023964</id><published>2020-07-08T05:29:47.867-07:00</published><updated>2020-07-08T05:29:47.867-07:00</updated><title type='text'>hi.. i have data where i have duplicate records on...</title><content type='html'>hi.. i have data where i have duplicate records on the basis of Code,name,and date column and i have to set a status for expiry date so if i have duplicate record on the basis of Code+name then i will check date.<br />If both the dates are same then date will come in expiry date<br />If one date is blank and another date is available then blank status will appear stating as No expiry <br />if both dates are different then maximum date will appear</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/7957839916029023964'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/7957839916029023964'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/03/count-duplicate-values-in-range.html?showComment=1594211387867#c7957839916029023964' title=''/><author><name>Free Bird</name><uri>https://www.blogger.com/profile/16181406245963054877</uri><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/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2014/03/count-duplicate-values-in-range.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1595476221860965345' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1595476221860965345' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1009017338"/><gd:extendedProperty name="blogger.displayTime" value="July 8, 2020 at 5:29 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4231564094211943738</id><published>2018-01-25T12:26:07.327-08:00</published><updated>2018-01-25T12:26:07.327-08:00</updated><title type='text'>I want to count COUNT DUPLICATE VALUES IN A RANGE ...</title><content type='html'>I want to count COUNT DUPLICATE VALUES IN A RANGE but with another criteria (Y) represented by numerical value 0-8. If Y&gt;4 then the rank value of the data will be send backward in the sequence.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/4231564094211943738'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/4231564094211943738'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/03/count-duplicate-values-in-range.html?showComment=1516911967327#c4231564094211943738' 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/2014/03/count-duplicate-values-in-range.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1595476221860965345' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1595476221860965345' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 25, 2018 at 12:26 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5781556913226980232</id><published>2015-09-23T12:28:11.045-07:00</published><updated>2015-09-23T12:28:11.045-07:00</updated><title type='text'>Very helpful formula. Thank you.</title><content type='html'>Very helpful formula. Thank you.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/5781556913226980232'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1595476221860965345/comments/default/5781556913226980232'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/03/count-duplicate-values-in-range.html?showComment=1443036491045#c5781556913226980232' 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/2014/03/count-duplicate-values-in-range.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1595476221860965345' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1595476221860965345' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2015 at 12:28 PM"/></entry></feed>