Dear Vaibhav,
Thanks the solution is very good.
Nemi Gandhi
On Mon, Dec 1, 2014 at 6:58 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
You can do using PVT table, check this...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 1, 2014 at
Appreciate acknowledgement..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Dec 4, 2014 at 11:41 AM, Nemi Gandhi nemigan...@gmail.com wrote:
Dear Vaibhav,
Thanks the solution is very good.
Nemi Gandhi
On Mon, Dec 1, 2014 at 6:58 PM,
Hi Vaibhav Bhai,
It's Simple and Superb Solution.
Regards
Ashish
--
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
PFA, r u looking for this...?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: Tuesday, November 05, 2013 11:23 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Querry-serial no
A excel sheet is
Thanks sam, a simple formula works.
thanks again. Nemi
On Oct 20, 7:18 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Formula =OFFSET(INDEX($H$1:$H$105,MATCH($A2,$H$1:$H$105,0)),$B2,$C2)
On Thu, Oct 20, 2011 at 4:13 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Don't think we
Dear Nemi,
Please see attached sheet with Solution as per your requirement.
i hope it will help to u.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Thu,
Formula =OFFSET(INDEX($H$1:$H$105,MATCH($A2,$H$1:$H$105,0)),$B2,$C2)
On Thu, Oct 20, 2011 at 4:13 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Don't think we need an array for that. Here's a simple formula that will
look from all the 7 tables without an array formula.
Regards,
Sam Mathai
Sure SAM,
Array is not necessary for thi.
On Thu, Oct 20, 2011 at 7:48 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Formula =OFFSET(INDEX($H$1:$H$105,MATCH($A2,$H$1:$H$105,0)),$B2,$C2)
On Thu, Oct 20, 2011 at 4:13 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Don't think we need an
Hello Nemi;
You can also use simple HLOOKUP.
=HLOOKUP(C2,I$3:T$105,MATCH(A2,H$3:H$105,0)+B2,0)
C2, here column heading B2 is the row values located in Col_H
HTH
Haseeb
--
--
Some important links for excel users:
=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
--
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.
try this
Option Base 1
Sub nemi()
Dim s(5) As String
Dim z As Long
s(1) = Very Good
s(2) = Good
s(3) = Better
s(4) = Bad
s(5) = Very Bad
For i = 1 To 5
On Error Resume Next
Sheets(1).ShowAllData
z = Sheets(1).Range(f65356).End(xlUp).Row + 1
Sheets(1).Range($A$3:$e$
your formula will come in this form
=IF(AND(E5=60,D5=60),D3+D4+1-60,)
On Mon, Jun 20, 2011 at 6:15 PM, Nemi Gandhi nemigan...@gmail.com wrote:
please see the attached file. Please help.
--
Nemi Gandhi
98204 92963
--
Thank you very much Daniel. Thats the result i am looking at. Very
nice
Nemi Gandhi
On Jun 17, 2:31 pm, Daniel dcolarde...@free.fr wrote:
See attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17
I have trouble understanding ; can you post which result is expected ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3
See attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3
attached once again for some correction and explanation
See attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3
attached once again for some correction and explanation
Envoyé : mercredi 15 juin 2011 08:44
À : MS EXCEL AND VBA MACROS
Objet : Re: $$Excel-Macros$$ querry new
Thank you Daniel, but when i drag the formula to other cells in column
D22:022, , it whows 'YES. Only J22 column should show YES'
and all other cells should be blank because D4:04 (except
See attached file.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : jeudi 16 juin 2011 13:02
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry-3
Dear Members,
i need the formula please..
--
Thank you Daniel, but when i drag the formula to other cells in
column D22:022, , it whows 'YES. Only J22 column should show YES'
and all other cells should be blank because D4:04 (except J4 against
surya and col 7 YES is mentioned) has NO. So in target D19:O30,
all cells hould be blank, except
Maybe this file ?
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : mercredi 15 juin 2011 08:44
À : MS EXCEL AND VBA MACROS
Objet : Re: $$Excel-Macros$$ querry new
Thank you Daniel, but when i drag
Have a look at the attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : mardi 14 juin 2011 13:47
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry new
file is attached. i need formula please.
--
*=_xlfn shows that the following Fuction exist in higher Version of excel
but not in Lower Version.. Exce Automatically Include =_xlfn .. when file
open in Lower Version of Excel,,*
On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan dppin...@gmail.com wrote:
Dear Ashish,
Pl. explain what is
Thanks Siti, Ranjan
for sharing useful information
On Mon, Apr 11, 2011 at 1:25 PM, rajan verma rajanverma1...@gmail.comwrote:
*=_xlfn shows that the following Fuction exist in higher Version of excel
but not in Lower Version.. Exce Automatically Include =_xlfn .. when file
open in Lower
Pl. explain what is *=_xlfn*.???
Is it User Defined function or what else?
Regards,
Dhanajay
On Sat, Apr 9, 2011 at 9:22 PM, ashish koul koul.ash...@gmail.com wrote:
sumifs function is avaliable in excel 2007 onwards check out the link below
_xlfn IS
http://office.microsoft.com/en-us/excel-help/issue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-HA010204569.aspx
On Sat, Apr 9, 2011 at 11:02 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Pl. explain what is *=_xlfn*.???
Is it User Defined function or what else?
Regards,
see if it helps
On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi nemigan...@gmail.com wrote:
Please reply.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi Nemi
find attach
On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi nemigan...@gmail.com wrote:
Please reply.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Dear Ashish,
Pl. explain what is *=_xlfn.*SUMIFS($G:$G,$M:$M,$P6,$F:$F,$O6,$D:$D,Q$5)
Regards,
Dhananjay
On Sat, Apr 9, 2011 at 4:07 PM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi nemigan...@gmail.com wrote:
Please reply.
--
sumifs function is avaliable in excel 2007 onwards check out the link below
http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx
On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan dppin...@gmail.com wrote:
Dear Ashish,
Pl. explain what is
check the attachment
On Mon, Jan 31, 2011 at 4:04 PM, Nemi Gandhi nemigan...@gmail.com wrote:
PLEASE HELP.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Dear Nemi,
Please find attached sheet with solution..
--
Thanks regards,
Noorain Ansari
On Mon, Jan 31, 2011 at 4:04 PM, Nemi Gandhi nemigan...@gmail.com wrote:
PLEASE HELP.
--
Nemi Gandhi
98204 92963
--
Hi Nimi,
Please find your answer
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Nemi Gandhi
Sent: Monday, January 31, 2011 4:05 PM
To: excel-macros@googlegroups.com
Subject:
38 matches
Mail list logo
