the attached sheet was just example, there are hundred of branches & account
numbers in my data. Branch code is unique but repeat many times and same like
branch account number is unique but repeat many times. But you can see that
product is unique of one customer. I often use formula =A2&"-"&B2 in source and
main sheet which return 1-426 but it's repeat so many times therefore if I use
sumif function it's return same value in one customer which repeated many
times.
I need the another column which make unique key e.g. 1-426-uniquevalue. so that
I can put the proper outstanding value infront of proper product of a proper
customer.
I hope you understand my issue and will solve it.
Regards,
Aamir Shahzad
----- Original Message -----
From: vivek agrawal
To: excel-macros@googlegroups.com
Sent: Thursday, July 23, 2009 9:17 PM
Subject: $$Excel-Macros$$ Re: how to make unique key
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
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
-~----------~----~----~----~------~----~------~--~---
