Dear Ayush , Congrats on your second achievement,
I have a problem with excel.Generally I work with Tally and Excel.When I export accounting Data into excel, I am getting the data with debit and credit along with the number i.e I am getting the data in custom format ( 0.00 Dr). It is not possible to select only debit(dr) or only Credit (Cr)figures at one shot. As it is not possible to select by conditional formatting or by other mode we are selecting the required numbers using filters but that to is a very time consuming and tedious task as the data could range into thousands of numbers and selecting each one using a filter is atime consuming task.I would be truly grateful to you and the group members if any helpis offered in this regard. Regards, VIJAY KUMAR -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel