Hi, I am trying to build a xl sheet for automation of the work that we do. I am stuck in a point were i find difficult to move ahead.
my problem is below 1. i need to find from a column which are unique names Exp. in one column i have list populating : a, b, c, a, f, d, c, e, b. it should populate only a, b, c, d, e, f. in a column. 2. Then It should select all the rows containing the above unique values and populate the minimum and maximum dates respectively from the table. For exp. if the data is *name type st_date end_date* kun-1 a 10-jun-09 16-June-09 kun-2 b 14-jun-09 20-June-09 kun-3 a 17-jun-09 22-June-09 kun-4 b 18-jun-09 21-June-09 .... then it should populate as below *type st_date end_date* a 10-jun-09 22-June-09 and the final table should look like this *type st_date end_date* a 10-jun-09 22-June-09 b c d e f Please help as this is very urgent Thanks in Advance. Regards, Kunal Rout --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
help.xls
Description: MS-Excel spreadsheet
