Congratulations!!!
-Kiran
-- Forwarded message --
From: amar takale
Date: Wed, Oct 3, 2012 at 12:21 PM
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September
2012
To: excel-macros@googlegroups.com
Congratulations Rajan
Regards,
Amar
On Wed, Oct 3, 2012 at
*Hello Prince*
*
*
*This is also working fine with a small changes in the cell's address as
follows :-*
*
*
in Column C
=A2&B2drag it up to* C11*
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to *D11*
Now in Cell *B12* I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
*
*
*Thank you.*
*
Congratulations Rajan
Regards,
Amar
On Wed, Oct 3, 2012 at 12:17 PM, Indrajit $nai wrote:
> *Congrats bro. :)*
> *
>
> *
> On Wed, Oct 3, 2012 at 11:35 AM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Congrats Rajan
>>
>>
>> On Wed, Oct 3, 2012 at 10:36 AM, Karan Sin
*Congrats bro. :)*
*
*
On Wed, Oct 3, 2012 at 11:35 AM, SAGAR KASANGOTTUWAR <
sagarkasangottu...@gmail.com> wrote:
> Congrats Rajan
>
>
> On Wed, Oct 3, 2012 at 10:36 AM, Karan Singh wrote:
>
>> Congrats dude!
>>
>>
>> Karan Singh
>>
>>
>>
>>
>> On Wed, Oct 3, 2012 at 10:24 AM, Aamir Sha
Nice solution...
Regards
Prince
On Wednesday, October 3, 2012 11:46:01 AM UTC+5:30, §»VIPER«§ wrote:
>
> try the below formula with cse
>
> =SUM((1/COUNTIFS(A2:A11,A2:A11,B2:B11,B2:B11))*(B2:B11))
>
> On Wed, Oct 3, 2012 at 10:57 AM, Pravin Gunjal
> > wrote:
>
>> *Kuldeep, This is not working...*
Hi Pravin,
Pls Note below steps what I did.
in Column C
=A2&B2drag it up to C10
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to D10
Now in Cell B11 I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
Regards
Prince
On Wednesday, October 3, 2012 10:38:03 AM UTC+5:30, Pravin Gunjal w
Congrats Rajan
On Wed, Oct 3, 2012 at 10:36 AM, Karan Singh wrote:
> Congrats dude!
>
>
> Karan Singh
>
>
>
>
> On Wed, Oct 3, 2012 at 10:24 AM, Aamir Shahzad
> wrote:
>
>> Congrates Rajan
>>
>> Aamir Shahzad
>> On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh wrote:
>>
>>>
>>> Congratulations
Congrats dude!
Karan Singh
On Wed, Oct 3, 2012 at 10:24 AM, Aamir Shahzad wrote:
> Congrates Rajan
>
> Aamir Shahzad
> On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh wrote:
>
>>
>> Congratulations Rajan Sir.
>>
>> Regards,
>> Kuldeep Singh
>> Back Office Executive (MIS)
>> Info Edge India Lim
Congrates Rajan
Aamir Shahzad
On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh wrote:
>
> Congratulations Rajan Sir.
>
> Regards,
> Kuldeep Singh
> Back Office Executive (MIS)
> Info Edge India Limited (naukri.com)
> Phone.: +91-120-4763789, Extn.: 789, 971615535
> naukrikuld...@gmail.com || www.nau
Congratulations Rajan Sir.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789, 971615535
naukrikuld...@gmail.com || www.naukri.com || www.naukrigulf.com
*Please* *Consider the environment. Please don't print this e-mail unles
Hi Ankur,
Please Paste this formula in G1 and modify it as per your requirment.
IF(AND(PRODUCT((B1:B4=B1)*1),(SUM(F2:F4)=F1),(OR(C2:C4={"E","F","A"}))),"Yes","No")
with Ctrl+Shift+Enter
Regards
Prince
On Tuesday, October 2, 2012 12:19:37 AM UTC+5:30, ankur wrote:
>
> Hi All,
>
> I seek some
Congrats Rajan.Keep it Up
On Tuesday, October 2, 2012 9:04:33 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> Sep'12. He has posted 137 posts in last month and helped forum members
> through his excel expertise.
> I
Methinks you are making this much more difficult than necessary.
Either fully explain what you want with before/after example
If all else fails, send file to dguillett1 @gmail.com
On Tuesday, October 2, 2012 4:33:57 PM UTC-5, Diamond Dave wrote:
>
> Attached is a file which contains a Macro (S
Thanks a lot Rajan and Ashish I really appreciate your knowledge
and great help
On 10/2/12, ashish koul wrote:
> try the attachment change c38 as per ur last row
>
>
>
> On Tue, Oct 2, 2012 at 10:56 AM, Rajan_Verma
> wrote:
>
>>
>> Try this
>>
>> =IF(C1="",IF(SUMPRODUCT(N($B$1:$B$16=B1)*N
Congrats Rajan,
Worthy winner!
CVJ
On Tue, Oct 2, 2012 at 9:40 PM, wrote:
> Congrats... Rajan..
>
> Keep it up buddy by sharing your exceptional knowledge..
>
> Rgds//Vabs
> Sent on my BlackBerry® from Vodafone
> --
> *From: *"Rajan_Verma"
> *Sender: *excel-macros@g
Congrats... Rajan..
Keep it up buddy by sharing your exceptional knowledge..
Rgds//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Tue, 2 Oct 2012 21:38:08
To:
Reply-To: excel-macros@googlegroups.com
Subject
Thank you sam.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: 02 October 2012 9:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most Helpful M
Congratulations Rajan
Regards,
Sam
On Tue, Oct 2, 2012 at 9:03 PM, Ayush Jain wrote:
> Dear members,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> Sep'12. He has posted 137 posts in last month and helped forum members
> through his excel expertise.
> I truly appr
.Range("b" & LastRow).Resize(, 4) = Split(Me.TextBox2.Value & "|" &
Me.TextBox1.Value & "|" & Me.TextBox3.Value & "|" & Me.TextBox4.Value,
"|")
Kris
ExcelFox
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for viola
My self Sandeep Chhajer from Mumbai. I am a Chartered Accountant by profession.
This group has changed my perception of workingwith excel.
I am really thankful to this group and its wonderful members.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From:
Dear Don,
I am also cannot see the link...
Whenever I click it will go to GOOGLE
Kindly give the solution ...
Thanks ...
Sagar
On Mon, Sep 24, 2012 at 12:43 PM, Paul wrote:
> Hi Don,
>
> Is there an address that contains your solution as it does not display in
> either of the below URLs
Aamir, Amol, Johnson & Vabs.
Welcome to this group, I wish you great journey and lots of learning in
this group.
Keep posting !
Thanks.
On Tuesday, 2 October 2012 10:17:17 UTC+5:30, Vabz wrote:
>
> Hey hii..
>
> My self Vaibhav Joshi and online people call me vabz/vabs..
>
> I am extremely love
*@ Krishna, but Sir, still it's showing the same error!!!*
On Tue, Oct 2, 2012 at 4:10 PM, Krishna Kumar wrote:
> in this line it should be 3
>
> .Range("b" & LastRow).Resize(, 3)
>
> in your code it's 4
>
> Kris
>
> Kris
> ExcelFox
>
> --
> Join official facebook page of this forum @
> https
in this line it should be 3
.Range("b" & LastRow).Resize(, 3)
in your code it's 4
Kris
Kris
ExcelFox
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor t
Replace
Split(Me.TextBox2.Value & "," & Me.TextBox1.Value & "," &
Me.TextBox3.Value, ",")
with
Split(Me.TextBox2.Value & "|" & Me.TextBox1.Value & "|" &
Me.TextBox3.Value, "|")
Kris
On Tue, Oct 2, 2012 at 2:47 PM, Indrajit $nai wrote:
> @ Krishna, thanks a lot Sir, it's working fine.but
Rajan & Ashish..
Its really good formula..
Thanks ..
Rgds//Vabs
On Tuesday, October 2, 2012 12:19:37 AM UTC+5:30, ankur wrote:
>
> Hi All,
>
> I seek some help in to get the desired result via formula.
>
> My requirement is - I need result in column G in the yellow
> highlighted cell as Yes
HI Vabs,
Can you please explain the usage of this excel macro.
how to use in fact
On Sun, Sep 30, 2012 at 7:38 PM, Vabz wrote:
> Hi
>
> Is this of any use?
>
> Rgds//Vabs
>
>
> On Friday, September 28, 2012 11:05:30 AM UTC+5:30, Vabz wrote:
>>
>> Hi Bhasker & Reshma
>>
>> PFA excel file wi
27 matches
Mail list logo