$$Excel-Macros$$ Required formula as per the attachment in sheet 2

2018-10-06 Thread rajeyssh
Dear Sir I need formula as mentioned in the excel sheet "2". Thanks in advance for your help. Regards Rajesh Kumar Agarwal -- 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/

Re: $$Excel-Macros$$ Re: top 3 & bottom 3 value

2016-04-19 Thread rajeyssh
result required for large 20,17 and 16 which is not done through this formula. On Tuesday, April 19, 2016 at 3:51:31 PM UTC+5:30, amar takale wrote: > > Array formula press (Ctrl+Shift+enter) > > ={LARGE($A$2:$A$21,{1;2;3;4;5})} > > On Tue, Apr 19, 2016 at 3:50 PM, amar takale > wrote: > >> use

Re: $$Excel-Macros$$ Formula required

2016-06-22 Thread rajeyssh
formula required as mentioned in column D19. On Friday, June 17, 2016 at 6:28:10 PM UTC+5:30, Vikas Verma wrote: > > plz provide more clearity?? about your query > > Thanks & regards, > > www.MrExcel4U.com > > On Fri, Jun 17, 2016 at 5:26 AM, Rajesh Agarwal >

Re: $$Excel-Macros$$ Formula required

2016-06-23 Thread rajeyssh
e use ctrl+shift+enter > > Regards, > A Gowrisankar > > > On Wed, Jun 22, 2016 at 5:28 PM, rajeyssh > > wrote: > >> formula required as mentioned in column D19. >> >> On Friday, June 17, 2016 at 6:28:10 PM UTC+5:30, Vikas Verma wrote: >>> >>>

$$Excel-Macros$$ Required formula

2020-02-01 Thread rajeyssh
Dear Sir Thanks in advance for your help. Formula required in column D as mentioned in sheet. Thanks & Regards Rajesh Agarwal -- 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

Re: $$Excel-Macros$$ vlookup query

2013-12-17 Thread rajeyssh
I want to put vlookup in 7th to 9th row in column A to J from sheet 1. On Tuesday, December 17, 2013 5:42:18 PM UTC+5:30, ravinder negi wrote: > > What is the lookup value > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Rajesh Agarwal > *Sent:*

$$Excel-Macros$$ Formula required

2021-06-10 Thread rajeyssh
Hello Group Members Will you help me to put formula in column E & F in the attached file as mentioned in column H. I will be very thankful to you for the same. -- 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

$$Excel-Macros$$ Spread sheet for NSE, BSE, MCX or all Indian exchange data.

2012-03-11 Thread rajeyssh
will you help me by telling me how can i make spreadsheet for the data. i am attaching the link of bhav copy and want to save day by day data in the spreadsheet. If any body in this group already have it and want to share it, welcome. http://www.mcxindia.com/SitePages/BhavCopy.aspx -- FORUM RULES

Re: $$Excel-Macros$$ vlookup with more than one value

2012-03-30 Thread rajeyssh
sir, Here i attach an excel sheet and if i want to put vlookup for gold(column b+column c). let me know the solution. thanks On Wednesday, March 28, 2012 11:34:21 AM UTC+5:30, lakshm...@yahoo.com wrote: > > ok thanks > > *From:* NOORAIN ANSARI > *To:* excel-macros@googlegroups.com > *Sent:*

Re: $$Excel-Macros$$ vlookup with more than one value

2012-04-02 Thread rajeyssh
UTC+5:30, Don Guillett wrote: > > Show AFTER examples and why > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* rajeyssh > *Sent:* Friday, March 30, 2012 6:45 AM > *To:* excel-macros@googlegroups.com > *Cc

$$Excel-Macros$$ need formula

2012-09-25 Thread rajeyssh
Hello everyone I need simple average and minimum formula in the column but excluding the value if 0. thanks -- 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. Poo

$$Excel-Macros$$ conditional formating

2012-09-25 Thread rajeyssh
Hello Sir Required correction in conditional formatting. Pl. check the attachment and do the needful. Thanks -- 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. Po

Re: $$Excel-Macros$$ Solve the problem

2012-10-20 Thread rajeyssh
Thanks Sir and If I want to calculate on 6days week format how Can I do it. rajesh On Wednesday, October 17, 2012 4:55:33 PM UTC+5:30, Aamir Shahzad wrote: > > PFA > > Aamir Shahzad > On Wed, Oct 17, 2012 at 3:16 PM, Rajesh Agarwal > > > wrote: > >> Dear Sir >> I want to put formula on column B

Re: $$Excel-Macros$$ Solve the problem

2012-10-20 Thread rajeyssh
Thanks Sir and If I want to calculate on 6days week format how Can I do it. rajesh On Wednesday, October 17, 2012 6:51:47 PM UTC+5:30, Rajan_Verma wrote: > > *Is it you are looking for?* > > * * > > *=NETWORKDAYS(A2,A2+25,$E$2:$E$17)* > > * * > > * * > > * * > > *Regards* > > *Rajan verma* > > *+9

Re: $$Excel-Macros$$ need solutions

2012-11-01 Thread rajeyssh
Hello Satendra Thanks for the help. One more thing I want to know If I want to do this from other file and process how can I put this formula in the sheet. Once again thanks On Wednesday, October 31, 2012 1:29:03 PM UTC+5:30, Satendra kumar wrote: > > Hi, > > Find Another solution i think this is

Re: $$Excel-Macros$$ formula without macro

2012-12-13 Thread rajeyssh
Hello Swapnil Thanks for your Help. Rgds Rajesh On Thursday, December 13, 2012 4:04:34 PM UTC+5:30, Swapnil Palande wrote: > > Hi Rajesh, > > You can use "Indirect" function > > =VLOOKUP(A2,INDIRECT("'[bcm.xls]" & L2 & "'!$A:$B"),2,0) > > Pls find attach solution. > > Regards, > > Swapni

Re: $$Excel-Macros$$ formula without macro

2012-12-14 Thread rajeyssh
change sheet name in L Column from datafile sheet > (51212 change to 61212) then data is not change.Pls see datafile Sheet > which I work & formula correction. > > Regards > Amar > > On Fri, Dec 14, 2012 at 12:33 PM, rajeyssh > > wrote: > >> Hello Swapnil &g

$$Excel-Macros$$ Spread sheet for NSE, BSE, MCX or all Indian exchange data.

2012-02-20 Thread rajeyssh
Is there any body in the group using spread sheet for NSE, BSE, MCX or all exchange data. If yes and if you want to share it with the group, please send it to me. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

$$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet

2012-02-10 Thread rajeyssh aggarwaal
Hello Sir, Is it possible while we entering the date in the sheet system alert us that the name or number or text already in the sheet but not limit the entry of the data, if yes let me know how can we do it and is it possible to imply the rule in few rows not in all the rows. thanks & regards raje