https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497100#M138460 <PRE><CODE>your search |sort 0 - count | dedup Date </CODE></PRE> Tue, 17 Mar 2020 21:43:10 GMT to4kawa 2020-03-17T21:43:10Z https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497098#M138458 <P>Assuming there are 2 columns - Date &amp; count and there are duplicates date.</P> <P>How to dedup on Date and pick the maximum count value ?</P> <PRE><CODE>2020-02-27 1522 2020-02-27 1680 2020-02-28 1639 2020-02-28 1639 2020-02-29 5 2020-02-29 5 </CODE></PRE> <P>Please guide.</P> Tue, 17 Mar 2020 21:19:41 GMT https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497098#M138458 reverse 2020-03-17T21:19:41Z https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497099#M138459 <P>@Vijeta - buddy .. you around ?</P> Tue, 17 Mar 2020 21:20:36 GMT https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497099#M138459 reverse 2020-03-17T21:20:36Z https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497100#M138460 <PRE><CODE>your search |sort 0 - count | dedup Date </CODE></PRE> Tue, 17 Mar 2020 21:43:10 GMT https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497100#M138460 to4kawa 2020-03-17T21:43:10Z https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497101#M138461 <P>thank you .. worked like a charm!!!</P> Tue, 17 Mar 2020 21:50:05 GMT https://community.splunk.com/t5/Splunk-Search/dedup-maximum-value/m-p/497101#M138461 reverse 2020-03-17T21:50:05Z