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 :
=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 nemigan...@gmail.com wrote:
attached sheet. Please provide formula and vab code if possible.
--
Nemi Gandhi
98204 92963
--
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://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
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
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).Value =
Thanks excel macro freinds.
Nemi Gandhi
On Oct 8, 8:46 pm, ashish koul koul.ash...@gmail.com wrote:
check the attachment
On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi nemigan...@gmail.com wrote:
Plaease provide solution.
--
Nemi Gandhi
98204 92963
--
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 @
check the attachment
On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi nemigan...@gmail.com wrote:
Plaease provide solution.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us
I suggest simply selecting your name cells in col Bdatatext to
columnsspacefinish
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
Plaease provide solution
