Re: $$Excel-Macros$$ Formula for Unique Values with Condition

2012-03-28 Thread pawel lupinski
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

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

2012-03-28 Thread dguillett1
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

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

2012-03-28 Thread Kiran Kancherla
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

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

2012-03-28 Thread dguillett1
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,