$$Excel-Macros$$ Position on Bigdata /hadoop developer with Datameer in Dallas Texas (Today Interview)

2016-08-09 Thread Saidulu N
Hi, Please send me resume to : sidhuni...@gmail.com Role: * Sr. Big Data / Hadoop developer* Location: * Dallas Texas* Duration:* 6 Months**+ extendable* *Interview : Phone + Skype* *Need to submit H1b copy and photo id* Don't send me resume without Data Meer *3-5 years

$$Excel-Macros$$ I have genuine consultants--on Oracle techno functional Consultant

2016-08-09 Thread Saidulu N
Hi, I have genuine consultants Please share me requirements on: 1. Oracle techno functional Consultant 2. Oracle functional Consultant *Please send me rate conformation mail to: sidhuni...@gmail.com * *Thanks & Regards,* *Sidhu* *3100 Mowry Avenue **Suite

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-08-09 Thread Neelakanta
Please add my number 9611911833 Neel Sent from my iPhone > On 09-Aug-2016, at 6:11 PM, Satheesh Arumugam Naidu > wrote: > > pl add my number 8861087687 Satheesh > >> On Tue, Aug 9, 2016 at 12:42 PM, Anil Gawli wrote: >> pls add my number

Re: $$Excel-Macros$$ Copy Paste Problem

2016-08-09 Thread Gaurav Devrani
Hi Shrini, In that case either you need to grab all the data from those different location to the file which i sent and paste that data in column A and code will automatically check the range size. And if you dont want to copy the data manually and you want to automate this process too, then

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-08-09 Thread Sandeep Chhajer

Re: $$Excel-Macros$$ Using Small Formula

2016-08-09 Thread sourav devrani
thanks NOORAIN sir its is working cool. On Tue, Aug 9, 2016 at 5:36 AM, NOORAIN ANSARI wrote: > Dear Sourav, > > Please try it > > =INDEX($A$1:$A$20,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20),""),ROW(A1))) > Press Ctrl+Shift+Enter >

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-08-09 Thread Satheesh Arumugam Naidu
pl add my number 8861087687 Satheesh On Tue, Aug 9, 2016 at 12:42 PM, Anil Gawli wrote: > pls add my number 9769855615 Anil Gawli​ > > On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > >> please add the my number 9811503853 >> >> On Friday, 5

Re: $$Excel-Macros$$ Using Small Formula

2016-08-09 Thread NOORAIN ANSARI
Dear Sourav, Please try it =INDEX($A$1:$A$20,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20),""),ROW(A1))) Press Ctrl+Shift+Enter =OFFSET($A$1,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)-1,""),ROW(A1)),0) Press Ctrl+Shift+Enter See attachment for more clarity... On Tue, Aug 9, 2016 at 5:48 PM, sourav

Re: $$Excel-Macros$$ Using Small Formula

2016-08-09 Thread sourav devrani
Hi Abhishek, [image: Inline image 1] On Mon, Aug 8, 2016 at 12:50 PM, Abhishek Jain wrote: > =lower(a1) > > A1 is your first value, then you can drag. > > On Monday, August 8, 2016, sourav devrani > wrote: > >> A >> >> B >> >> C >> >> D >>

Re: $$Excel-Macros$$ Copy Paste Problem

2016-08-09 Thread Shrinivas Shevde
Dear Sir Thanks for Problem Actually I want to copy paste more than 50 items from various locations In that case How will I use this macro. So I want way to copy paste ot macro Regards Shrinivas On Tue, Aug 9, 2016 at 4:09 PM, Gaurav Devrani wrote: > Hi Shrini, > >

Re: $$Excel-Macros$$ lookup and sum

2016-08-09 Thread Paul Schreiner
This should be a simple =sumif() function: in Cell B2, use:=SUMIF(Sheet2!A:A,A2,Sheet2!B:B) and copy down. Paul- “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

Re: $$Excel-Macros$$ Copy Paste Problem

2016-08-09 Thread Gaurav Devrani
Hi Shrini, Please check the attached file. Let me know if this does not solve your query. Regards Gaurav Devrani On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde wrote: > Dear all > I have data in Column A in 1to 6 rows . I want to copy paste in Column F > but in

$$Excel-Macros$$ please add the my number 9582279261

2016-08-09 Thread 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS
please add the my number 9582279261 -- 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,

$$Excel-Macros$$ Copy Paste Problem

2016-08-09 Thread Shrinivas Shevde
Dear all I have data in Column A in 1to 6 rows . I want to copy paste in Column F but in column F 2 rows are merged .I want outout as shown in column I but I am getting as shown in F .Is there any way o copy paste data from non merged cell to merged cell Thanks in Advance. -- Shrini -- Are

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-08-09 Thread Anil Gawli
pls add my number 9769855615 Anil Gawli​ On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if

Re: $$Excel-Macros$$ lookup and sum

2016-08-09 Thread सचिन शर्मा
Please find the attached sheet. On Tuesday, August 9, 2016 at 11:25:12 AM UTC+5:30, lakshm...@yahoo.com wrote: > > thanks > > > > > > On Tuesday, August 9, 2016 11:21 AM, Abhishek Jain > wrote: > > > PFA > > On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL