Construction of PIVOT TABLE may solve your problem.. Select Count instead of values in Data field..
ankur lodha > Date: Tue, 17 Mar 2009 00:04:07 -0700 > Subject: $$Excel-Macros$$ Repeated Value in a Column > From: [email protected] > To: [email protected] > > > Dear All > How to find out repleated value in a column. > > Thanks > Gohar > > > _________________________________________________________________ So many new options, so little time. Windows Live Messenger. http://www.microsoft.com/india/windows/windowslive/messenger.aspx --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
