$$Excel-Macros$$ Making a mistake in the formula

2016-03-01 Thread Izhar
Please see the attachment, in the file I'm subtracting G2 from C2 with the formula, can anyone tell me where I'm making a mistake Thanks in advance -- 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 @

$$Excel-Macros$$ Edit Logo possible?

2016-03-01 Thread amar takale
Dear Friends This possible to edit this logo bcos I like this to rename my excel sheet name. Regards Amar -- 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

Re: $$Excel-Macros$$ If Condition formula required

2016-03-01 Thread amar takale
Dear Paul Sir Pls look into this topic.I think we will use (If+Search) formula but I cant possible how to modified it. Regards Amar On Mon, Feb 29, 2016 at 7:49 PM, amar takale wrote: > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ Edit Logo possible?

2016-03-01 Thread amar takale
Dear Paul Sir I was trying every method as per my knowledge to rename it but not success. So then I feel that to get guidance from our excel group.So I ask this no any issue about that. Thanks again sir Regards Amar On Tue, Mar 1, 2016 at 7:49 PM, Paul Schreiner

Re: $$Excel-Macros$$ Edit Logo possible?

2016-03-01 Thread Abhishek Jain
Dear Amar, To me this seems to a wordart object, you can re-create it and try to make as similar as possible or change it all the way to your likings. Please see a sample attached. Under the Format tab, you can change it as you may like, including the text. HTH On Wed, Mar 2, 2016 at 10:25 AM,

Re: $$Excel-Macros$$ Edit Logo possible?

2016-03-01 Thread amar takale
Thanks Abhishek sir On Wed, Mar 2, 2016 at 10:44 AM, Abhishek Jain wrote: > Dear Amar, > > To me this seems to a wordart object, you can re-create it and try to make > as similar as possible or change it all the way to your likings. > > Please see a sample attached.

Re: $$Excel-Macros$$ If Condition formula required

2016-03-01 Thread Abhishek Jain
Please see attached. HTH On Wed, Mar 2, 2016 at 10:28 AM, amar takale wrote: > Dear Paul Sir > > Pls look into this topic.I think we will use (If+Search) formula but I > cant possible how to modified it. > > Regards > Amar > > On Mon, Feb 29, 2016 at 7:49 PM, amar takale

Re: $$Excel-Macros$$ Making a mistake in the formula

2016-03-01 Thread GENIUS
Thank you very much for your time -- 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

$$Excel-Macros$$ Help required to use GetConcat(A13) & macro using

2016-03-01 Thread big smile
Respected All Last time some brothers have help to make this file perfect I want some clarification / suggestion on this file I have approx more than 1000 entries to do in this file 1]When I start inserting lines & copy

$$Excel-Macros$$ Client in NYC, NY need Tivoli-Dynamic Workload Console(TWC) & DWC Installation/ Configuration Admin

2016-03-01 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *TWC & DWC Installation/ Configuration Admin.* · DWC - Dynamic Workload Console *· TWC – Tivoli-Dynamic Workload Console/ Old version is Job Schedule Console (JSC)* *9 months contract*

Re: $$Excel-Macros$$ Edit Logo possible?

2016-03-01 Thread Paul Schreiner
Technically, the answer to your question is "yes". But not the way you intended it.this isn't a text box, or a shape with text.It's a picture. You can edit pictures by opening them (or copy/pasting them) into an editor like Paint. But, it's probably easier to simply create another picture and

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-03-01 Thread Paul Schreiner
There's no doubt many ways to handle this.A couple come to mind.Windows does some funny things when listing files in a folder.The first file it comes to isn't always the first alphanumerically, or even the oldest or newest.sometimes, it just starts in the middle and goes through to the end,

Re: $$Excel-Macros$$ Making a mistake in the formula

2016-03-01 Thread Paul Schreiner
The INDEX() formula syntax is: INDEX(array, row_num, [column_num]) In your formula:=C2-INDEX($E$2:$G$350,MATCH($A2,$E$2:$E$350,0),MATCH($B2,$F$2:$F$350,0))Your second MATCH() function is comparing the value in column "B" (Size) tothe values in column "F" and returns the row number as if it

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-03-01 Thread Devendra Sahay
Hi Paul, Thanks for writing the code but will you please integrate the below code in the existing macro, So that user can select the folder where he want to save the files OR Please write a code to save a copy of Sheet 1 in the path which we have given in Filelist. (B1) For the image sequence,