Re: $$Excel-Macros$$ Need Conditioning Format Help

2012-07-08 Thread NOORAIN ANSARI
Dear Imran, Try it Change formula as per column. $B5<$C5 and $B5>$C5 On Mon, Jul 9, 2012 at 12:09 PM, Imran khan wrote: > Hi, > > I need Conditioning format formula that IF Column B>Column C OR D>E, F>G > etc some color should showed and IF Column C>B, or E>D etc some different > color sh

$$Excel-Macros$$ Re: Nokia PC Suit API !!

2012-07-08 Thread B Sharma
Hiii Rajan, Please find the link.. http://www.developer.nokia.com/Resources/Tools_and_downloads/Other/PC_Connectivity_API/ Hope that you are searching for the same. On Sunday, July 8, 2012 10:06:36 PM UTC+5:30, Rajan_Verma wrote: > > *Hi Group,* > > * * > > *I am searching for PC Suit API, if

Re: $$Excel-Macros$$ Working days per employee (macro)

2012-07-08 Thread Lalit_Mohan
Dear Lokesh, For the blank cell issue just replace the TRUE with FALSE in .Pastespecial command line. And for the formulas what you have mentioned, i didn't find any formula in D3:I10 range.could u please clarify it. Regards, Lalit Mohan +91 9711867226 On Sunday, 8 July 2012 21:57:32 UTC+

Re: $$Excel-Macros$$ Nokia PC Suit API !!

2012-07-08 Thread ChilExcel
Hi Rajan Please see attached link .. (you must translate) http://jose-juan.computer-mind.com/jose-juan/PC-Suite-Connectivity-API.php Chilexcel 2012/7/8 Rajan_Verma > *Hi Group,* > > * * > > *I am searching for PC Suit API, if anybody have any good link where I > can download , please revert,

$$Excel-Macros$$ Nokia PC Suit API !!

2012-07-08 Thread Rajan_Verma
Hi Group, I am searching for PC Suit API, if anybody have any good link where I can download , please revert, I have google it but failed Regards Rajan verma +91 7838100659 [IM-Gtalk] -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread title

Fwd: $$Excel-Macros$$ Vlookup or Match formula - regionwise

2012-07-08 Thread santosh subudhi
Hi Sreejith, Attached is another excel sheet with total region wise sales and also the employee wise (both conditions fulfilled at same point). Thanks & Regards Santosh Kumar Subudhi -- Forwarded message -- From: santosh subudhi Date: Sun, Jul 8, 2012 at 9:43 PM Subject: RE: $$E

RE: $$Excel-Macros$$ Vlookup or Match formula - regionwise

2012-07-08 Thread santosh subudhi
Hi Sreejith, Since you are looking for a total sales on region wise the attached excel sheet may solve your problem. Regards Santosh santoshkumar.subu...@gmail.com -- From: koul.ash...@gmail.com Date: Sun, 8 Jul 2012 21:16:11 +0530 Subject: Re: $$Excel-Macros$$ Vlookup

Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise

2012-07-08 Thread ashish koul
whr is ART1 On Sun, Jul 8, 2012 at 9:28 PM, Sreejith K.V wrote: > Thanks ashish, > > But i am getting wrong results for EMP ID : ART1. > > Regards > Sreejith > > -- > From: koul.ash...@gmail.com > Date: Sun, 8 Jul 2012 21:16:11 +0530 > Subject: Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Vlookup or Match formula - regionwise

2012-07-08 Thread Sreejith K . V
Thanks ashish, But i am getting wrong results for EMP ID : ART1. RegardsSreejith From: koul.ash...@gmail.com Date: Sun, 8 Jul 2012 21:16:11 +0530 Subject: Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise To: excel-macros@googlegroups.com =SUMIFS(D:D,A:A,P2,B:B,Q2) On Sun, Jul 8, 201

Re: $$Excel-Macros$$ Working days per employee (macro)

2012-07-08 Thread Lokesh Loki
Hi Lalit, Superb solution, Thanks a lot lalit after a long time i get the solution without any clarification. Once again thanks a lot. And if i need any changes sure will sent a mail to you. Regards Lokesh.M On Sun, Jul 8, 2012 at 4:34 PM, ╰» ℓαℓιт мσαнη wrote: > Dear Lokesh, > > PFA the revis

Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise

2012-07-08 Thread ashish koul
=SUMIFS(D:D,A:A,P2,B:B,Q2) On Sun, Jul 8, 2012 at 8:55 PM, Sreejith K.V wrote: > Hi Team, > > Can someone please help me with the attached excel sheet. > > Regards > Sreejith > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thr

$$Excel-Macros$$ Vlookup or Match formula - regionwise

2012-07-08 Thread Sreejith K . V
Hi Team, Can someone please help me with the attached excel sheet. RegardsSreejith -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula P

Re: $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST

2012-07-08 Thread Pooja Sharma
On Sun, Jul 8, 2012 at 2:25 PM, Pooja Sharma wrote: > Hi Priti and Ashish! > > Thanks a lot for your Help. > > > -- > *Best Regards > Pooja Sharma* > * > * > ** > *Smile is a beautiful curve, which sets everything straight. So keep > smiling... :) * > > > > On Sat, Jul 7, 2012 at 7:10 PM, priti_ve

Re: $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST

2012-07-08 Thread Pooja Sharma
Hi Priti and Ashish! Thanks a lot for your. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * On Sat, Jul 7, 2012 at 7:10 PM, priti_verma wrote: > *Please see the attached file* > > * * > > *Good information on this sit