Dear Nemi
can u please explain step wise your issue.
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 7:04 PM, Rajan_Verma wrote:
> ** **
>
> Hi,
>
> As I remember ,I have seen this file before 3-4 months on group, can you
> please explain it more .. what you want to do ?
>
> ** **
>
Hi,
As I remember ,I have seen this file before 3-4 months on group, can you
please explain it more .. what you want to do ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: 03 Ma
What do you want where and why. Explanations are always nice.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Nemi Gandhi
Sent: Thursday, May 03, 2012 5:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rising lagna-astrology
Attached herewith shee
Thanks Kris, the formmula works, but one more problem has come. Sheet
is attached again for providing solution.
Nemi
On Jan 12, 8:01 am, Kris wrote:
> Hi,
>
> I assume you enter NOW() in Q3.
>
> In R3:
>
> =MOD(Q3,1)
>
> In S3:
>
> =INDEX(D4:O4,,MATCH(MIN(ABS(R3-INDEX(D5:O28,MATCH(INT(Q3),INT(C5
Hi,
I assume you enter NOW() in Q3.
In R3:
=MOD(Q3,1)
In S3:
=INDEX(D4:O4,,MATCH(MIN(ABS(R3-INDEX(D5:O28,MATCH(INT(Q3),INT(C5:C27),0),0))),ABS(R3-INDEX(D5:O27,MATCH(INT(Q3),INT(C5:C27),0),0)),0))
Again Array formula.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use c
Thanks Kris, the formula is working, bit i am facing problem as in my
sheet as the Time and Date is entered as =now() in formula and hence
getting result #NA. if i am putting the date as 11-1-2012 and time as
11:03 , then the result comes. But i have to put the date and time as
=now() only. So sho
Hi
Try this array formula.
=INDEX(D4:O4,,MATCH(MIN(ABS(R3-INDEX(D5:O28,MATCH(Q3,INT(C5:C27),0),0))),ABS(R3-INDEX(D5:O27,MATCH(Q3,INT(C5:C27),0),0)),0))
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Try this:
=IFERROR(OFFSET($C$4,,MATCH(R3,INDIRECT("C"&ROW(INDEX($C$4:$C$28,MATCH(Q3,C4
:C28,0),1))&":O"&ROW(INDEX($C$4:$C$28,MATCH(Q3,C4:C28,0),1))),0)-1,1,1),"Not
Found")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: Jan/Wed/2012
