$$Excel-Macros$$ Urgent SQL code required

2014-09-24 Thread manish mishra
Hi all, Required is SQL codes for the below data and results Cust_IDProd_RangeA1P1A1P2A1P3A2P4A2P5Required result is A1P1/P2/P3A2P4/P5 Please help its bit urgent -- 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 th

Re: $$Excel-Macros$$ Whats Wrong with the applied formulae

2013-12-01 Thread manish mishra
Oh ya... It is working SAM and ashish... Thanks to you both buddy... :) On Sun, Dec 1, 2013 at 10:06 PM, Sam Mathai Chacko wrote: > As Ashish mentioned, you need to correct the dates on the top row. > > Regards, > Sam Mathai Chacko > > > On Sun, Dec 1, 2013 at 8:58 PM

Re: $$Excel-Macros$$ Whats Wrong with the applied formulae

2013-12-01 Thread manish mishra
; > On Sun, Dec 1, 2013 at 8:48 PM, manish mishra wrote: > >> When i am dragging it towards right why is it copying all ?? >> >> >> >> On Sun, Dec 1, 2013 at 8:46 PM, manish mishra >> wrote: >> >>> can it be done with index match ?? >>

Re: $$Excel-Macros$$ Whats Wrong with the applied formulae

2013-12-01 Thread manish mishra
When i am dragging it towards right why is it copying all ?? On Sun, Dec 1, 2013 at 8:46 PM, manish mishra wrote: > can it be done with index match ?? > > > > On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote: > >> try this >> =VLOOKUP($A2,Sheet2!$A$1:$CC$80,M

Re: $$Excel-Macros$$ Whats Wrong with the applied formulae

2013-12-01 Thread manish mishra
can it be done with index match ?? On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote: > try this > =VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0) > > On Sun, Dec 1, 2013 at 7:52 PM, manish mishra wrote: > >> Whats Wrong with the applied formulae