$$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Group I have data which has repeated values for a set of product every month for 12 months Need the output as total for each product ( sumif formula helps here) But the requirement is, in the summary if the month is changed, then the output has to be the sum total for each product for the res

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Radhe, PFA the attached solution Regards, Andy On Wed, Jun 30, 2010 at 12:44 PM, Radhe Sham wrote: > Hi Group > > I have data which has repeated values for a set of product every month for > 12 months > > Need the output as total for each product ( sumif formula helps here) > > But the requ

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Andy, Thanks for the quick reply. The requirement however is to get the output in another sheet wherein the summary of the products is mentioned in the first column and the desired month is placed on the top as a dropdown list. The result is required to be displayed in the 2nd column for whic

$$Excel-Macros$$ project on whole word/excel/powerpoint

hi can anybody has any project/file which covers all the functions and options of the word / excel/ powerpoint???// -- Pooja -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Dear Freinds, I am Chitra from Recruitment Pro.. We are a Hr Consultant Based in G.K 2. Right now i want a MIS- Asst Manager for Citi Designation- Asst Manager Company - Citi Financial (In the payroll of Jra & Associate) Location - Pushpa Vihar Salary - Between 12 k to 15 k Please refer some nam

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Radhe, PFA the attached solution Regards, Gaurav Jain On Wed, Jun 30, 2010 at 2:54 PM, Radhe Sham wrote: > Hi Andy, > > Thanks for the quick reply. > > The requirement however is to get the output in another sheet wherein the > summary of the products is mentioned in the first column and t

$$Excel-Macros$$ arithmetic progression like

Hi, How do i write a vba for user form, in which i want to give an option for filling rows/columns depending on the step value . that is, The inputs will be: input value(starting value) step value (common difference) last value(number of va

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

4 variours formulas reuired... sample attached along... Regards, Jay S On Wed, Jun 30, 2010 at 3:21 AM, r wrote: > > > On 29 Giu, 12:05, lucky singh wrote: > > Hi All, > > > > 1. I want to extract all the numbers > > 2. I want to trim only the middle name > > > > Regards, > > Jay S > > > >

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

Hi Jay, I could get solutions for couple of things only. Regards DeviPrasad On Wed, Jun 30, 2010 at 4:03 PM, lucky singh wrote: > > 4 variours formulas reuired... > sample attached along... > Regards, > Jay S > > > On Wed, Jun 30, 2010 at 3:21 AM, r wrote: >> >> >> On 29 Giu, 12:05, lucky sing

$$Excel-Macros$$ Keywords from QuickBasic to VBA

Hi Paul, I was referred by Dave Bonallak, I would appreciate any help you can give. I have a very old program written in QuickBasic 4.5 which does a lot of statistics and printing the results in colorful graphic charts. I could use a lot of what this program does, however being a DOS program isn

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

sample attached along... Regards r 2010/6/30 lucky singh > > 4 variours formulas reuired... > > sample attached along... > > Regards, > Jay S > > > > On Wed, Jun 30, 2010 at 3:21 AM, r wrote: > >> >> >> On 29 Giu, 12:05, lucky singh wrote: >> > Hi All, >> > >> > 1. I want to extract all the nu

Re: $$Excel-Macros$$ Need help with a lookup

We will have to add one more column in Extracted data sheet to concatenate Area & ID. If it is fine then it is easy. Otherwise I do not have solution. Regards, Mathan On Wed, Jun 30, 2010 at 6:09 AM, Nadine S wrote: > The attached file is a sample of my data. I need to write a formula in

$$Excel-Macros$$ Re: Macro to shade every other row

> > 1. The comment in this code has as an example, "ShadeAlternateRows > > Range("A1:D50"), 27, 2", but where in the actual code do you put this > > information? > > That depends on when the highlighting should happen. I'm most interested in learning how to do it manually (e.g., after manually sel

$$Excel-Macros$$ a macro for search option from one excel file to another excel file

Dear friends, my problem is that, i want to search a name present in a particular excel file, into another excel file. suppose mango is [resent in one excel file, then i want that if i click on this particular name , it automatically reflect into another excel file plz help -- --

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi all once again Thanks for all the responses but the solution is not as simple as it seems i suppose While making 2 summaries, one with sumif and the other with a lookup fulfills the required criteria to some extent, its not the solution being looked for ( Because data is updated at different i

Re: $$Excel-Macros$$ Re: Required Formula

I agree with you Dave that last column of sumproduct formula is having issue because of text, and this is why i have revised my solution in my second attempt and used vlookup with array functionality. Anyways thanks for your consideration. Thanks, Dilipandey On 6/30/10, Dave Bonallack wrote: > >

RE: $$Excel-Macros$$ Re: Required Formula

Hi Dilip, Sorry, didn't see your latest solution. Excellent! Regards - Dave Date: Tue, 29 Jun 2010 15:21:56 +0530 Subject: $$Excel-Macros$$ Re: Required Formula From: dilipan...@gmail.com To: ahmedhon...@gmail.com CC: excel-macros@googlegroups.com Hi Ahmed, As promised, please find attac

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Chitra, I'm from Pune and looking, for a good Job in Pune only. Where is Pushpa Vihar located? If You recruit for Pune I will forward you my updated resume. Regards, Anand.

Re: $$Excel-Macros$$ Re: Required Formula

No problem Dave. . !! :) Thx for your kind evaluation. warmest regards, Dilipandey On 7/1/10, Dave Bonallack wrote: > > Hi Dilip, > > Sorry, didn't see your latest solution. Excellent! > > Regards - Dave > > > > Date: Tue, 29 Jun 2010 15:21:56 +0530 > Subject: $$Excel-Macros$$ Re: Required For

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi! Parag, What Exactly output u want its not clear"I want that I can count the no.of dispathces I done in 3july for old date.". Saggi realsa...@gmail.com On Jun 30, 4:27 pm, parag dafal wrote: > Dear Sir, >             Please help me in the formula for countif & other. i want to > count the n

$$Excel-Macros$$ Re: Pls send examples of complex scenarios using sumproduct formula

Seach over Google.U will lots examples On Jun 29, 9:31 pm, Satti Charvak wrote: > Hi All, > >  Can anybody please send me some examples of complex scenarios where the > "sumproduct" formula has been used... > > Kind Regards, > Satti Charvak -- ---

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

Thank you... Thanx a lot dude... Regards, Jay S On Wed, Jun 30, 2010 at 5:06 PM, devi prasadc wrote: > Hi Jay, > > I could get solutions for couple of things only. > > Regards > DeviPrasad > > On Wed, Jun 30, 2010 at 4:03 PM, lucky singh wrote: > > > > 4 variours formulas reuired... > > sampl