Re: $$Excel-Macros$$ Copy data from multiple sheets into single sheet.

2014-03-29 Thread Satiqjaffar ali
thanks a lot Ravinder On 27 March 2014 13:08, Ravinder ravindervbacli...@gmail.com wrote: PFA *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Satiqjaffar ali *Sent:* Wednesday, March 26, 2014 11:47 PM *To:* excel-macros@googlegroups.com

$$Excel-Macros$$ sum numbers only

2013-12-16 Thread Satiqjaffar ali
Hello experts, Can you please assist me to sum numbers only in cell. Please find attachment and assist. 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 @

Re: $$Excel-Macros$$ sum numbers only

2013-12-16 Thread Satiqjaffar ali
Hello Priti, Thanks for effort, and can you please explain the same with SUMIFS function.? On 16 December 2013 21:01, priti verma pritiverma1...@gmail.com wrote: Hi Satiqjaffar ali, Please try this With Control + Shift + enter =SUM(IFERROR(VALUE(IF(G16F17=$E$6:$E$12$F$6:$F$12,$G$6:$G$12

$$Excel-Macros$$ VLOOKUP doubt

2013-09-23 Thread Satiqjaffar ali
Hello experts, I have some doubt in VLOOKUP, that how can i get lookup value from previous cell?. please find the attached sheet and advice.. thanks a lot. Thanks Satiq -- 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