after examining your sheet.... i find that there are four rows which have the same combination of "branch and account" (you say they are unique) with different values of closing balance.... so how do i differentiate among them..... how do i find unique "branch and account".. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 9:19 PM, Aamir Shahzad <aamir...@gmail.com> wrote: > Dear Vivek Agrawa, > > Thanks for reply. Please find attachment. In attachment two sheet available > "Main sheet" where I want to fill information in column "Closing Balance" & > second "Source Sheet" from where I want to pick the "Closing Balance". > Remeber both sheet's data is same. Often time I have data in scattered form. > e.g. Name & product missmatch. Unique is just "Branch & Account". > > But I am troubling to make a unique key for "sumif" or "vlookup" function. > This is just example I handle data which consist thousands of rows & > columns. > > Thanks & regards, > > Aamir Shahzad > > > ----- Original Message ----- > *From:* vivek agrawal <vivek.agrawa...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, July 22, 2009 9:47 AM > *Subject:* $$Excel-Macros$$ Re: how to make unique key > > Can u please mail a sample excel sheet to make your doubt somewhat more > clear. > Thanks and Regards, Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > On Tue, Jul 21, 2009 at 11:54 PM, Aamir Shahzad <aamir...@gmail.com>wrote: > >> Dear all, >> >> Can anyone tell me please "How to make unique key" for pick required data >> from one sheet to another. If there is no similarity. e.g. for use of >> vlookup or sumif funtions. Reply will highly appriciated. >> >> Regards, >> >> Aamir Shahzad >> >> >> > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
