$$Excel-Macros$$ Posts

2014-12-10 Thread Nemi Gandhi
Since 17 Nov, i am not getting any posts. Please continue as its very helpful. -- Nemi Gandhi 98204 92963 -- 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

Re: $$Excel-Macros$$ Querry production analysis

2014-12-03 Thread Nemi Gandhi
Dear Vaibhav, Thanks the solution is very good. Nemi Gandhi On Mon, Dec 1, 2014 at 6:58 PM, Vaibhav Joshi 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.* > &g

$$Excel-Macros$$ membership

2014-11-28 Thread Nemi Gandhi
i was getting the posts of this group regularly but lst week, i thru oversight clicked "unsubscribe" and not getting posts. Please continue my membership and send me posts as its very useful for me to learn. -- Nemi Gandhi 98204 92963 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc

$$Excel-Macros$$ Querry-serial no

2013-11-05 Thread Nemi Gandhi
A excel sheet is attached. Please provide me solution to it. Thanks -- Nemi Gandhi 98204 92963 -- 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

$$Excel-Macros$$ Re: 2 LOOKUP-2 MATCH FUNCTION

2013-09-13 Thread Nemi Gandhi
Thank you very much Ravinderji... Nemi Gandhi On Thursday, September 12, 2013 1:36:05 PM UTC+5:30, Nemi Gandhi wrote: > > Attached worksheet for Nakshatra match gunank function. please give me > formula. > > -- > Nemi Gandhi > 98204 92963 > -- Are you =EXP(E:R

$$Excel-Macros$$ Rising lagna-astrology

2012-05-03 Thread Nemi Gandhi
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

$$Excel-Macros$$ no mail since long

2012-02-04 Thread Nemi Gandhi
. -- 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 attention or may not be answered. 2) Don't p

Re: $$Excel-Macros$$ lagna rising

2012-01-15 Thread Nemi Gandhi
(P3,$B$4:$B$28,0)+4),1)) > > > ** ** > > > *From:* excel-macros@googlegroups.com [mailto: > > excel-macros@googlegroups.com] *On Behalf Of *Nemi Gandhi > > *Sent:* Jan/Fri/2012 03:29 > > *To:* excel-macros@googlegroups.com > > *Subject:* $$Excel-Macros$$

$$Excel-Macros$$ lagna rising

2012-01-13 Thread Nemi Gandhi
Problem in getting result, hence sheet is attached once again. Nem Gandhi -- 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

Re: $$Excel-Macros$$ RISING LAGNA

2012-01-13 Thread Nemi Gandhi
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

Re: $$Excel-Macros$$ RISING LAGNA

2012-01-11 Thread Nemi Gandhi
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

$$Excel-Macros$$ RISING LAGNA

2012-01-11 Thread Nemi Gandhi
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

Re: $$Excel-Macros$$ grah+date querry

2011-11-27 Thread Nemi Gandhi
gt;> 11/27/2011 > >> 18:53  SHUKR 247 247.6416355 11/27/2011 20:53  SHUKR 247 247.7450081 > >> 11/27/2011 > >> 22:53  SHUKR 247 247.8483793 11/28/2011 0:53  SHUKR 247 247.9517491 > >> 11/28/2011 > >> 2:53  SHUKR 247 248.0551177 11/28/2011 4:53 > >> N

Re: $$Excel-Macros$$ grah querry

2011-11-16 Thread Nemi Gandhi
;),COUNTA($C$2:$C2))),"") > * as CSE formula > *=IF($G21<>"",INDEX($C$2:$C$14,MATCH($G21,$B$2:$B$14,0)),$G21)* > > Check attached sample. > > Regards, > > Sam Mathai Chacko > > > > > > > > > > On Wed, Nov 16, 2011 at 8:0

$$Excel-Macros$$ ASCENDANT QUERRY.

2011-11-16 Thread Nemi Gandhi
SHEET ATTACHED. -- Nemi Gandhi 98204 92963 -- FORUM RULES (934+ 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 attention or may not be

$$Excel-Macros$$ grah querry

2011-11-16 Thread Nemi Gandhi
Please help me sorting the data. -- Nemi Gandhi 98204 92963 -- FORUM RULES (934+ 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 attention

Re: $$Excel-Macros$$ querry

2011-10-21 Thread Nemi Gandhi
  Please see my corrected macro solution? > > >> Don Guillett > >> SalesAid Software > >> dguille...@gmail.com > > >>  *From:* Nemi Gandhi > >> *Sent:* Thursday, October 20, 2011 1:51 AM > >> *To:* excel-macros@googlegroups.com > >

$$Excel-Macros$$ querry

2011-10-19 Thread Nemi Gandhi
Thanks Ashishbhai and Noorainbhai, but i made little mistake in asking query and is posted agains. The result i want is if A2=surya or chandra or mangal or budh or guru or shukra or shani, look for value in appropriate table and get result. -- Nemi Gandhi 98204 92963

$$Excel-Macros$$ querry ncg

2011-10-19 Thread Nemi Gandhi
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 : http://twitter.com

Re: $$Excel-Macros$$ Querry ncg

2011-10-11 Thread Nemi Gandhi
lease do needful. On Oct 10, 12:10 pm, Nemi Gandhi wrote: > Thanks excel macro freinds. > > Nemi Gandhi > > On Oct 8, 8:46 pm, ashish koul wrote: > > > > > > > > > check the attachment > > > On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi

Re: $$Excel-Macros$$ Querry ncg

2011-10-10 Thread Nemi Gandhi
Thanks excel macro freinds. Nemi Gandhi On Oct 8, 8:46 pm, ashish koul wrote: > check the attachment > > > > > > > > > > On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi wrote: > > Plaease provide solution. &

$$Excel-Macros$$ Querry ncg

2011-10-08 Thread Nemi Gandhi
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

$$Excel-Macros$$ querry 5

2011-07-04 Thread Nemi Gandhi
Formula needed please. -- 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 @ http

$$Excel-Macros$$ querry 4

2011-06-20 Thread Nemi Gandhi
please see the attached file. Please help. -- 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

Re: $$Excel-Macros$$ querry 3

2011-06-18 Thread Nemi Gandhi
Thank you very much Daniel. Thats the result i am looking at. Very nice Nemi Gandhi On Jun 17, 2:31 pm, "Daniel" wrote: > See attached file. > > Daniel > > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De > la part de Nemi Gandhi >

Re: $$Excel-Macros$$ querry-3

2011-06-17 Thread Nemi Gandhi
Thank you Daniel, but still need some correction and explanation for my knoledge. Querry is posted once again. Nemi Gandhi. On Jun 16, 10:59 am, "Daniel" wrote: > See attached file. > > Regards. > > Daniel > > De : excel-macros@googlegroups.com [mailto:ex

$$Excel-Macros$$ querry 3

2011-06-17 Thread Nemi Gandhi
attached once again for some correction and explanation for my knowledge. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ querry-3

2011-06-16 Thread Nemi Gandhi
Dear Members, i need the formula please.. -- 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

Re: $$Excel-Macros$$ querry new

2011-06-16 Thread Nemi Gandhi
Many thanks Danielresult is perfect. One more querry is posted. Please help. On Jun 15, 2:40 pm, "Daniel" wrote: > Maybe this file ? > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De

Re: $$Excel-Macros$$ querry new

2011-06-15 Thread Nemi Gandhi
;. So in target D19:O30, all cells hould be blank, except J22, which should display "yes". On Jun 14, 1:21 pm, "Daniel" wrote: > Have a look at the attached file. > > Daniel > > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.co

$$Excel-Macros$$ querry new

2011-06-14 Thread Nemi Gandhi
file is attached. i need formula please. -- 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

$$Excel-Macros$$ querry

2011-04-08 Thread Nemi Gandhi
Please reply. -- 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 @ http

Re: Fwd: $$Excel-Macros$$ new querry

2011-03-04 Thread Nemi Gandhi
Thanks all for solution. Nemi Gandhi On Mar 3, 3:10 pm, §»VIPER«§ wrote: > Hi > > Ignore my previous mail. Now check the attachment and revert if it is not > helpful. > > -- > *Thanks & Regards > > Thamu > * > > > > On Wed, Mar 2, 2011 at 10:45 A

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-03-01 Thread Nemi Gandhi
Hi, "excel simplified" is best and simple idea. Like "High thinking and simple living". Best of luck. Nemi Gandhi On Mar 1, 7:09 pm, Ayush Jain wrote: > Thank you group for all awesome ideas. Though, I was looking for Tagline > only, you have provided the awesome

$$Excel-Macros$$ new querry

2011-03-01 Thread Nemi Gandhi
attached again with explanation. -- 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

$$Excel-Macros$$ nakshtra querry

2011-02-28 Thread Nemi Gandhi
i had put the above querry, but now i have found the solution, so for benefit of excel users, posting once again with solution. further, one more querry is put. Please help? -- Nemi Gandhi 98204 92963 -- -- Some

$$Excel-Macros$$ Nakshtra querry

2011-02-23 Thread Nemi Gandhi
file is attached. Please help. -- 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

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-16 Thread Nemi Gandhi
0,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)),$A$2:$C$15,3,1) > > > > On Tue, Feb 15, 2011 at 4:43 PM, Nemi Gandhi wrote: > > Thank you Mr. sundervalen, but i need only one formula instead of > > calculating value for date,

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-15 Thread Nemi Gandhi
> 9600160150 > > > > On Mon, Feb 14, 2011 at 8:08 PM, ashish koul wrote: > > see if it helps > > > On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi wrote: > > >> attached herewith rashi querry sheet. Please provide me formula

$$Excel-Macros$$ RASHI QUERRY

2011-02-14 Thread Nemi Gandhi
attached herewith rashi querry sheet. Please provide me formula and help. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ Re: HOW TO MAKE PROJECT MANAGEMENT IN EXCEL

2011-02-08 Thread Nemi Gandhi
click following link and see if its useful. http://chandoo.org/pmt/pmt-index-1.html?amp= Nemi Gandhi On Feb 7, 6:45 am, solomon raju wrote: > Hi All, > > Can some one explain me or refer me where I get more detailed information > regarding Project management in Excel. > > If

$$Excel-Macros$$ QUERRY

2011-01-31 Thread Nemi Gandhi
PLEASE HELP. -- 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 @ http