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
Dear Nemi
can u please explain step wise your issue.
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 7:04 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
** **
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
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
Try this:
=IFERROR(OFFSET($C$4,,MATCH(R3,INDIRECT(CROW(INDEX($C$4:$C$28,MATCH(Q3,C4
:C28,0),1)):OROW(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 05:40
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