RE: $$Excel-Macros$$ How Offset function Works

2012-07-08 Thread Lalit Mohan
Hi Preeti, Hope this might helpful to you to understand how offset works. http://www.myonlinetraininghub.com/excel-offset-function-explained Regards, Lalit Mohan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent:

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 pritiverma1...@gmail.comwrote: *Please see the attached file* * * *Good

$$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

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, ╰» ℓαℓιт мσαнη mohan.pande...@gmail.comwrote: Dear

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,

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 itssre...@hotmail.com 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:

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$$

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 santoshkumar.subu...@gmail.com Date: Sun, Jul 8,

$$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

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 rajanverma1...@gmail.com *Hi Group,* * * *I am searching for PC Suit API, if anybody have any good link where I can

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