Re: $$Excel-Macros$$ Need Help

2011-01-17 Thread in.vaib...@googlemail.com
Hi Se att, u can do with pivot table. Rgds Enjoy excelling... On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose wrote: > Dear Team, > > Please find attach file in which i have explained my requirement and > request of your kindness to provide me the solution, *as i have more than > 4000 record

Re: $$Excel-Macros$$ Query

2011-01-17 Thread in.vaib...@googlemail.com
Dear Amir, Pl provide more clarity wid complete example. http://www.signaturebar.com/>http://www.signaturebar.com/uploads/images/24667.png border=0> On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad wrote: > Dear experts, > > > > How to resolved attached query, can anybody tell formula not macro

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-29 Thread in.vaib...@googlemail.com
Hi Don, This work on logic that this formulae returns nearest max vaue to -1 that is cell refering to highest date. If i want this to return cell refering to lowest date then how can we et it. Rgds Vaibhav On Wed, Aug 29, 2012 at 7:07 PM, dguillett1 wrote: > =IF(ISNA(MATCH(1,2:2,-1)),"",IND

Re: $$Excel-Macros$$ Need Suggestion urgent

2010-11-25 Thread in.vaib...@googlemail.com
Hi, I am working on it. Will send you by tomorrow. Thanks for waiting. On Thu, Nov 25, 2010 at 10:03 AM, Ankit Agrawal wrote: > Sir ji, > > I think it does not have any solution that why no body given any ans.or any > solution. > > > -- Forwarded message -- > From: Ankit Agrawa

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-30 Thread in.vaib...@googlemail.com
Dear Rahul Pl explain the procedure, if you are saying you will be sending it to 9000, then will you be using mail merge or not. If not how u will be sending (i.e. using which application) to 9000 employees. Rgds Vaibhav J On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. wrote: > Sir, > > Tha

Re: $$Excel-Macros$$ Queries

2010-12-04 Thread in.vaib...@googlemail.com
Hi, Try Sumproduct formula Rgds Vaibhavj On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote: > Hi Everyone. > > I have large data in excel. for example in sheet 1. and we have name in > sheet 2 . I use vlookup function and fetch the production using vlookup . > now when i saw the total there i