Hi friends,
I want to learn Power BI(Power Pivots, Power query and power maps) in
briefly with examples, and training material also, with tips and tricks.
Any useful links, PPT's and PDF etc
Thanks in advance
--
*Thanks & Regards,*
*Muralidhar E.*
Think different
Do Different
Dear Friends experts,
Good morning
If any one can helped can be appreciated,iam using excel-2010, my problem
is i want to get the result for third match(occurence) value, but
iam failed to do so.Information reg. data is explained the file.
Thanks in advance.
*Thanks Regards,*
**
*Muralidhar
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the left side
2.Vlookup for the second value(occurence), third value
Is their any other ways or functions to get the results.?
Thanks in advance.
--
*Thanks Regards,*
**
*Muralidhar E
by VLookup.
Regards,
VijayKumar
On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Murlidhar,
Please visit here..
http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E
emuralidha
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
=LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)
plz, help me on this with an example,it is help me more.
Thanks in advance
Warm Regards,
Muralidhar
On 16 July 2013 15:37, Muralidhar E emuralidha...@gmail.com wrote:
Hi
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used to
look up the last number in a range.
On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E emuralidha...@gmail.comwrote
Dear Vijay Kumar.
Thank u
On 16 July 2013 16:40, Muralidhar E emuralidha...@gmail.com wrote:
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used
to look up the last
On Tue, Jul 16, 2013 at 4:40 PM, Muralidhar E emuralidha...@gmail.comwrote:
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used
to look up the last number in a range
,,, for example if you want B column then
put (B:B).
=VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0)
On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E emuralidha...@gmail.comwrote:
Hi,
Dear friends,
Thank u
With the same i want to know using column columns
*2.This is using columns or column function
:* It is more helpful with sharing date by examples.
Thanks in advance.
--
*Thanks Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
vlookup function?
*Note:* It is more helpful with sharing date by examples.
Thanks in advance.
-- Forwarded message --
From: Muralidhar E emuralidha...@gmail.com
Date: 10 July 2013 15:30
Subject: $$Excel-Macros$$ Vlookup function using with match columns
To: excel-macros
by using vlookup function?
2. Shall we can get the second value result by using vlookup function?
Thanks in advance.
On 10 July 2013 16:34, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear Murli,
Find the same
Regards,
Prafull Jadhav.
On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E
-macros@googlegroups.com] *On Behalf Of *Muralidhar E
*Sent:* 04 September 2012 11:28
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Count when po is greater than zero
** **
Dear all,
Find the attached file, I want i column E if column D is more than zero
hi,
Expecting examples excel file, reg. Array formula functions.
On Thu, Aug 30, 2012 at 5:58 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Sure Murlidhar,
i will provide you shortly.
On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E emuralidha...@gmail.comwrote:
Hi,
Thanks alot
On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E emuralidha...@gmail.comwrote:
Dear all,
Good morning to every body
Iam using Office 2010, I need in result column(F) how many times the
vendor name(column B) is repeat, it is countable when the po(column D) is
greater than zero, if po is blank
,
Kuldeep Singh
On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E emuralidha...@gmail.comwrote:
Hi,
thanks, But the result is coming wrong, for blank p o vendor name is
taking in calculation.
On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh
naukrikuld...@gmail.comwrote:
Hi Muralidhar
:02 PM, dguillett1 dguille...@gmail.com wrote:
Provide a file and a complete explanation and examples.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* Muralidhar E emuralidha...@gmail.com
*Sent:* Monday, September 03, 2012 3:33 AM
*To:* excel-macros
in advance.
--
*Thanks Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different
--
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 thread
Hi,
Thanks alot. If u give any files with examples in excel or in ppt. it will
help me to learn very easily.
Thanks in advance.
Thanks
Muralidhar E
On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Murlidhar,
Some best sites for Array Function
http
hi to all group members,
I want to learn can anyone send me the array formula's guide for beginners
with examples.
Thanks in advance.
--
*Thanks Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different
--
Join official facebook page of this forum @
https://www.facebook.com
Hi,
Rajan,
thanks alot.
Warm Ragards,
Muralidhar E
On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
HI
** **
HTH
** **
Sub DisableCtrlD()
Dim blnflag As Boolean
Dim strPwd As String
strPwd
Hi,
Can u guide the procedure how to run this code in my file.
I am fail to run the code.
Warm Regards,
Muralidhar E.
On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E emuralidha...@gmail.comwrote:
Hi,
Rajan,
thanks alot.
Warm Ragards,
Muralidhar E
On Sat, Jun 30, 2012 at 10:09 AM
@googlegroups.com] *On Behalf Of *Muralidhar E
*Sent:* 30 June 2012 10:48
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Enable Disable Ctrl+D with passward
** **
Hi,
Can u guide the procedure how to run this code in my file.
I am fail to run
just fill down the data.
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
*Sent:* 27 June 2012 3:18
*To:* excel-macros@googlegroups.com
*Cc:* ahmedhon
Hi gm experts,
is anybody solve my problem reg. disable ctrl+d option.
Iam waiting for solution for the problem.
On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E emuralidha...@gmail.comwrote:
Hi group,
Because of CTRl+D just fill down the data iam facing this problem, when i
want to use
performed i.e Undo the last action ;-). This should help. If not, check
other experts advice.
Thanks,
On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear all,
Iam using Office 2007, when iam need to use Crl+F accidently iam hitting
Ctrl+D, iam loosing some
hi, anil
Iam not understand, if u not feel can u explain it.
*Iam what i need is simply is.*
iam need not want Ctrl+D option and it disable in my worksheet. if i
suppose to use the Ctrl+D option i need a passward when i am using the
Ctrl+D.
Thanks
Muralidhar E
On Tue, Apr 17, 2012 at 3:11
Hi,
Very sorry repeating the mail, iam unable to find the code to copy at my
original file.
Message run-time error 1004
Method onkey of object_application failed.
Thanks in advance
--
*Thanks Regards,*
**
*Muralidhar E.*
On Sat, Mar 31, 2012 at 3:20 PM, Abhishek Jain abhishek
like
this also.
Plz give the solution what i have asked format. it will usefull me.
Thanks and Regards,
Muralidhar E.
On Thu, Nov 11, 2010 at 12:47 PM, Rajasekhar Praharaju
rajasekhar.prahar...@gmail.com wrote:
Hello Muralidhar,
Instead of Vlookup you can use Pivot table it depicts good
Dear all group members,
I want to get the L T no, by using vlookup formula, by repeated batches.
file was attached plz suggest me how to do this by using lookup formula for
repeated.Iam using MS-Office 2007.
Warm Regards,
Muralidhar E
Dear all group members,
I want to get the L T no, by using vlookup formula, by repeated batches.
file was attached plz suggest me how to do this by using lookup formula for
repeated.Iam using MS-Office 2007.
Warm Regards,
Muralidhar E
Dear all,
This is urgent to me, plz suggest solution as early as possible.
Warm Regards,
Muralidhar E.
-- Forwarded message --
From: muralidhar e emuralidha...@gmail.com
Date: Thu, Nov 11, 2010 at 11:02 AM
Subject: $$Excel-Macros$$ Vlookup
To: excel-macros@googlegroups.com
hai friends,
This is murali when iam entering the Batches or numbers(values) in a column
it should be repeat more than one time, i want the sum for entering the
values. plz help and give a solution for me. iam using office 2007.iam also
attaching a file for easy understand.
--
33 matches
Mail list logo
