Hi Kiran,
the easiest way of doing it is pivot table (so you can manage as you want)
both request attached. From the macro point of view I can't help you
with, but I've got your piont sometimes you want to see it to be able to learn
it.
Regards,
Pawel
ps I couldn't send you attachment - limi
m
Subject: Re: $$Excel-Macros$$ Formula for Unique Values with Condition
Why not just use data>filter>autofilter
see att
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kiran Kancharla
Sent: Wednesday, March 28, 2012 1:43 PM
To: excel-macros@googlegroups.com
Sub
ards.
Kiran
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Wed, 28 Mar 2012 14:07:13
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula for Unique Values with Condition
Why not just use data>filter>aut
Why not just use data>filter>autofilter
see att
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kiran Kancharla
Sent: Wednesday, March 28, 2012 1:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula for Unique Values with Condition
Hi All,
In the attached file I have names of the people who left the company.
I need a formula to Extract the names of the Team Leader's and Team
Manager's, where in Column "C" have Agent.
I mean, I want to get only those Names, where they have attrition for
"Agent"
Request you to please help m
