Hi Venkat,
I was wondering if you could do away with simple sort command.
Given below is the result i got after sorting the provided data.
Emp id Product
C1101 A
C1104 A
C1107 A
C1110 A
C1113 A
C1116 A
C1119 A
C1102 B
C1105 B
C1108 B
C1111 B
C1114 B
C1117 B
C1120 B
C1103 C
C1106 C
C1109 C
C1112 C
C1115 C
C1118 C
C1121 C
Alternatively, if you have a bigger database, you might also try Pivot
Table. What u'll have to do is put both the fields in Row Labels, with
Product being the first.
Output would look something like this...
Product Emp id
A C1101
C1104
C1107
C1110
C1113
C1116
C1119
A Total
B C1102
C1105
C1108
C1111
C1114
C1117
C1120
B Total
C C1103
C1106
C1109
C1112
C1115
C1118
C1121
C Total
Grand Total
(P.S. - don't worry about the total and subtotal, they can be
excluded.)
Solution sent by Mr Dave is pretty good and interesting. However,
since i have little experience with Index, i am still trying to figure
out how it is working ;)
Bye for now,
Prashant.
On Aug 25, 4:36 pm, Venkatesan c <venkat1....@gmail.com> wrote:
> Dear Kalyan,
>
> My Correct Requirement Is Attached below
>
> On Wed, Aug 25, 2010 at 4:30 PM, Kal xcel <kalx...@gmail.com> wrote:
> > Hi venkat,
>
> > VLOOKUP formula will solveyour problem, see the attachment.
>
> > On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c
> > <venkat1....@gmail.com>wrote:
>
> >> Dear Group,
>
> >> I have attached sample data below i want to get defined criteria Emp id's.
> >> Can i have any formula's or Macros
>
> >> Best Regards,
> >> *
>
> >> Venkat
> >> *
>
> >> --
>
> >> ----------------------------------------------------------------------------------
> >> 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 athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
>
> >> We reach over 7000 subscribers worldwide and receive many nice notes about
> >> the learning and support from the group.Let friends and co-workers know
> >> they
> >> can subscribe to group at
> >>http://groups.google.com/group/excel-macros/subscribe
>
> > --
>
> > ----------------------------------------------------------------------------------
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
>
>
> Help Required Data...1xls.xls
> 43KViewDownload
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
