Attached herewith sheet for solution. Please help.
--
Nemi Gandhi
98204 92963
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
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
?
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Nemi Gandhi
*Sent:* 03 May 2012 16:18
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Rising
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 krishnak...@gmail.com wrote:
Hi,
I assume you enter NOW() in Q3.
In R3:
=MOD(Q3,1)
In S3:
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
Please provide formula. sheet attached.
--
Nemi Gandhi
98204 92963
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ RISING LAGNA
Please provide formula. sheet attached.
--
Nemi Gandhi
98204 92963
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need
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
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