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 Diffe
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 of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poo
jaykumar
>
>
> On Tue, Jul 16, 2013 at 4:40 PM, Muralidhar E wrote:
>
>> Thank u
>>
>>
>>
>> On 16 July 2013 16:34, NOORAIN ANSARI wrote:
>>
>>> Dear Muralidhar.
>>>
>>> it's the largest number that Excel can store.
Dear Vijay Kumar.
Thank u
On 16 July 2013 16:40, Muralidhar E wrote:
> Thank u
>
>
>
> On 16 July 2013 16:34, NOORAIN ANSARI wrote:
>
>> Dear Muralidhar.
>>
>> it's the largest number that Excel can store. This "Big number" is used
>&g
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI 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 wrote:
>
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 wrote:
> Hi,
>
> ThanksVijay. can u p
e by VLookup.
>
> Regards,
> VijayKumar
>
>
> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Murlidhar,
>>
>> Please visit here..
>>
>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>>
>>
>>
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,*
**
*Murali
nt 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 wrote:
> Hi,
> Dear friends,
>
> Thank u
>
> With the same i want to know using column & columns
>
> *2.This is using columns or column function*
>
sult 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 wrote:
>
> Dear Murli,
>
> Find the same
>
> Regards,
> Prafull Jadhav.
>
>
> On Wed, Jul 10, 2013 at 3:59
vlookup function?
*Note:* It is more helpful with sharing date by examples.
Thanks in advance.
-- Forwarded message --
From: Muralidhar E
Date: 10 July 2013 15:30
Subject: $$Excel-Macros$$ Vlookup function using with match & columns
To: excel-macros@googlegroups.com
Dear fri
:* 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 of
hi,
Expecting examples excel file, reg. Array formula functions.
On Thu, Aug 30, 2012 at 5:58 PM, NOORAIN ANSARI wrote:
> Sure Murlidhar,
>
> i will provide you shortly.
>
>
> On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E wrote:
>
>> Hi,
>> Thanks alot. If
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-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
>
> **
:02 PM, dguillett1 wrote:
> Provide a file and a complete explanation and examples.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Muralidhar E
> *Sent:* Monday, September 03, 2012 3:33 AM
> *To:* excel-macro
")
>
> Ctrl + Shift + Enter
>
> Regards,
> Kuldeep Singh
>
>
> On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E wrote:
>
>> Hi,
>>
>> thanks, But the result is coming wrong, for blank "p o" vendor name is
>> taking in calculation.
&g
0"))
>
> Regards,
> Kuldeep Singh
>
>
> On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E wrote:
>
>>
>> Dear all,
>>
>> Good morning to every body
>>
>> Iam using Office 2010, I need in result column(F) how many times the
>> vendor
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 th
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 wrote:
> Dear Murlidhar,
>
> Some best sites for Array Function
>
> http://www.cpe
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.fac
gt;
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@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
>
&g
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 wrote:
>
> Hi,
>
> Rajan,
>
> thanks alot.
> Warm Ragards,
>
> Muralidhar E
> On Sat, Jun 30,
Hi,
Rajan,
thanks alot.
Warm Ragards,
Muralidhar E
On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma wrote:
> HI
>
> ** **
>
> HTH
>
> ** **
>
> Sub DisableCtrlD()
>
>
>
> Dim blnflag As Boolean
>
> Dim str
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 wrote:
> Hi group,
>
> Because of CTRl+D just fill down the data iam facing this problem, when i
> want to use Ctrl+F u
ill 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:* ex
erformed 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 wrote:
>
>>
>> Dear all,
>>
>> Iam using Office 2007, when iam need to use Crl+F acciden
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 wrote:
> Th
cel As Boolean)*
> *Application.OnKey "^d"*
> *End Sub*
>
> You can copy-paste both these 02 codes in code area for "ThisWorkbook"
> object.
>
> HTH
>
> Abhishek
>
> On Sat, Mar 31, 2012 at 12:03 PM, muralidhar e wrote:
>
>>
>> hi dear group
Hello friend,
Thank you but i need without macros is it possible to do this it is more
helpful to me.
Regards,
Muralidhar E.
-- Forwarded message --
From: Daniel
Date: Sun, Jul 31, 2011 at 8:44 PM
Subject: RE: $$Excel-Macros$$ Entered data should be locked
To: excel-macros
the help is without macro is better to me.
--
*Thanks & Regards,*
**
*Muralidhar E.*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldail
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
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
Dear all,
This is urgent to me, plz suggest solution as early as possible.
Warm Regards,
Muralidhar E.
-- Forwarded message --
From: muralidhar e
Date: Thu, Nov 11, 2010 at 11:02 AM
Subject: $$Excel-Macros$$ Vlookup
To: excel-macros@googlegroups.com
Dear all group members
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
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.
--
--
36 matches
Mail list logo