Re: $$Excel-Macros$$ removes the jpeg extension

2016-02-07 Thread GENIUS
HI Thank you very much Mr. Ravinder Negi, that's really great -- 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 titl

Re: $$Excel-Macros$$ Get text value in pivot data field.

2016-02-07 Thread Anil Gawli
​Dear Nilkanth, Pls find attached ... is this wht u wr searching? Regards, Anil.​ On Sat, Feb 6, 2016 at 1:23 PM, Nilkanth Raval wrote: > Dear VBA Exoerts, > > Can u please help me in getting Text value in Pivot value field. > > Thanks, > Nilkanth Raval > > Sent with AquaMail for Android > htt

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-07 Thread GENIUS
LOOK AT THE ATTACHMENT -- 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 Please Help,

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-07 Thread amar takale
Dear all thanks for reply but i cant understand what you say.I except only date formula in column D. On Sun, Feb 7, 2016 at 9:36 PM, GENIUS wrote: > LOOK AT THE ATTACHMENT > > -- > 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 Fac

$$Excel-Macros$$ How to execute a function only if the cell is not blank

2016-02-07 Thread James Johnston
Hey guys, I am creating a budget. I set up a google form to enter expenses and now am trying to create the backend. So far I have one sheet for the transactions automatically filled when I use the form, and copied that to a separate data sheet using Importrange, now I am trying to turn the tim

$$Excel-Macros$$ Need Excel Macro Training

2016-02-07 Thread Prabhakar Thakur
Hi Group Member I need excel macro training please share best training institute details or share link Thanks, Prabhakar Thakur New Delhi +919953736776 -- 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

Re: $$Excel-Macros$$ How to execute a function only if the cell is not blank

2016-02-07 Thread Abhishek Jain
=IF(G:G<>"",MONTH(G:G),"") HTH On Mon, Feb 8, 2016 at 12:28 PM, James Johnston wrote: > Hey guys, I am creating a budget. I set up a google form to enter > expenses and now am trying to create the backend. > > So far I have one sheet for the transactions automatically filled when I > use the f