Chanti_Abbai Posted January 13, 2016 Report Posted January 13, 2016 How to delete the first duplicate entry in Xcel
kiladi bullodu Posted January 13, 2016 Report Posted January 13, 2016 Row daggara mouse petti delete kottu
andhravodu Posted January 13, 2016 Report Posted January 13, 2016 Only 1st and keep other dups? Clarity needed
bob177 Posted January 13, 2016 Report Posted January 13, 2016 You want to delete all duplicates in a column or only first duplicate?
Chanti_Abbai Posted January 13, 2016 Author Report Posted January 13, 2016 Only 1st and keep other dups? Clarity needed idi data for example item Status Date Mango Ordered Jan 01, 2016 Mango Closed jan 13, 2016 we have to del the first entry duplicate keeping only Mango Closed jan 13, 2016
150bryant Posted January 13, 2016 Report Posted January 13, 2016 idi data for example item Status Date Mango Ordered Jan 01, 2016 Mango Closed jan 13, 2016 we have to del the first entry duplicate keeping only Mango Closed jan 13, 2016 excel file ni MS access lo ki ekkinchi.. select * from table group by max( date) cheyochu
andhravodu Posted January 13, 2016 Report Posted January 13, 2016 idi data for example item Status Date Mango Ordered Jan 01, 2016 Mango Closed jan 13, 2016 we have to del the first entry duplicate keeping only Mango Closed jan 13, 2016 Only 1 entry undali ante, data -> remove duplicates, select what columns you want as key
andhravodu Posted January 13, 2016 Report Posted January 13, 2016 excel file ni MS access lo ki ekkinchi.. select * from table group by max( date) cheyochu Vammo, anta akkarledu. Excel is master of data operations, chala varaku simple gane ayipoddi
Chanti_Abbai Posted January 13, 2016 Author Report Posted January 13, 2016 Only 1 entry undali ante, data -> remove duplicates, select what columns you want as key ala chasthae latest entry remove avthundi and old one untundi
andhravodu Posted January 13, 2016 Report Posted January 13, 2016 ala chasthae latest entry remove avthundi and old one untundi Ok, ippudu ardham ayindi. Vere vidham ga try chesta
150bryant Posted January 13, 2016 Report Posted January 13, 2016 ala chasthae latest entry remove avthundi and old one untundi bro follow this http://www.digdb.com/excel_add_ins/filter_maximum_minimum/
bob177 Posted January 13, 2016 Report Posted January 13, 2016 Sort on date column by descending order. And select the item column go to data > remove duplicates.
andhravodu Posted January 13, 2016 Report Posted January 13, 2016 ala chasthae latest entry remove avthundi and old one untundi Oka option patta 2nd date ravataniki Sort by descending chesi, vlookup vadu So, sort chesi, mango unna column ni copy chesi pettu, and use vlookup, adi 1st instance of 2nd value (Date) ni pettiddi for every mango entry. copy this data, and run remove duplicates
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts