Dear All,
I have a salary sheets where there are three column i.e. Name, Department
and salary. I need department wise salary sheet but there is one
issue.there are lots of employees whose salary is going in more then 1
department so I am confused how I bind up my salary. I mentioned my method
in
Hi,
This is manoj kumar from new delhi..
I am add my new id on this group..
Regard
Manoj
On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>
> Welcome to excel group,one of the largest online community of excel Fans!
>
> I hope you enjoy
Hi
Can you please share sheet with results required by you.
Prima facie you are getting array because you are comparing range of not
same size.
Rgds//Vabs
On Monday, October 15, 2012 10:51:12 AM UTC+5:30, Chandru wrote:
> hi Group Member
>
> i have small doubt how to use Sumproduct
Thanks
On Sun, Oct 14, 2012 at 7:19 PM, SUDHIR VERMA wrote:
> thankx for sharing
>
>
>
> On 14 October 2012 10:23, Nikhil Shah wrote:
>
>> Hi
>>
>> Thanks for sending excellent file,
>>
>> (1). Prince Formula Bible (Updated Version)
>> (2). Updated Lets Learn Together ( Macro Bible )
>> Can you
hi Group Member
i have small doubt how to use Sumproduct Not Equal Rangelike
A B
110100
2 20 200
330 300
440 400
5 50 500
Not in range like
8 20
9 30
i used like this
=sumproduct((a1:a5>=1)*(a1:a5<=4)*(a1:a5<>a8:a9)*(B1:B5))
i got error
Hi Sudhir,
Most welcome in Excel-Macro Group.
Keep posting.
Regards,
Kuldeep Singh
On Sun, Oct 14, 2012 at 7:57 PM, SUDHIR VERMA wrote:
> Hi,
>
> I am sudhir, age 28, working in Vardhman Group, Delhi
>
> thanking u
>
>
> On 13 October 2012 18:26, wrote:
>
>> **
>> Hi,
>>
>> Welcome Abhishek.
Hi,
I am sudhir, age 28, working in Vardhman Group, Delhi
thanking u
On 13 October 2012 18:26, wrote:
> **
> Hi,
>
> Welcome Abhishek..
>
> Cheerz...
>
> Sent on my BlackBerry® from Vodafone
> --
> *From: * CA Abhishek Agarwal
> *Sender: * excel-macros@googlegroups
thankx for sharing
On 14 October 2012 10:23, Nikhil Shah wrote:
> Hi
>
> Thanks for sending excellent file,
>
> (1). Prince Formula Bible (Updated Version)
> (2). Updated Lets Learn Together ( Macro Bible )
> Can you send all files in excel 2003..
>
> Nikhil
>
>
>
> On Sat, Oct 13, 2012 at 10:
Hi
Its working fine on my desktop. Can you send the file
Also specify which version of office u r using
Sent on my BlackBerry® from Vodafone
-Original Message-
From: prkhan56
Sender: excel-macros@googlegroups.com
Date: Sat, 13 Oct 2012 12:01:09
To:
Reply-To: excel-macros@googlegroup
