Re: $$Excel-Macros$$ Need support

VLOOKUPNTH is user defined function? On 01-Dec-2016 11:35 AM, "Murali Nagarajan" wrote: > > Dear team, > > Below mentioned formula is not working properly.how to use the formula > =VLOOKUPNTH($E2,$A$2:$C$209,3,10) > Note: File has been attached > > regards > > N.Murali > >

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats Noorian... -- *Best Regards,* *Venkat * *Chennai* On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Once again, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Aug'12. He has posted 111 posts in August 2012 and

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Congrats Noorain. -- *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many

$$Excel-Macros$$ Zip Files in Folder with password

Dear All, I want to Compress all the files(.zip) to the specified folders with the password..Where i will have a passwords towards that file names.. have attached sample Password list.. I need a VBA Code... -- *Best Regards,* *Venkat * * * * * * * -- FORUM RULES (986+ members already

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Congrats..Ashish Dilip *Best Regards,* *Venkat * *Chennai* On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest

Re: $$Excel-Macros$$ Need Formula !!

Hi Iqbal, Try this *=IF(E2=Qualify,-,C2-D2)* -- *Best Regards,* *Venkat * *Chennai* On Wed, Jun 27, 2012 at 6:46 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Dear Exports, Please find attached a file and help for formula as per required. Regards, Iqbal Shaikh -- -- FORUM

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Dear Noorain, Superb *Best Regards,* *Venkat * *Chennai* 2012/3/23 NOORAIN ANSARI noorain.ans...@gmail.com जहाँ Excel के दीवानों की, है बहूत घनी आबादी. जहाँ Question,Answer करने की,है खूब आज़ादी. जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. दोस्तों

Re: $$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

Hi , See below link.. http://www.pcreview.co.uk/forums/re-search-html-access-vba-t3992723.html *Best Regards,* *Venkat * *Chennai* * * On Thu, Mar 22, 2012 at 12:13 AM, Raj Mahapatra rajafs...@gmail.com wrote: hi all i am looking for some vba codes which will search html files (bases file

Re: $$Excel-Macros$$ Pivot Table

Hi Karan, Try to download *Excel 2007 PivotTables Recipes.pdf * book by 2007 by Debra Dalgleish Or you can search in youtube for Video's tutorial.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Tue, Mar 20, 2012 at 2:59 PM,

Re: $$Excel-Macros$$ lotus notes email

Hi Prabhat, Try Below links.. http://www.mrexcel.com/forum/showthread.php?t=62381 http://www.ozgrid.com/forum/showthread.php?t=36812 *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Tue, Mar 20, 2012 at 4:17 PM,

Re: $$Excel-Macros$$ sms or text sms in excel.

Hi, Please have a look on below link.. http://www.tricksmachine.com/2009/07/send-sms-online-from-your-excel-sheet.html On Sat, Mar 17, 2012 at 12:56 PM, Deba Ranjan drdeva...@gmail.com wrote: * * Dear expert, I am looking out for sending text sms to numbers by the help of excel.

Re: $$Excel-Macros$$ XL 2010 to XL 2007 compatibility question

Hi Dave, Actually Excel 20072010 or more or less Samefile Format options..You dont need to install any Compatibility package and all ... You can just Save files as a *.XLSX,.XLSM.*..You will not fild any problems on this.. Also you can set default file save option as .XLSX . *Best Regards,*

Re: $$Excel-Macros$$ Exl at expert level

Hi Maries, Nice Collections... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sun, Mar 18, 2012 at 1:53 PM, Maries talk2mar...@gmail.com wrote: Hi, *Check below Weblinks.* *MVP's* *Web Link* Alan Beban

Re: $$Excel-Macros$$ Query (Remove duplicate)

Hi Karan, Try Advanced filter and select Unique records..And you can Copy and paste it in New Column.. [image: Inline image 1] *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh

Re: $$Excel-Macros$$ last copied item in windows clipboard

Hi Divakar, Copy data twice You will get Clipboard..You Can see Last Second Copied Data. [image: Inline image 1] *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Mar 19, 2012 at 5:23 PM, Divaker Pandey divake...@gmail.com

Re: $$Excel-Macros$$ copy paste in reverse order

Hi Amit, Try Transpose Option on Paste special..if Helps.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Hi, ** ** Is there any formula to

Re: $$Excel-Macros$$ Missing serial number

Hi Nilesh, Try this Below... *=IF(A3=A2+1,Ok,A2+1)* *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Mar 16, 2012 at 10:40 AM, Virkar,Nilesh nil...@lechlerindia.comwrote: Dear All, ** ** I need to find out the

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats Noorain:) On 3/15/12, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Feb'12 He has posted 156 posts in Feb'12 and helped many people through his expertise. He has been consistent contributor to

Re: $$Excel-Macros$$ date format

Hi , Try This, *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee lee.sar...@gmail.com wrote: i have date in this format-- 20011012... yrmmdd..

Re: $$Excel-Macros$$ Difference between VBA and VSTO

Hi Hanumanth, Look Below Link http://netindonesia.net/blogs/andriyadi/archive/2008/08/20/vba-vs-vsto.aspx *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde

Re: $$Excel-Macros$$ Need help

Dear Sriram, Look attached...as required... On Thu, Feb 2, 2012 at 6:38 PM, sriram ji sriramg...@gmail.com wrote: Dear Excel Guru, Kindly provide the solution for the attached file. Thanks Regards, Sriram G Chennai -- FORUM RULES (986+ members already BANNED for violation) 1)

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

Hi Sanjib, Look Attached... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Experts, Please See the attachment and Help me regarding

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats... Noorain Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member'

Re: $$Excel-Macros$$ plz, check the attachment it clearly tells u what I need in actually.

Hi Muneer, Can u Explain some more about query... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sat, Feb 4, 2012 at 10:59 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: ** Regards, Muneer, CC... -- FORUM RULES (986+

Re: $$Excel-Macros$$ help

Hi Vijay, Look Below about relative refrence.. *What are the types of references?*1. Absolute Column/Absolute Rowe.g. $A$1means Whether you use auto-fill across column or across row, the reference won't be changed. 2. Absolute Column/Relative Rowe.g. $A1means When you use auto-fill across

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congrats...Rajan All... -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Wed, Jan 4, 2012 at 11:29 PM, Ayush Jain jainayus...@gmail.com wrote: Sam, Welcome back to the group. We missed you. Noorain, I liked the poetic

$$Excel-Macros$$ Fwd: Job

-- Original message -- From:Hewlett-Packard India Pvt Ltd ghulam-mohammed.huss...@hp.com Date: 21 Nov 11 16:12:45 Subject: Openings @ Hewlett Packard (HP) for SQL DBA- CHENNAI LOCATION To: The sender of this email is registered with Naukri.com as Hewlett-Packard India Pvt Ltd

$$Excel-Macros$$ Opening for MIS

-- Original message -- From:Absolute HR Solutions Pvt. Ltd. praja...@absolutehrs.com Date: 21 Nov 11 11:01:35 Subject: Opening for MIS - VBA/SQL To: The sender of this email is registered with Naukri.com as Absolute HR Solutions Pvt. Ltd. *Experience required for the Job:* 2 - 7

Re: $$Excel-Macros$$ converting excel file into xml file

Hi Vijay, Try File Save as a .XML *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Nov 18, 2011 at 9:53 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Gurus, Is there any method to convert Excel file into XML format.In

Re: $$Excel-Macros$$ Deleting modules

Hi Chandra Sekar, Right Click on Module and Remove module and Click option No,, *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Nov 18, 2011 at 4:23 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, Could you

Re: $$Excel-Macros$$ Indirect formula

Hi Sumitha, Please See below links for Indirect Function More Clarification... http://www.contextures.com/xlFunctions05.html http://www.cpearson.com/excel/indirect.htm *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Tue, Nov

Re: $$Excel-Macros$$ Paste Special VS Paste Special

Hi Hanumant, First one you have copied data from Some other Application(New Window workbook,World..Etc) window and 2nd one Copied from Same window same sheet's That's what it's Showing different Options... *Best Regards,* *Venkat * *Chennai* *My Linked in profile

Re: $$Excel-Macros$$ Kindly Help

Hi Vijay, See attached if helps... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Thu, Nov 17, 2011 at 2:24 PM, vijayKumar midearfam...@gmail.com wrote: Dear Friends, Request you to help me on a Query of Open Office Excel.

Re: $$Excel-Macros$$ How to learn vba

Hi, Refer Below Links.. http://www.cpearson.com/Excel/MainPage.aspx http://www.teachexcel.com/ http://www.ozgrid.com/VBA/ http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

Dear Ayush, Congrats *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Group, Our Group Manager Mr. Ayush Jain has been awarded the Microsoft

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Hi Noorain, Congrats *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the

$$Excel-Macros$$ Fwd: Job

- Original message From:S Suvarna ssuva...@magna.in Date: 12 Sep 11 13:12:37 Subject: Urgent Oening for SQL Server Developer at Chennai based Client To: S Suvarna Hi, Greetings for the day!!! Let me take this opportunity to introduce Magna Infotech Pvt. Ltd. We are one ofthe

$$Excel-Macros$$ Re: Walk in For Finance Professionals on September 13th and 14thTuesday and Wednesday@ Scope International Haddows Road

- Original message From:Scope International Pvt Ltd ramya.rampra...@sc.com Date: 12 Sep 11 16:01:05 Subject: Walk in For Finance Professionals on September 13th and 14thTuesday and Wednesday@ Scope International Haddows Road To: The sender of this email is registered

Re: $$Excel-Macros$$ calculating age with months

, Sep 9, 2011 at 10:39 AM, Venkat CV venkat1@gmail.com wrote: Hi Varun, See if Helps Attached... *Best Regards,* *Venkat * *Chennai* *My Linked in profilehttp://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote

$$Excel-Macros$$ Fwd:Job Process Developer

- Original message From:HR Axis India Pvt Ltd. quali...@hraxisindia.com Date: 9 Sep 11 18:01:48 Subject: A Leading MNC Captive BPO Company is looking for Process Developer (Billing Collections - US Healthcare) for Hyderabad Location. To: The sender of this email is registered

$$Excel-Macros$$ Fwd: Job MIS Executive at Chennai

- Original message From:Source One Management Services Pvt.Ltd vik...@msourceone.com Date: 10 Sep 11 12:29:14 Subject: Hi, Urgent Opening for MIS Executive at Chennai :Contract to Hire To: The sender of this email is registered with Naukri.com as Source One Management Services

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

*Hi,* * * *Please attach some Data in Excel...* * * *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa zakk.co...@gmail.com wrote: Hi all, I'm trying to build an Excel solution that would do

Re: $$Excel-Macros$$ Re: Report Generation

Hi , See Below links if Helps... http://databases.about.com/od/tutorials/l/aareports1.htm http://office.microsoft.com/en-us/access-help/create-a-simple-report-HA001230739.aspx http://www.databasedev.co.uk/reports.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile

Re: $$Excel-Macros$$ Msg Box

Hi, Look Attached... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, I have a form which has a Close button and a Code assgined to it as below:

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

. I'm new to the group and couldn't find any option to attach files. Jose On Sep 9, 3:15 am, Venkat CV venkat1@gmail.com wrote: *Hi,* * * *Please attach some Data in Excel...* * * *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ How to recast a variant as an array in VBA

Hi, See below links.. http://www.mrexcel.com/forum/showthread.php?t=32187 http://www.ozgrid.com/forum/showthread.php?t=69235page=1 http://www.cpearson.com/excel/vbaarrays.htm *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Wed,

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

Hi , See Below Links... http://www.contextures.com/xlcondformat03.html\ http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Wed, Sep 7, 2011

Re: $$Excel-Macros$$ reference auto copy in shee2

Hi Sanjib, You Can try Advanced filter Option in 2007 *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Good Morning Everybody, I want to

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Hi Bheema, See below image and Try Data Validation and use custom and formula as * =COUNTIF(C:C,C1)=1* [image: image.png] *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar

Re: $$Excel-Macros$$ Crystal Reports for vba excel

Hi , See below links if Helps http://forums.esri.com/Thread.asp?c=93f=992t=67019 http://www.codeguru.com/forum/showthread.php?t=356836 *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Fri, Sep 9, 2011 at 10:42 AM, Shankar

Re: $$Excel-Macros$$ Re: Hi

Hi Mudit, See Below Links http://www.excel-vba.com/ http://www.ozgrid.com/VBA/ http://www.exceltip.com/book-1931841047.html http://www.cpearson.com/excel/Downloads.aspx http://www.contextures.com/tiptech.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile

$$Excel-Macros$$ Fwd: mis executive, chennai, CONTRACT 2 HIRE

- Original message From:Source One Management Services Pvt.Ltd farhee...@msourceone.com Date: 5 Sep 11 12:33:34 Subject: mis executive, chennai, CONTRACT 2 HIRE To: The sender of this email is registered with Naukri.com as Source One Management Services Pvt.Ltd Dear Candidate,Hi

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Congratulations Rajan Verma , Sunny, Noorain, Don Guillett, and Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has

Re: $$Excel-Macros$$

Hello Haeruddin, Please send your Query.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sat, Sep 3, 2011 at 3:53 AM, Udin Haeruddin herumam...@gmail.com wrote: -- == Haeruddin, S.Pd == --

Re: $$Excel-Macros$$ Re: Query

Dear Shasi, You are Welcome... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan shashi2...@gmail.com wrote: Dear Venkat Noorain Sir I am very thankful to you for sharing your precipus

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, Try SUMPRODUCT... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Sep 2, 2011 at 5:02 PM, Haytham Zoromba haythamzoro...@gmail.comwrote: Dear all, I have tried to search about using vlookup with more than

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, See sample...If Helps.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Sep 2, 2011 at 7:07 PM, Venkat CV venkat1@gmail.com wrote: Dear Haytham, Try SUMPRODUCT... *Best Regards,* *Venkat

Re: $$Excel-Macros$$ write and read cookies through vba.

Hi , Look Below links... http://www.java2s.com/Code/ASP/Session-Cookie/WriteCookieandreadCookieVBnet.htm http://www.bigresource.com/VB-Read-Cookie-in-VBA-from-Word-QVYNPHx6U0.html -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

Re: $$Excel-Macros$$ extracting data from a datasheet

Hi Please attach sample data *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar shankar.n...@gmail.comwrote: I made an userform with Empno, Name, Design, DOB textboxes with the save

Re: $$Excel-Macros$$ stock on hand report generate

Hi Jasmin, Share some sample data... *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:27 PM, jasmin snband...@gmail.com wrote: Hi all experts i have a small store which contains 300 products( MEDICINES).in a quarter i reviced the items once or twice.But i issue items to

Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003

@googlegroups.com] *On Behalf Of *Venkat CV *Sent:* Wednesday, August 31, 2011 7:33 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 ** ** Hi Amit ** ** See below link for Sumifs in 2003 http://chandoo.org/forums

$$Excel-Macros$$ job

-- Original message -- From:Teamware Solutions (quantum leap consulting) sw...@twsol.com Date: 30 Aug 11 12:43:07 Subject: Urgent Requirment for MS SQL server 2005/2008Developers for TCS, Kochi To: The sender of this email is registered with Naukri.com as Teamware Solutions

Re: $$Excel-Macros$$ Guru's Pls reply me

Hi Kannan, Look attached used formulas... =COUNTIFS(Sheet1!$B:$B,Sheet3!$A2,Sheet1!$E:$E,Sheet3!H$1) *Best Regards,* *Venkat * *Chennai* * * On Wed, Aug 31, 2011 at 11:02 AM, kannan excel kannan.ex...@gmail.comwrote: Sorry guys. I don't want pivot table. i want like that any macro or

Re: $$Excel-Macros$$ Conditional Formatting and Logical Operators

Hi, See below links if helps.. http://www.cpearson.com/excel/cformatting.htm http://www.excelforum.com/excel-general/497309-can-logical-operators-be-used-within-conditional-formatting.html *Best Regards,* *Venkat * *Chennai* * * On Wed, Aug 31, 2011 at 11:36 AM, zp18 irvinep...@gmail.com

Re: $$Excel-Macros$$ Super Urgent - Thinking beyond

Hi Karan, Go to Hyperlink and try Exiting file or webpage option and selcect the word document.. [image: image.png] *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Wed, Aug 31, 2011 at 4:24 PM, karan 1237 karan1...@gmail.com

Re: $$Excel-Macros$$ Book2.xlsx

Hi Sudhir, Try this *=SUMPRODUCT((B3:B7=F5)*(A3:A7=G5)*(C3:C7))* *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote: Dear All ** ** Please suggest

Re: $$Excel-Macros$$ Book2.xlsx

Hi Sudhir, For sumproduct we must have 2 fixed data criteria..in this scenario we cant use SUMPRODUCT *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Thu, Sep 1, 2011 at 5:46 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote:

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Prabhu, Send send some sample data with pivot... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Wed, Aug 31, 2011 at 12:28 PM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, When i double click my Pivot table value a

$$Excel-Macros$$ Fwd:Job

- Original message From:Teamware Solutions (quantum leap consulting) sw...@twsol.com Date: 30 Aug 11 12:43:07 Subject: Urgent Requirment for MS SQL server 2005/2008Developers for TCS, Kochi To: venkatesa...@in.com The sender of this email is registered with Naukri.com as

$$Excel-Macros$$ Fwd: Opening for SQl Developer in Chennai with Ramco Systems

- Original message From:Magna Infotech Pvt Ltd car...@magna.in Date: 30 Aug 11 12:28:42 Subject: Opening for SQl Developer in Chennai with Ramco Systems To: The sender of this email is registered with Naukri.com as Magna Infotech Pvt Ltd Experience required for the Job: 3 - 7

Re: $$Excel-Macros$$ xls to Pdf in VBA error

Hi Noorian, How it will automatically save PDF Format in 2003 Version...is it available.. -- *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sajid, Please change blue color path as per your system.. This code is

Re: $$Excel-Macros$$ User form

Hi Prasad, Look attached below... If you want to create some VBA Coding in background of userforms..You have to save the file has a .XLS or XLSM because XLSX wont support Macro Language.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad

Re: $$Excel-Macros$$ User form

Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug

Re: $$Excel-Macros$$ help

Hi vijay, Please send some sample data...for your requirement.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, i have four words and i need to combine using trim and proper functions. Please can you provide me

Fwd: $$Excel-Macros$$ User form

Hi Surya, Your excel sheet is empty..Please check..and resend it back...and please Elaborate more about your query. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the

Re: $$Excel-Macros$$ any short key to remove double add.

Hi Kannan, In Excel 2007(or)2010 version Having Advanced filter option you can get a unique records by using *Filter the list-List range-Criteria range-Unique Records only * * * *This Option will be used for removing duplicates and unique records viewing Purpuse..* *Best Regards,* *Venkat *

Re: $$Excel-Macros$$ User form

is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM

Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003

Hi Amit See below link for Sumifs in 2003 http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 -- *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear All, ** ** Do we have any option for countifs

Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product

Hi john, Try the Below... =SUMIF($B$2:$B$8,B2,$D$2:$D$8) *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith johnasmit...@gmail.comwrote: Your help please. I have a log of product sold and need to calculate the different product sold to date, like a

Re: $$Excel-Macros$$ Macro to remove repeats and merge

Hi, You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T *Best Regards,* *Venkat * *Chennai* On Wed, Aug 31, 2011 at 2:44 AM, Gaetan M gaetan.me...@wanadoo.fr wrote: I have the following: Column A B C D E F 12722

Re: $$Excel-Macros$$ Attach file for discussion

Hi, In your G mail Just click Compose Mail and attach and write your query and send it to *excel-macros@googlegroups.com* *Best Regards,* *Venkat * *Chennai* On Wed, Aug 31, 2011 at 2:47 AM, Tripp ken...@gmxresources.com wrote: How can I attach a spreadsheet for review? --

Re: $$Excel-Macros$$ Decimal greater than 0.5

Hi, try Round formula Example Below =ROUND(A1,0) *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:54 PM, Skanda skanda.pokkun...@gmail.com wrote: Hi All, How to convert the numbers in a column based on following: example: 13.45 should be displayed as 13 13.5 or

$$Excel-Macros$$ Re: Openings for SQL DBA

- Original message From:Tritium sw...@tritiumindia.com Date: 27 Aug 11 10:47:20 Subject: Openings for SQL DBA To: venkatesa...@in.com The sender of this email is registered with Naukri.com as Tritium Experience required for the Job: 4 - 8 yearsAnnual Salary of the Job:

Re: $$Excel-Macros$$ 2003 excel to pdf

Hi Sajid, Just Upload in this website..and you will get as a PDF http://www.pdftoexcelonline.com/ Install Below application and try Print Option.. http://www.bullzip.com/products/pdf/info.php *Best Regards,* *Venkat * *Chennai* On Sat, Aug 27, 2011 at 1:54 PM, SAJID MEMON

Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME

Hi Kannan, You are Welcome... *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 27, 2011 at 5:51 PM, kannan excel kannan.ex...@gmail.comwrote: Thanks Guru. i am really happy. Regards Kannan V Aircel Limited. Chennai On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV venkat1@gmail.com

Re: $$Excel-Macros$$ Some Sorting Technique

Hi Rajan, It's Superb... *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Group, Refer the attached sheet with some Data Sorting Example. Hope you will like it ** ** Rajan. ** ** --

Re: $$Excel-Macros$$ xls to Pdf in VBA

Hi Sajid, Just install the below PDF Printer Driver and use code for Printing... http://www.bullzip.com/products/pdf/info.php *Best Regards,* *Venkat * *Chennai* On Sat, Aug 27, 2011 at 3:58 AM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear Experts, I want an active sheet with command

$$Excel-Macros$$ Job

-- Original message -- From:Source One Management Services Pvt.Ltd indira...@msourceone.com Date: 25 Aug 11 17:44:45 Subject: Urgent Requirement with Top MNC For : :Reporting Architecture To: The sender of this email is registered with Naukri.com as Source One Management

Re: $$Excel-Macros$$ Fill empty cells with zero

Try Find and replace Option. *Best Regards,* *Venkat * *Chennai* On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain ushadhvin...@gmail.comwrote: We have some blank cells in excel (2007), which we want to fill with zero. what is the formula for the same? With regards, Usha --

Re: $$Excel-Macros$$ Text to Numbers

Hi, It's in Text only just Copy and paste and change Format cells as a Number... *Best Regards,* *Venkat * *Chennai* On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** I have recd the following data in email body itself wants to

$$Excel-Macros$$ Job:Senior Database Analyst

http://jobsearch.naukri.com/mynaukri/mn_newsmartsearch.php?xz=8_0_4qc=96679id=Senior Database AnalystPride Technologies ** ** *New User? Register Now*http://naukri.com/tieups/tieups.php?othersrcp=11497 Summary *Experience:* 2 - 6 Years *Location:* Chennai *Compensation:* Rupees 2,00,000

Re: $$Excel-Macros$$ Hi

Hi, See below links.. http://www.excel-vba.com/ http://www.ozgrid.com/VBA/ http://excelvbatutor.com/ *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 26, 2011 at 8:54 PM, Mohamed Youssouf youssouf.mohame...@gmail.com wrote: I'd like to learn how ti use MACRO --

Fwd: $$Excel-Macros$$ how to change a pdf file in to excel

Hi All, PFA... http://www.pdftoexcelonline.com/ -- Forwarded message -- From: Venkat CV venkat1@gmail.com Date: Sat, Aug 20, 2011 at 3:33 PM Subject: Re: $$Excel-Macros$$ how to change a pdf file in to excel To: excel-macros@googlegroups.com Hi Anil, Check the website

Fwd: $$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

know if u have any queries. Thanks. Regards Ayush Jain Group Manager 2011/8/20 Venkat CV You are welcome *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn betnmtdongna...@gmail.comwrote: Thank venkat1@gmail.com has provided me

$$Excel-Macros$$ Fwd:Job

- Original message From:Benvia software (India) Pvt. Ltd sravanthi.ko...@benvia.com Date: 22 Aug 11 16:02:21 Subject: Immediate RequirementofMS ACCESS and Excel Database Programmer for Chennai Mumbai location To: The sender of this email is registered with Naukri.com as Benvia

$$Excel-Macros$$ Fwd:Job

-- Original message -- From:Metriqe Solutions care...@metriqe.com Date: 22 Aug 11 21:33:06 Subject: Openings for Data Analyst in Metriqe Solutions (MNC) To: Cc: care...@metriqe.com Dear Candidate, Greetings from Metriqe Solutions Pvt Ltd (MNC)!! *Metriqe Solutions is a

Re: $$Excel-Macros$$ how to change a pdf file in to excel

Hi Anil, Check the website.. http://www.pdftoexcelonline.com/ *Best Regards,* *Venkat * *Chennai* On Sat, Aug 20, 2011 at 2:52 PM, anil kumar kmr7a...@gmail.com wrote: plz anybody tell me that how to change a pdf file in to excel for modifiy. --

$$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

You are welcome *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn betnmtdongna...@gmail.comwrote: Thank venkat1@gmail.com has provided me the software conversion from PDF to Excel, very useful information. Thank you very much. -- * * * * --

Re: $$Excel-Macros$$ difference time calculation

Great Noorain, *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 19, 2011 at 2:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Jayendra, Please use below formula see attached sheet.. =TEXT((C2+D2)-(A2+B2),[H]:mm:ss) -- Thanks regards, Noorain Ansari

Re: $$Excel-Macros$$ Export of Personal Macro Book

*Hi Amit,* * * *See the below path* * * *C:\Documents and Settings\vcc7328\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB* * * *Login ID:vcc7328* * * *For 2007 2010...* *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI

  1   2   >