$$Excel-Macros$$ Job

From: Quetzal Verify Private Limited [mailto:j...@quetzal.in] Sent: Saturday, July 16, 2011 10:52 AM To: rajanverma1...@gmail.com Subject: Job Opening_Big4_Spreadsheet Analyst For Internal Use of Employer (Please don't delete or modify while replying to this email) Monster Resume

Re: $$Excel-Macros$$ Excel formula for Calculatin​g distinct events by ID

Have a look at the attached workbook. Daniel - Mail Original - De: RockyFontane vtorral...@gmail.com À: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Envoyé: Samedi 16 Juillet 2011 18h06:05 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne Objet: $$Excel-Macros$$

RE: $$Excel-Macros$$ Calculating distinct events by ID

Take the Log Contact in Column and data Field in Pivot Table From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vincent Torralbes Sent: Saturday, July 16, 2011 9:11 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Calculating distinct events

$$Excel-Macros$$ to find particular column and insert one column and perform Vlookup using vba

hi experts, Please help me in this concern. i need to perform vlookup function using VBA i have attached sample work book for referance From the attached workbook i need update summary sheet using the company code as base from SBU Mapping sheet. i need to insert one column after Data1 ,

$$Excel-Macros$$

Hi , Perfects I have one system (5400-FLC-01) in this system I am creating each new file name example (5400FLC-01-C001) (5400FLC-01-C002) When I create the new file should be update in the attached file with shade. Thanks! 5400FLC-01 1 2 3 4 5 Best

$$Excel-Macros$$ MS Access

Hi Smarts, Good day.. Could you send me googlegroup id for MS Access.. -- Thanks Siva -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ To Generate a Code

Dear Experts, Hope somebody could help me to solve the problem mentioned in the attached sheet. Thanks in advance. Regards, Kurikkal. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ MS Access

Hi Siva, You Can Post your MS Access Query's in this group it self... * * *Best Regards,* *Venkat* On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S sivnt...@gmail.comwrote: Hi Smarts, Good day.. Could you send me googlegroup id for MS Access.. -- Thanks Siva --

Re: $$Excel-Macros$$ Simple Code

Hi sharad, look attached..it may Help you... -- *Best Regards,* *Venkat* * * On Sun, Jul 17, 2011 at 5:22 PM, sharad jain jainshar...@gmail.com wrote: Hi Guys, Can someone please send me a simple code for round off to nearest 10? (No macro if possible.) For example, if I put 23 in A1,

Re: $$Excel-Macros$$ Simple Code

Use =ROUND(B12,-1) // (Suppose the number is in B12) Cheers Andy On Sun, Jul 17, 2011 at 5:22 PM, sharad jain jainshar...@gmail.com wrote: Hi Guys, Can someone please send me a simple code for round off to nearest 10? (No macro if possible.) For example, if I put 23 in A1, it should

Re: $$Excel-Macros$$ Macro needed: write cell reference to end of cell, for all cells

Anish Shrivastava wrote: Please have a look on the attached file. This might be helpful. I tried it only on one column since I dont know in how many columns you will have the data. If you could attach a sample sheet for your data, I can make it more feasible. Thanks, Anish, for your

Re: $$Excel-Macros$$ Simple Code

Dear Sharad, Use the following formula in B1. =IF(VALUE(RIGHT(A1,1))=5,FLOOR(A1,10),CEILING(A1,10)) Regards, Marieswaran. +971 55 9828492 On Sun, Jul 17, 2011 at 3:52 PM, sharad jain jainshar...@gmail.com wrote: Hi Guys, Can someone please send me a simple code for round off to nearest

Re: $$Excel-Macros$$ Simple Code

Dear Sharad, You can use MROUND function. =MROUND(23,10) On Sun, Jul 17, 2011 at 2:52 PM, sharad jain jainshar...@gmail.com wrote: Hi Guys, Can someone please send me a simple code for round off to nearest 10? (No macro if possible.) For example, if I put 23 in A1, it should result in 20

Re: $$Excel-Macros$$ To Generate a Code

Hi Kurikkal find attach Thanks Mahesh On Sun, Jul 17, 2011 at 4:59 PM, kurikkal padinjarappalla padinjarappa...@gmail.com wrote: Dear Experts, Hope somebody could help me to solve the problem mentioned in the attached sheet. Thanks in advance. Regards, Kurikkal. --

Re: $$Excel-Macros$$ To Generate a Code

Dear Mahesh, Thanks a lot for your immediate reply. It is almost what I am looking for,but can we create the code on alphabatical basis like the first client name starting with alphabet 'F' the code should be like DMF001 and for the second client name starting with same alphabet, code should be

Re: $$Excel-Macros$$ MS Access

Thanks Venkat On Sun, Jul 17, 2011 at 7:28 PM, Venkatesan c venkat1@gmail.com wrote: Hi Siva, You Can Post your MS Access Query's in this group it self... * * *Best Regards,* *Venkat* On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S sivnt...@gmail.comwrote: Hi Smarts, Good

Re: $$Excel-Macros$$ Simple Code

Dear Sir, You pl use the formula =ROUND(A1,-1) On Sun, Jul 17, 2011 at 5:22 PM, sharad jain jainshar...@gmail.com wrote: Hi Guys, Can someone please send me a simple code for round off to nearest 10? (No macro if possible.) For example, if I put 23 in A1, it should result in 20 in B1