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
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
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
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
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
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
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
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
> >
> >
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
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
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
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
> > 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
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
--
--
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
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:
>
>
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
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.
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
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
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
--
---
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
22 matches
Mail list logo