Re: $$Excel-Macros$$ Min based on condtions

2013-10-04 Thread Chandra Shekar
* >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >>> *Sent:* Tuesday, October 01, 2013 7:58 PM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* $$Excel-Macros$$ Min ba

Re: $$Excel-Macros$$ Min based on condtions

2013-10-03 Thread ashish koul
t;> =MIN(IF($B$2:$B$10=C2,$A$2:$A$10)) >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >> *Sent:* Tuesday, October 01, 2013 7:58 PM >> *To:* e

Re: $$Excel-Macros$$ Min based on condtions

2013-10-03 Thread Chandra Shekar
ups.com] *On Behalf Of *Chandra Shekar > *Sent:* Tuesday, October 01, 2013 7:58 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Min based on condtions > > ** ** > > Hello, > > > > am trying to get lowest date based on condtion pleas

RE: $$Excel-Macros$$ Min based on condtions

2013-10-03 Thread Ravinder
=MIN(IF($B$2:$B$10=C2,$A$2:$A$10)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Tuesday, October 01, 2013 7:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Min based on condtions Hello, am trying to get

Re: $$Excel-Macros$$ Min based on condtions

2013-10-02 Thread Chandra Shekar
Hello Asish, I tried it and its working fine but I need to know is there any other way to get this result. Regards, Chandra On Wed, Oct 2, 2013 at 12:31 PM, ashish koul wrote: > y dont u try pivot table > > > On Wed, Oct 2, 2013 at 12:28 PM, Chandra Shekar < > chandrashekarb@gmail.com> w

Re: $$Excel-Macros$$ Min based on condtions

2013-10-02 Thread ashish koul
y dont u try pivot table On Wed, Oct 2, 2013 at 12:28 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Asish, > > Please find attached file I have got this result using SUM and IF formula > is there any other way to get the same result. > > Regards, > > Chandra > > On Wed, Oct 2

Re: $$Excel-Macros$$ Min based on condtions

2013-10-01 Thread ashish koul
can u add any example too in the worksheet On Tue, Oct 1, 2013 at 7:58 PM, Chandra Shekar wrote: > Hello, > > am trying to get lowest date based on condtion please find attached file > for the same. Is there anyway to get this without using =min(if(...). > > > Regards, > > Chandra > > -- > Are

$$Excel-Macros$$ Min based on condtions

2013-10-01 Thread Chandra Shekar
Hello, am trying to get lowest date based on condtion please find attached file for the same. Is there anyway to get this without using =min(if(...). Regards, Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook pag