$$Excel-Macros$$ Querry ncg

Plaease provide solution. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ htt

$$Excel-Macros$$ querry ncg

attached sheet. Please provide formula and vab code if possible. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

Re: $$Excel-Macros$$ Querry ncg

check the attachment On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi wrote: > Plaease provide solution. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Querry ncg

I suggest simply selecting your name cells in col B>data>text to columns>space>finish Don Guillett SalesAid Software dguille...@gmail.com From: Nemi Gandhi Sent: Saturday, October 08, 2011 4:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Querry ncg Pla

Re: $$Excel-Macros$$ Querry ncg

Thanks excel macro freinds. Nemi Gandhi On Oct 8, 8:46 pm, ashish koul wrote: > check the attachment > > > > > > > > > > On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi wrote: > > Plaease provide solution. > > > -- > > Nemi Gandhi > > 98204 92963 > > >  -- > > >

Re: $$Excel-Macros$$ Querry ncg

Freinds, In the querry worksheet, the data was in b3 and c3 and result is generated from e3 and f3 , but in actual, my data is available in column J222 and k222 in sheet named "kundali" , and i tried to change the range in Macro but failed. Hence, please send me the details as to where i should c

Re: $$Excel-Macros$$ Querry ncg

Sub test() Dim i As Long, j As Long, k As Long ' change 3 with the row no from which ur data is starting j = 222 For i = 222 To Range("j65356").End(xlUp).Row splt = Split(Application.WorksheetFunction.Trim(Range("k" & i).Value)) For k = LBound(splt) To UBound(splt) Sheets(1).Range("l" & j).V

Re: $$Excel-Macros$$ querry ncg

=INDEX($H:$AA,MATCH(A2,H:H,0)+B2,MATCH(C2,$H$3:$T$3,0)) On Wed, Oct 19, 2011 at 12:41 PM, Nemi Gandhi wrote: > attached sheet. Please provide formula and vab code if possible. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -

Re: $$Excel-Macros$$ querry ncg

Dear Nemi, Please try below formula and see attached sheet.. {=OFFSET(INDEX($I$3:$T$3,MATCH(C2,$I$3:$T$3,0)),MATCH(B2,$H$4:$H$15,0),0)} -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*