$$Excel-Macros$$ Power BI

2017-11-28 Thread Muralidhar E
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

$$Excel-Macros$$ Matching values

2013-09-20 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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.

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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: >

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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 >> >> >>

$$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
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

Fwd: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-11 Thread Muralidhar E
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* >

Re: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Muralidhar E
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

Fwd: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Muralidhar E
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

$$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Muralidhar E
:* 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

Re: $$Excel-Macros$$ Learn Array formula's

2012-09-05 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-05 Thread Muralidhar E
> * * > > *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 > > **

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Muralidhar E
: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

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Muralidhar E
") > > 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

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Muralidhar E
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

$$Excel-Macros$$ Count when po is greater than zero

2012-09-02 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Learn Array formula's

2012-08-30 Thread Muralidhar E
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

$$Excel-Macros$$ Learn Array formula's

2012-08-29 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

2012-06-29 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

2012-06-29 Thread Muralidhar E
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,

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

2012-06-29 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

2012-06-28 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

2012-06-28 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

2012-06-27 Thread Muralidhar E
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

Re: $$Excel-Macros$$ Disable Ctrl+D

2012-04-17 Thread muralidhar e
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

Re: $$Excel-Macros$$ Disable Ctrl+D option in excel

2012-03-31 Thread muralidhar e
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

Re: $$Excel-Macros$$ Disable Ctrl+D option in excel

2012-03-31 Thread muralidhar e
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

Fwd: $$Excel-Macros$$ Entered data should be locked

2011-08-01 Thread muralidhar e
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

$$Excel-Macros$$ Entered data should be locked

2011-07-31 Thread muralidhar e
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

$$Excel-Macros$$ LOOK

2010-11-11 Thread 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

Re: $$Excel-Macros$$ Vlookup

2010-11-11 Thread 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

Fwd: $$Excel-Macros$$ Vlookup

2010-11-10 Thread 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 Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members

$$Excel-Macros$$ Vlookup

2010-11-10 Thread 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

$$Excel-Macros$$ total for unique values

2010-05-21 Thread 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. -- --