$$Excel-Macros$$ Name Range Change through VBA

ards, Prafull Jadhav 9920553518 -- 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. Poor thread titles, like Pl

$$Excel-Macros$$ Dynamic Range for Pivot

Dear All, Good Afternoon, I want a examples of Dynamic Range of Pivot. for example if i added new data in master file then new rows or data should be added in pivot or suppose i delete the data thane range should be adjust accordingly Thanks in Advance. Regards, Prafull Jadhav 9920553518

$$Excel-Macros$$ Re: [XL-VBA Clinic] Averege by Using by Sumproduct.

Dear All, Thanks for reply.. MY question is when I use the Dynamic Range then output of Avg Response time is coming but it is not applicable to Resolution. Why this happen ..? Please explain Regards, Prafull Jadhav 9920553518 On 12 March 2014 17:58, Arvind mishra wrote: > D

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] Averege by Using by Sumproduct.

Dear All, Waiting for the same. Dear All, Thanks for reply.. MY question is when I use the Dynamic Range then output of Avg Response time is coming but it is not applicable to Resolution. Why this happen ..? Please explain Regards, Prafull Jadhav 9920553518 On 12 March 2014 20:10

Re: FW: $$Excel-Macros$$ Conditional Formating

Dear Sir, It is not working.. Please let me know how I can select the all cell in sheet where cell format is "%" Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:12, Ravinder wrote: > Pfa. if not receive... > > > > *From:* excel-macros@googlegroups.co

Re: FW: $$Excel-Macros$$ Conditional Formating

Dear Sir, I want a VBA code ;which will select the all cell in sheet where cell format is "0.00%" Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:31, Ravinder wrote: > You just select the whole range of tables and put condition formatting as > already applied on $A$

Re: FW: $$Excel-Macros$$ Conditional Formating

mulas also there in sheet that's why I am not able to apply the condition formatting. Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:47, Ravinder wrote: > What you want to do with that selection.color them or else > > > > Below is code to color % format cell

$$Excel-Macros$$ Average Graph

stable average count. if i include the Highest numbers in series then Average suddenly goes up..and charts look like jumping at highest point. for avoid this ..which type of formula i have to apply here which show stable Average or Graphs. Regards, Prafull Jadhav 9920553518 -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Average Graph

gives wrong Nos to Management. Regards, Prafull Jadhav 9920553518 On 15 March 2014 20:44, ravinder negi wrote: > pls provide some example in excel with chart > > > On Saturday, March 15, 2014 8:12 AM, Abhishek Jain < > abhishek@gmail.com> wrote: > Does this

Re: $$Excel-Macros$$ Average Graph

Dear Abhishek Sir, Very good morning. If I now that ddaily frequency of cabs are between 50 to 80. Because of suddenly increased in cabs for few days this affects the overall average. I just want to show normal average.. Which excluding few days highest cabs. Regard, Prafull Jadhav. 9920553518

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Error status No Error ? C ? NC ? Error --How to find out Quality- how to find out Regards, Prafull Jadhav 9920553518 On 17 March 2014 16:58, Prabhu Pinky wrote: > can you workout and send me..i did tried.. but am not getting result. > > if you provide VBA code.. it would be

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Please check and ..let me know. Regards, Prafull Jadhav 9920553518 On 17 March 2014 21:12, Prafull Jadhav wrote: > Error status No Error ? C ? NC ? > > Error --How to find out Quality- how to find out > > Regards, > Prafull Jadhav > 9920553518 > > > On 17

$$Excel-Macros$$ VBA-For Next

Dear All, Good Afternoon! I have a big data which is horizontal .. I have to put it vertically. I am sending sample data ..Please help me for the same. . Regards, Prafull Jadhav 9920553518 -- 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) !

Re: $$Excel-Macros$$ RE: [XL-VBA Clinic] VBA-For Next

Dear Sir, perfect !... thanks a lot . Regards, Prafull Jadhav 9920553518 On 9 April 2014 16:11, Ravinder wrote: > PFA...first select range of heading as I have already selected in file. > > > > *From:* excelvbacli...@googlegroups.com [mailto: > excelvbacli...@goo

Re: $$Excel-Macros$$ Login & password in excel

Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain wrote: > Dear Amar, > > Please see the attached file. I hope this works for you. > > You may login by using any of the following credentials (both username and > passwo

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

Abhishek Sir, Again you proved that you are Master..! Regards, Prafull Jadhav 9920553518 On 27 May 2014 16:21, Abhishek Jain wrote: > Happy to help :) > > > On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal wrote: > >> Dear Abhishek Jee, >> >> It is

Re: $$Excel-Macros$$ Combining six IF formula into one formula

Dear Vaibhav Sir, Your formula is very good,Appreciate! Can we do the same for bucket by using same technique. for example 0-10,11-20,21-30 if cell is contain 7 then it should be come under 0-10 bucket if cell is contain 22 then it should be come under 21-30 bucket. Regards, Prafull Jadhav

Re: $$Excel-Macros$$ Combining six IF formula into one formula

Awesome!.Vaibhav Sir. Thanks a Lot! Regards, Prafull Jadhav 9920553518 On 28 July 2014 12:28, Vaibhav Joshi wrote: > hi > > you cont need such formula.. use this > formula =A1-MOD(A1,10)&"-"&A1-MOD(A1,10)+10 > > It is modeless whatever be the ra

$$Excel-Macros$$ Hyperlink

! Regards, Prafull Jadhav ​​ 9920553518 -- 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. Poor thread titles

Re: $$Excel-Macros$$ Hyperlink

Dear Ashish, Thanks for Reply! Actually I am not looking for the same. I want to hyper link with only with one sheet . Regards, Prafull Jadhav 9920553518 On 5 August 2014 14:40, Ashish Kumar wrote: > Hi Prafull, > > > PFA.!!! > > > Regards > Ashish > > >

Re: $$Excel-Macros$$ Hyperlink

ade it but it is not blinking. Please check my excel file. Regards, Prafull Jadhav 9920553518 On 5 August 2014 15:11, Ashish Kumar wrote: > Hi Prafull, > > PFA...!!! > > > Regards > Ashish > > On 5 August 2014 14:53, Prafull Jadhav wrote: > >> Dear Ashis

Re: $$Excel-Macros$$ Hyperlink

Dear Ashish, Only one changes , Blink on the ( in Details sheets)...which cell is selected or highlighted Not on the index sheet. for example : once i click on hyperlink cell(in index) then the cell should be blink of Details sheets which is selected. Regards, Prafull Jadhav 9920553518 On 5

Re: $$Excel-Macros$$ need help!!!

find the same Regards, Prafull Jadhav 9920553518 On 8 August 2014 16:19, Mihai Ghilea wrote: > Try this... > > > > Mihai Ghilea > > Network administrator > > [image: Sigla_METABRAS_STEEL_PEOPLEmica] > > ROMANIA > > SC METABRAS SRL Brasov > > St

Re: $$Excel-Macros$$ need help!!!

find the same... Regards, Prafull Jadhav 9920553518 On 8 August 2014 16:39, Prafull Jadhav wrote: > find the same > > Regards, > Prafull Jadhav > 9920553518 > > > On 8 August 2014 16:19, Mihai Ghilea wrote: > >> Try this... >> >> >> >&g

Re: $$Excel-Macros$$ Happy Independence Day!

Dear All, Wish you very very happy Independence day. Regards, Prafull Jadhav 9920553518 On 14 August 2014 13:24, Vaibhav Joshi wrote: > Happy Independence Day! > > -- > 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 of

Re: $$Excel-Macros$$ Macros get deleted

Dear Rupesh, Have u open it with Enable Macro? and also save it as it Macro Enable file... Regards, Prafull Jadhav 9920553518 On 8 September 2014 12:40, Rupesh Patil wrote: > > ​Hello Experts > I am using office 2013, when download any macro included workbook from > this gro

Re: $$Excel-Macros$$ Number to Text Indiann rupee format using formula no add ins & UDF

Dear Vaibhavji, Great! Regards, Prafull Jadhav 9920553518 On 8 September 2014 12:55, Vaibhav Joshi wrote: > FA, It works upto 99 crore, you can modify to extend further. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > O

Re: $$Excel-Macros$$ Amazing Excel formulas...

Dear Vaibhav Sir, Thanks for the shared us a very useful file. Regards, Prafull Jadhav 9920553518 On 18 September 2014 17:32, Ganesh N wrote: > Got it sir!! Thanks > > One more help sir. Like formulas do you have sample files for macros ? > just to learn. im a beginner to macro.

Re: $$Excel-Macros$$ Re: VBA

Dear Paul Sir, Can you please explain what is "Debug.Assert True" Regards, Prafull Jadhav 9920553518 On 22 November 2014 at 09:55, Mandeep Baluja wrote: > Hello Paul, > > First I would like to thank you from bottom of my *heart* for making such > an *efficient code

Re: $$Excel-Macros$$ Information

Dear Vaibhav Sir, You are really Great. You have solution for all queries. I am associate with this group since one year and learn lot of about VBA. Sir...if you are conducting VBA courses then please enrolled my name first. Keep it Sir. Thanks once again! Regards, Prafull Jadhav

Re: $$Excel-Macros$$ How to protect only few cells

Dear Ashish, Great! You have given explanation Step by Step. Regards, Prafull Jadhav 9920553518 On 5 December 2014 at 17:13, Ashish Kumar wrote: > Welcome Putta. > > -- > 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)

Re: $$Excel-Macros$$ need Excel formula

Great ... Abhishekji Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 15:51, Pankaj Sharma wrote: > Thank you Abhishek Jain > > On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain > wrote: > >> HTH >> >> On Thu, Aug 27, 2015 at 3:18 PM, Pankaj S

Re: $$Excel-Macros$$ need Excel formula

Dear Shrinivas, You will get this after selecting formula and Press F9 For example select 1/(A2:A18=F3) and then Press F9 Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 18:05, Pankaj Sharma wrote: > Hi Shrinivas, > > > "($A$2:$A$17=F2)" Here, A2:A17 array chec

Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

​select that column -Text to Column ( in Data Tab) -Click Finish ​ Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 18:49, SUDHIR VERMA wrote: > Dear Friends, > Please help me as per attached sheet. I have data of 25k row. there are > some code formatting as text. So you ar

Re: $$Excel-Macros$$ Count If Cell Contains

Great Abhishek!. Regards, Prafull Jadhav 9920553518 On 8 September 2015 at 11:51, 'David Lanne' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > Thank you very much > > > > On Tuesday, September 8, 2015 2:17 AM, Swapnil Palande < &g

Re: $$Excel-Macros$$ Financial year Graph

HI Find the same. On Wed, Mar 20, 2013 at 5:09 PM, Vinay Saraf wrote: > You should sort your data.. > > *From *Jan to Dec > *TO April to March* > > On Wed, Mar 20, 2013 at 4:59 PM, Chaya wrote: > >> Dear Experts, >> >> I want to plot a graph with the financial year >> start

Re: $$Excel-Macros$$ conditional formating to find amts to offset

HI , find the same if it is as per your requirement . Regards, prafull jadhav. On Sun, Mar 24, 2013 at 2:27 PM, David Grugeon wrote: > I want to know where we are going next with this. What happens if the > amounts are different? > > > On Sunday, 24 March 2013, santos

Re: $$Excel-Macros$$ conditional formating to find amts to offset

anks & Regards >> >> Santosh Kumar Subudhi >> >> santoshkumar.subu...@gmail.com >> >> -- >> Date: Mon, 25 Mar 2013 10:26:13 +0530 >> Subject: Re: $$Excel-Macros$$ conditional formating to find amts to offset >> From: p

$$Excel-Macros$$ Sumproduct Formula -Min-Function-Error

Regards, Prafull Jadhav. MIS-Executive. -- 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. Poor thread titles

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

Dear Prince, find the same. Regards, Prafull Jadhav. On Thu, Mar 28, 2013 at 9:19 AM, Prince wrote: > Share your workbook. > > Regards > Prince > > On Wednesday, March 27, 2013 6:05:37 PM UTC+5:30, prafull jadhav wrote: >> >> Dear All, >> >> Sumprodu

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

rds, > Gawli Anil > > On Thu, Mar 28, 2013 at 11:18 AM, prafull jadhav > wrote: > >> Dear Prince, >> >> find the same. >> >> Regards, >> Prafull Jadhav. >> >> >> On Thu, Mar 28, 2013 at 9:19 AM, Prince wrote: >> >>&

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

works ... > > > Warm Regards, > Gawli Anil > > > > > On Fri, Mar 29, 2013 at 10:38 AM, Prince wrote: > >> sry for mistake >> >> PFA. >> >> >> On Thursday, March 28, 2013 9:20:47 PM UTC+5:30, Prince wrote: >>> >>> PFA

$$Excel-Macros$$ Data req in attched sheet format.

Dear All, in attached sheet i have updated sample data . I am not getting the out put . Please help me in this reagard. I have mentioned what my requirement . Regards, Prafull Jadhav. -- 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

Re: $$Excel-Macros$$ Data req in attched sheet format.

Dear Ashish, Can we do it by using formula. Regards, prafull Jadhav; On Sat, Mar 30, 2013 at 1:00 PM, ashish koul wrote: > *Try this* > > *Sub sample()* > *Dim i As Long* > *With Sheets(1)* > *For i = 1 To .Range("a1").End(xlToRight).Column* >

Re: $$Excel-Macros$$ Average Price ( Financial Year End wise) Formula

ssible? > > Appreciate the help. > > Regards > Amar > > > > > > On Sat, Mar 30, 2013 at 2:20 PM, prafull jadhav > wrote: > >> >> Dear Amar, >> >> find the same with using sumproduct. >> >> Regard, >> Prafull Jadhav. >> &g

$$Excel-Macros$$ Macro-with example file

contain easy macros. Thanks in Advance . Regards, Prafull Jadhav. 9920553518 -- 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

Re: $$Excel-Macros$$ Need help on Graph

ed any type of macro here . the > dropdown box is taken from developer menu. > > Warm Regards, > Gawli Anil > > > On Wed, Apr 3, 2013 at 10:29 AM, prafull jadhav > wrote: > >> Dear Anil, >> >> I have created the same with help of validation and

$$Excel-Macros$$ Vertical Data Require

Dear All, I attached the sheet in which I require data vertically with company name. example data is attached . Regards, Prafull Jadhav. -- 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

Re: $$Excel-Macros$$ Vertical Data Require

there are 500 rows it takes 1 hour to do the same by transpose. On Wed, Apr 3, 2013 at 6:03 PM, Anil B wrote: > its simple dude paste as special and select transpose thats it. > > Thanks, > Anil > > > > > On Wed, Apr 3, 2013 at 5:52 PM, prafull jadhav > wrote: &

Re: $$Excel-Macros$$ Vertical Data Require

. Regards, Prafull Jadhav. On Wed, Apr 3, 2013 at 8:54 PM, ashish koul wrote: > try this > > Sub sample() > > Dim i As Long, j As Long, k As Long > > For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row > j = Sheets(2).Range("a65356").End

Re: $$Excel-Macros$$ Dynamic Charting

Dear Ashish Sir, Can you explain the below formula ..what is "Small" function work here. =IFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,""),ROW(A1)),"") Regards, Prafull Jadhav On Thu, Apr 4, 2013 at 10:40 PM, ashish koul wrote: > Try this one too without

Re: $$Excel-Macros$$ Dynamic Charting

Dear Ashish Sir, Thanks a lot . Regards, Prafull Jadhav. On Thu, Apr 4, 2013 at 11:00 PM, ashish koul wrote: > Its an array formula so u have to enter with CTRL+SHIFT+ ENTER > > iFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,""),ROW(A1)),"") > > Lets break th

Re: $$Excel-Macros$$ Please Answer the Question

'Management information System'. On Fri, Apr 5, 2013 at 2:14 PM, karthik N wrote: > Dear Team > > Please Answer the Question > > What is the MIS ?,Explain. > > Regards > karthik > > -- > 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 offici

Re: $$Excel-Macros$$ Countif Formula Logic

mentioned the examples . Regardas, Prafull Jadhav. MIS Executive. On Sat, Apr 6, 2013 at 1:53 PM, Priti_verma wrote: > Hi Amar , > > There is no difference between these formulas.if u have any doubt please > mention your query with example. > > Regards, > > Priti

Re: $$Excel-Macros$$

Please share a example file with criteria On Sat, Apr 6, 2013 at 3:45 PM, Shrinivas Shevde wrote: > > Dear All > Can Anyone answer this > > Regards > Shrinivas > > > On Mon, Apr 1, 2013 at 1:48 PM, Shrinivas Shevde > wrote: > >> Dear Rajan >> Thanks for reply >> >> Column E,F -: May be blank if

Re: $$Excel-Macros$$ Extracting word and numbers

Dear Anil, it is perfect and I appreciated. I am also learning Excel Macro but I am not able to understand from where I have to start . what is beginning point to understand .how to create short macro code in excel . Can you guide me for the same . Thanks in Advance . Regards, Prafull Jadhav

Re: $$Excel-Macros$$

Dear Shrinivas , Please find the attachments contain formula as per your requirement But this is not include below Criteria ("@" and "&" characters are not allowed in any of the Column) That you will get from Our experts .. I am not able to formulise the same. Regar

Re: $$Excel-Macros$$ Need help on Graph

nx!! to all of you >> >> it has solved my query completely. >> >> Regards, >> Deepak >> >> >> On Wed, Apr 3, 2013 at 10:58 AM, prafull jadhav > > wrote: >> >>> Dear Anil, >>> >>> Ok..thanks . >>> >>

Re: $$Excel-Macros$$ how to search for max value in alpha neumeric range or col.

Dear Xls Sir, Can you explain the below formula. When we used Lookup formula and Rept . Why you have mention in formula "Z" and 255 ? Thanks in Advance . Regards, Prafull Jadhav. On Thu, Apr 11, 2013 at 10:56 PM, Gum Nam wrote: > HI, > Thanks, I tried your formula it gave

Re: $$Excel-Macros$$ How to Use Conditional SUMIF

Dear Rakesh, find the same with using Sumproduct formula . Reg, Prafull On Wed, Apr 17, 2013 at 5:23 PM, Rakesh Kumar Sharma wrote: > Dear Experts, > > I want the month wise sum amt where the column "tr" is #N/A. I used SUMIF > but i don't know how to use conditional sumif. > > > -- > Regards,

Re: $$Excel-Macros$$ Help Required

Dear Rakesh, find the same. Regards, Prafull jadhav. On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote: > Rakesh: > > Run Pivot table, if no Idea just google it to learn Pivot tables / go to > youtube to learn pivot table. You will learn less time. > > Start exp

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Dear Pankaj,abhishek Sir, I have one query ..the infomration which we feed ..is it stored any where...? (I am new for Macro and VBA) Regards, prafull Jadhav. On Thu, May 2, 2013 at 2:49 PM, pankaj gmail account wrote: > Thank You Abhishek Great! > > I was just looking for the sam

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Dear Sir, Can i get example file so i can practice on it i want to learn macro ,form.which is related to excel VBA. Regards, Prafull Jadhav. MIS exceutive. On Fri, May 3, 2013 at 4:57 PM, Abhishek Jain wrote: > Dear Prafull, > > In this example, no it does not get stored

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

Dear Abhishek Sir, I have just seen web site ..it it good one. I will practice the same ...i know it will take time to understand the whole funda as I am new for the same. thanks a lot Sir Reg, Prafull Jadhav. On Fri, May 3, 2013 at 5:14 PM, Abhishek Jain wrote: > If you're wi

Re: $$Excel-Macros$$ India Heat Map on Excel

Dear Sir, Very good and Creative .. Regards, Prafull Jadhav. On Sat, May 4, 2013 at 12:48 PM, Abhishek Jain wrote: > Very Good. > > > On Sat, May 4, 2013 at 12:42 PM, ashish wrote: > >> <https://lh4.googleusercontent.com/-KfbiDBtwVAE/UYSzzdO-c8I/CWA/Xcxm

Re: $$Excel-Macros$$ Vlookup Help **URGENT**

Find the same ..with useing sumproduct formula. On Mon, May 6, 2013 at 1:59 PM, priti verma wrote: > HI Bhanu , > please see the attachment. > > > On Mon, May 6, 2013 at 1:35 PM, bhanu prakash wrote: > >> Dear All, >> >> In Vlookup, when we have more than 3 to 4 return values, how to pick all >>

Re: $$Excel-Macros$$ Merge cell To Repeat cell value

Dear Abhishekji, Can you provide the code with comments ... On Wed, May 8, 2013 at 6:57 PM, Abhishek Jain wrote: > Here. > > > On Wed, May 8, 2013 at 6:23 PM, Chaya wrote: > >> Dear Experts >> >>I have a query where the sheets have a huge number of merged >> cells. Now i want to r

Re: $$Excel-Macros$$ Split with formula

Dear Priti Madam, Can you explain the same formula in details ... It is perfect .but i want to go into deep... Please explain .. why used Rept and indirect formula. Regards, Prafull On Fri, May 10, 2013 at 11:00 AM, Chaya wrote: > Awesome, its perfectly working. > > Thanks a ton priti for the

Re: $$Excel-Macros$$ Paste Vertically

Dear Abhishk Sir , I have also me the same without VBA ...just for example. I know VBA is better way . On Tue, May 14, 2013 at 5:43 PM, Chaya wrote: > Hi Priti, > > Thank you. your formula contains logic a lot, perfectly working. thanks > once again. > > > Regards, > Chaya > > The excel l

Re: $$Excel-Macros$$ split address one bye one based on "," comma

uot;,REPT(" ",LEN(A7))),* (((ROW(INDIRECT("1:"&LEN(A7)))-1*)*LEN(A7))+1),LEN(A7)))) Regards and Thanks in Advance. Prafull Jadhav. MIS Executive... On Wed, May 15, 2013 at 9:16 AM, Prabhu Pinky wrote: > wow.. really u have big sound in formula... ur formula is confusing to

Re: $$Excel-Macros$$ split address one bye one based on "," comma

Dear Preeti Madam, Got the same ans ..thanks a lot.. Regards, Prafull Jadhav On Wed, May 15, 2013 at 9:32 AM, Prafull Jadhav wrote: > Dear Preeti Madam, > > it is very perfect formula ...Madam I go through the formula > .. earlier also i asked you that what is result of "

Re: $$Excel-Macros$$ IF / Nested IF Formula Help **URGENT**.

Dear Yogesh, use below formula =WEEKNUM() On Tue, May 28, 2013 at 8:27 AM, David Grugeon wrote: > I think you would do better to use a pivot table. Dates can be based on > weeksfor the summarisation. > > Regards > David Grugeon > > > > On 28 May 2013 12:17, Yogesh Vyas wrote: > >> Hi Team,

Re: $$Excel-Macros$$ Look up value from Column and rows

Dear XLS, It is very useful formula and nice formula I was trying the same with sumproduct ...but it not happen... first time i have seen sumifs formula with index and match formula. Regards, Prafull Jadhav MIS executive. On Thu, May 30, 2013 at 1:57 PM, Chaya wrote: > Thank you so m

Re: $$Excel-Macros$$ Uniqe date count citywise

Dear Priti Madam, Can you tell me , What "N" stand in below formula ? On Thu, May 30, 2013 at 2:22 PM, priti verma wrote: > use this as an array formula > > =SUM(N(FREQUENCY(IF($C$1:$C$85=F9,$A$1:$A$85,""),IF($C$1:$C$85=F9,$A$1:$A$85,""))>0)) > > > On Thu, May 30, 2013 at 1:34 PM, Deepak Rawat w

Re: $$Excel-Macros$$

and what about value of alphabet ..only till J ...or further also .K =10.L=11.something. On Mon, Jun 3, 2013 at 11:17 AM, Vikas Bhosale wrote: > In single cell some time two some time three ,four,five,six,some time > seven,eight,nine, not fix. > > Sent from my BlackBerry® Smartphone on Loop

Re: $$Excel-Macros$$

Dear Vikas, if the cell value length is less then 11 then find the solution with Vlookup and Mid function. if length if more then 10 then you have to edit the formula and add the condition. On Mon, Jun 3, 2013 at 11:35 AM, Vikas Bhosale wrote: > Hi Frnd here I attached excel file > Sent fro

Re: $$Excel-Macros$$ use full link to learn Excel

Thanks a lot.It really good one. On Tue, Jun 4, 2013 at 12:27 PM, Nikhil Shah wrote: > Thanks.. > > Nikhil > > > On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar wrote: > >> Dear Frndz, >> >> >> Use full link to learn Excel. please find attached link!!! >> >> >> >> >> http://www.excel-pratiq

Re: $$Excel-Macros$$ Conditional Search & Replace

Dear XLS, if we not declarer variable , will code run properly .? suppose ...we write code as per below. Sub conditionalreplace() For Each Range In Range("D1:D10") If Range.Value < 0.8 Then Range = .80 End If Next End Sub if not ...Please explain

Re: $$Excel-Macros$$ Conditional Search & Replace

Dear Sir, Small Question... then Sir what is exact meaning and use of declare variable in below case? Thanks in Advance . Reg, Prafull Jadhav. On Thu, Jun 6, 2013 at 5:41 PM, Paul Schreiner wrote: > IF you do not utilized "Option Explicit" at the beginning of each module, &g

Re: $$Excel-Macros$$ Conditional Search & Replace

- > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *-

$$Excel-Macros$$ Macro Require.

Dear All, find the excel sheeti need macro for the same Regards, Prafull -- 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,

$$Excel-Macros$$ Horizontal to Vertical in One colume

Dear Expert, Dear All, My date is horizontal ..i want to pull it in one column . thanks in advance Regards, Prafull Jadhav. -- 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$$ Horizontal to Vertical in One colume

Dear Madam, Thanks a lot ... Can we make it from macro ... Regards, Prafull Jadhav. On Fri, Jun 21, 2013 at 11:24 AM, priti verma wrote: > Hi prafull, > > PFA > > > On Fri, Jun 21, 2013 at 11:16 AM, Prafull Jadhav > wrote: > >> Dear Expert, >> Dear All

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Thanks once again.Madam On Fri, Jun 21, 2013 at 11:48 AM, priti verma wrote: > Yes you can do it with macro, > See pfa > > > > On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav > wrote: > >> Dear Madam, >> >> Thanks a lot ... >> >> C

$$Excel-Macros$$ Query in For Each Next

Dear All, Good Morning.. I got below macro from net ..Can you explain me what "x" stand here... *Sub Upper_()* *For Each x In Range("A1:D5")* *'For Each x In Range("A1:D5")* * * *x.Value = UCase(x.Value)* *'x.Value = UCase(x.Value)* * * *Next* * *

Re: $$Excel-Macros$$ Query in For Each Next

Thanks Sir. On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA wrote: > Hi > X refer to each cell in range A1 to D5. > > Thanks > On 3 Jul 2013 10:41, "Prafull Jadhav" wrote: > >> Dear All, >> >> Good Morning.. >> >> >> I g

Re: $$Excel-Macros$$ Need Formula

Dear Prabhakar, find the same ...It is alternate use... Our expert can give you better solution on it. Regards, Prafull Jadhav. MIS-executive. On Fri, Jul 5, 2013 at 11:27 AM, Prabhakar S H wrote: > Hi Team, > > I need your help to get details with formula in attached file.

Re: $$Excel-Macros$$ Simple formula required

Dear Amar, find the same with easy...by using mid function. Regards Prafull On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar wrote: > > -- > *From:* amar takale > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, 4 September 2012 2:01 PM > *Subject:* $$Excel-Macr

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

Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E wrote: > Dear friends, > > Good afternoon, > > I need a help and I want to know how to use vlookup function by using > match and columns function. How it is works? > Plz, share

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

t; 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

Re: $$Excel-Macros$$ Difference Between Iferror & Iserror

both are same. in 2003 there was iferror and in 2007 it replaced by iserror. On Thu, Jul 11, 2013 at 4:09 PM, Raj Kumar wrote: > Hi Group, > > Kindly let us know the difference between Iserror & iferror in excel > > Regards > Raj Bharti > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Deleting Blank Rows

Dear Amit Sir, you can do it by filter data. 1 go at end of row where data is end then last row and select all till top (down to up) 2 filter on it then you will get blank data ...you can remove it easy. Regards, prafull 9920553518 On Sat, Jul 20, 2013 at 6:02 PM, Amit Desai (MERU) wrote: >

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Expert , Can you expline the bold line as i want to know deeply. Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) * StrNew = Mid(strOld, i, 1) & StrNew* Next i R

$$Excel-Macros$$ Un protect the excel file

Dear Experts, I have given password excel file but I have forget the password ..Is there any way to recovery password. Thanks in advance. Regards, Prafull Jadhav. -- 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

Re: $$Excel-Macros$$ Un protect the excel file

Dear Sir, There is no any software for the same . I cant send the file as it contain important information. Regards, Prafull On Tue, Jul 23, 2013 at 2:37 PM, Ankit Mehra wrote: > Hi Prafull, > > Please send the file. > > > On Tue, Jul 23, 2013 at 11:30 AM, Prafull Jadhav

Re: $$Excel-Macros$$ Un protect the excel file

Dear Paul Sir, Thanks for the information . I will search it by Google. Henceforth same will not happen again. Regards Prafull Jadhav. On Tue, Jul 23, 2013 at 5:13 PM, Paul Schreiner wrote: > See Forum Rules #3: > "Don't post questions regarding breaking or bypassing any se

Re: $$Excel-Macros$$ Un protect the excel file

swordrecoverysoftware.org/ > http://www.excelpasswordrecovery.net/ > http://www.elcomsoft.com/aopb.html > http://www.intelore.com/excel-password-recovery.php > > There are also other software you can download from the internet. > > Regards, > Vijaykumar > > > > > > On Tue, Jul 23, 201

Re: $$Excel-Macros$$ Macro for Concatenate

t;|" & Range("A1") > > Please remember, that i in our code is refer to a Range as defined in > first line => Dim i as Range > And Range has default property => Value > i.value will same as i > Range("A1").value will same as just Range("A1"

$$Excel-Macros$$ Chart Query

Dear Expert , I have made pivot ..I want to make it one Graph. I am not able to make it in one Graph... Can anyone can provide the same with attractive Graph. Thanks in Advance. Regards, Prafull jadhav. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

Re: $$Excel-Macros$$ Chart Query

Dear Anil, thanks for the same. Actually I require one chart which contain all information . Regards Prafull Jadhav On Fri, Jul 26, 2013 at 3:52 PM, Anil B wrote: > Hi Prafull, > > Find attached the attractive chart as you requested. > > Thanks, > Anil > > > On F

  1   2   >