$$Excel-Macros$$ SUMIF for multiple conditions

2009-05-29 Thread Nidhesh Dhawan
Hi, Can any body help me with applying sumif formulae with multiple conditions. I have following reservations: 1) Don't want to use Array formulae. 2) Don't wat to use DSUM. 3) Dont want to apply concatenate. Please send me an example if possible. Thanks, Nidhesh --~--~-~--~~--

$$Excel-Macros$$ Re: Date Problem

2009-01-30 Thread Nidhesh Dhawan
Attached sheet contains the solution, let me know if you are looking for something else Thanks, Nidhesh   On Thu, 29 Jan 2009 Chaudhry Zahid Ali wrote : >Hi, > >I have got a little problem that I need to solve I have a sheet with >multiple transactions. The columns include Date and amo

$$Excel-Macros$$ Re: Lookup for repetitive items

2008-10-30 Thread Nidhesh Dhawan
ord and to skip that record subsequenly.The above problem is explained in >the attached sheet.P.S. Would prefer an excel solution rather than a code.Pls >help !!.Thanks,Nidhesh > > > >Explore the seven wonders of the world >http://search.msn.com/results.aspx?q=7+wonders+worl

$$Excel-Macros$$ Lookup for repetitive items

2008-10-23 Thread Nidhesh Dhawan
Hi all, I need to apply lookup for repetitive items, if I use normal vlookup, it returns the value with matches with the first record. Is there any way to get 1st value for 1st record and to skip that record subsequenly. The above problem is explained in the attached sheet. P.S. Would prefer