Re: $$Excel-Macros$$ *Comparing two columns and sum unique values in excel *

2011-09-13 Thread dguillett1
mp; ":" & sc & "," _ & dc & "2" & "," & sumc & ":" & sumc & ")" .Value = .Value End With End Sub -----Original Message- From: Prabhu Sent: Monday, September 12, 2011 8:45 PM To: MS EXCEL AND VBA MACROS

Re: $$Excel-Macros$$ *Comparing two columns and sum unique values in excel *

2011-09-12 Thread Suman
Hi,Prabhu! All !dias are great...! simply you should use someif. On Tue, Sep 13, 2011 at 10:51 AM, NOORAIN ANSARI wrote: > Dear Prabhu, > > Please see attached sheet.. > Conditional SUM thourgh VBA.. > > > > > On Tue, Sep 13, 2011 at 7:15 AM, Prabhu wrote: > >> Hi All, >> >> I need to compare t

Re: $$Excel-Macros$$ *Comparing two columns and sum unique values in excel *

2011-09-12 Thread NOORAIN ANSARI
Dear Prabhu, Please see attached sheet.. Conditional SUM thourgh VBA.. On Tue, Sep 13, 2011 at 7:15 AM, Prabhu wrote: > Hi All, > > I need to compare two columns and sum the unique value. > > Example: > > Apple 10 > Orange 5 > Apple 20 > Mango 25 > Orange 15 > Mango 7 > > > Result

Re: $$Excel-Macros$$ *Comparing two columns and sum unique values in excel *

2011-09-12 Thread XLS S
Use sumif or put pivot tableplease find the attachment.. On Tue, Sep 13, 2011 at 7:15 AM, Prabhu wrote: > Hi All, > > I need to compare two columns and sum the unique value. > > Example: > > Apple 10 > Orange 5 > Apple 20 > Mango 25 > Orange 15 > Mango 7 > > > Result > > Apple 30

$$Excel-Macros$$ *Comparing two columns and sum unique values in excel *

2011-09-12 Thread Prabhu
Hi All, I need to compare two columns and sum the unique value. Example: Apple 10 Orange 5 Apple 20 Mango 25 Orange 15 Mango 7 Result Apple 30 Orange 20 Mango 32 Plz help to know the formula. Regards, Prabhu -- --