tag:blogger.com,1999:blog-7958828565254404797.post1595476221860965345..comments2024-03-27T11:03:10.938-07:00Comments on ListenData: Count Duplicate Values in a rangeDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7958828565254404797.post-49659402311947237162020-07-08T05:32:25.626-07:002020-07-08T05:32:25.626-07:00Code Name EndDate ExpiryDate
1 Deepa 31/07/2020 ...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 />Free Birdhttps://www.blogger.com/profile/16181406245963054877noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-79578399160290239642020-07-08T05:29:47.867-07:002020-07-08T05:29:47.867-07:00hi.. i have data where i have duplicate records on...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 appearFree Birdhttps://www.blogger.com/profile/16181406245963054877noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-42315640942119437382018-01-25T12:26:07.327-08:002018-01-25T12:26:07.327-08:00I want to count COUNT DUPLICATE VALUES IN A RANGE ...I want to count COUNT DUPLICATE VALUES IN A RANGE but with another criteria (Y) represented by numerical value 0-8. If Y>4 then the rank value of the data will be send backward in the sequence.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-57815569132269802322015-09-23T12:28:11.045-07:002015-09-23T12:28:11.045-07:00Very helpful formula. Thank you.Very helpful formula. Thank you.Anonymousnoreply@blogger.com