Re: $$Excel-Macros$$ If condition limitation.

2012-08-29 Thread Kuldeep Singh
MATCH(1,2:2,-1))) >> copy down >> >> Don Guillett >> Microsoft Excel Developer >> SalesAid Software >> dguille...@gmail.com >> >> *From:* mailto:in.vaib...@gmail.com >> *Sent:* Tuesday, August 28, 2012 11:51 PM >> *To:* excel-macros@googleg

Re: $$Excel-Macros$$ If condition limitation.

2012-08-29 Thread in.vaib...@googlemail.com
,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1))) > copy down > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* mailto:in.vaib...@gmail.com > *Sent:* Tuesday, August 28, 2012 11:51 PM > *To:* excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ If condition limitation.

2012-08-29 Thread dguillett1
=IF(ISNA(MATCH(1,2:2,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1))) copy down Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: mailto:in.vaib...@gmail.com Sent: Tuesday, August 28, 2012 11:51 PM To: excel-macros@googlegroups.com Subject: Re: $$Ex

Re: $$Excel-Macros$$ If condition limitation.

2012-08-28 Thread in.vaib...@googlemail.com
PFA Sample Data, if we can do with formula or vba both option is welcome. Rgds Vaibhav On Tue, Aug 28, 2012 at 11:34 PM, wrote: > Hi All > > I have a tracker with almost 10 condition to be tasted. All condition is > shown as header, for case 1 when first event is completed then date of > completi

Re: $$Excel-Macros$$ If condition limitation.

2012-08-28 Thread noorain . ansari
Dear vaibhav, Can you share sample worbook with group Sent from BlackBerry® on Airtel -Original Message- From: in.vaib...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 28 Aug 2012 18:04:01 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If condition

Re: $$Excel-Macros$$ If condition limitation.

2012-08-28 Thread dguillett1
I would do this with a macro. Provide a file to ME along with this msg and examples. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: in.vaib...@gmail.com Sent: Tuesday, August 28, 2012 1:04 PM To: excel-macros@googlegroups.com Su