$$Excel-Macros$$ Label Format for 40

Hi All, Please share format for label 40 pics -- Thanks & Regards Anil Kumar -- 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 1) Use

Re: $$Excel-Macros$$ formula required for count or count if

lee.sar...@gmail.com thee are two similar rows with same load no---this is not working On Fri, Apr 27, 2012 at 4:06 AM, anil panchal anil.kan...@gmail.comwrote: you can use =SUMPRODUCT(--($A$2:$A$23=AB2)) On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee lee.sar...@gmail.com wrote: yes i

Re: $$Excel-Macros$$ Disable Ctrl+D

Hi Please Use alt + ctrl + L then Ctrl D On Tue, Apr 17, 2012 at 3:07 PM, muralidhar e emuralidha...@gmail.comwrote: hi dear group members, Good afternoon Iam using excel-2007 2010, with a huge data, with this when iam suppose to use Ctrl+F for find the batches by overlook when iam

Re: $$Excel-Macros$$ Time Calcuation

TEXT(B5+C5,[h]:mm:ss) On Mon, Apr 16, 2012 at 12:00 PM, Deba Ranjan drdeva...@gmail.com wrote: *Hi Experts, Please see the attached File. There i am getting error in time calculation. please do the needful. Thanks in advance. * Thanks Regards,* * *Deba * -- FORUM RULES (986+

Re: $$Excel-Macros$$ Re: Quarter Classification

Dear All, Why Use *29??? =TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,) Thanks Regards Anil Kumar 113784 On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A haseeb.avarak...@gmail.comwrote: Nikhil, One way: Assume date is in A2. So In B2 for the Curr Quarter.

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear Darwin, Please find the attached file. {I am not understant exact wt you want in from time please revert me with sample like count or sum total working hours ) Thanks Regards Anil Kumar 113784 On Tue, Apr 3, 2012 at 4:32 PM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear

$$Excel-Macros$$ please help

Hi, Please help me how to show percentage in bar chart like value -- Thanks Regards Anil Kumar -- 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,

Re: $$Excel-Macros$$ Happy Birth Day

Hi, Noorain Sir a very Very Happy Birht Day. Thanks Regards Anil Kumar 113784 On Mon, Jan 2, 2012 at 8:25 PM, Maries talk2mar...@gmail.com wrote: Wish you many many Happy Returns of the Day Noorain:) Enjoy :) On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

$$Excel-Macros$$ Please help

Dear Experts, Please find the attached file . my questions is i have alphabets Numbers both in one cell now i want only count numbers like 123#n/aabcd345677 now i want 9 Thanks Regards Anil Kumar 113784 --

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hi Hari, Please find the attached file. Thanks Regards Anil Kumar 113784 On Sun, Jun 19, 2011 at 10:33 PM, HARI NAIR hari.shrin...@gmail.com wrote: I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP THANKS IN ADVANCE.. HARI --

$$Excel-Macros$$ Please help in P Table.

Dear All, my Question is we can use use two header in p. Table.? -- Thanks Regards Anil Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Looking for VBA Training

Hi Experts, I am also Required your advise on VBA training, I am looking for VBA best training in East Delhi any body have any good training institute please provide me the address or phone no. to contact. Thanks Anil Kumar 113784 On Wed, Feb 2, 2011 at 4:57 PM, Puttu *

Re: $$Excel-Macros$$ Ashish Koul : Most helpful member : Jan11

Congrats ashish. On Thu, Feb 3, 2011 at 1:19 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: Congrats ashish. He is really wonder boy. i have seen his many posts and his knowledge is damn good. happy to meet u here Ashish your code has taught me a lot. :)

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

Hi Dilip Sir, Congratulations to you Thanks Regards Anil Kumar 113784 On Tue, Jan 4, 2011 at 10:05 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Congratts dilip On Tue, Jan 4, 2011 at 12:34 AM, Vinod N nvino...@gmail.com wrote:

Re: $$Excel-Macros$$ Please help on the formula

Hi Noorain, Here we use only vlookup i am worng or right, On Fri, Dec 24, 2010 at 5:00 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Poojari, Please see attachments.. Thanks, Noorain Ansari On Fri, Dec 24, 2010 at 12:24 AM, poojari sreevijay psreevi...@gmail.com wrote:

Re: $$Excel-Macros$$ Query

Dear Nikhil, Please find the attached file. There is duplicate name if name is Unique ?? On Thu, Dec 2, 2010 at 5:20 PM, Daniel dcolarde...@free.fr wrote: Is it possible that the names list were sorted ? Then you may use :

$$Excel-Macros$$ issue with Data validation

Dear All, Please help me on Data Vadidation :-) I have issue in multi validation I want in first cell A1 Anil B1 I want list of anil like 5 name second is A2 Sunil B2 list 4 names. Thanks Regards Anil Kumar http://www.bandoo12.com/wp/ie.php?plg=iesubs=gmailelm=sign --

Re: $$Excel-Macros$$ : How to reduce the Excel File size

Hi You have to Delete all un used coloumn and un used row Affter that u can Create CSV File On Thu, Nov 25, 2010 at 3:20 PM, in.vaib...@gmail.com wrote: Hi You have to clean up all your sheets. i.e. Re-Set excel last cells by deleting un used cells. Delete all un used coloumn and un used

Re: $$Excel-Macros$$ Need Solution

Hi Mohamed Idhrees. S. , Please find the attached file. On Tue, Sep 7, 2010 at 12:49 AM, Idhrees Mohamed idhrees...@gmail.comwrote: Dear Guys I have two column, job no value. In this i need particular job no with the total value in serial wise. Can anybody help me. (I attach sample file).

Re: $$Excel-Macros$$ Pivot table problem Pls help me

Hi Venkatesh, Please right click on Pivot Table Cilcik On Pivot Table Options Then Cilck on display Cick On Classic Pivot Table layout Ok Thanks Regards Anil Kumar On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla nvenki...@gmail.comwrote: Dear All, I have problem in 2007 Excel Pivot

Re: $$Excel-Macros$$ plz help me its urgent

On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Sir, plz help me and Show the Formula -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

Re: $$Excel-Macros$$ Fwd: Hi Please Help ME

range on the basis of your criteria (SB/GB) but of what range ? Please elaborate what exactly you want. Krgrds, AJ On Mon, Mar 22, 2010 at 4:17 PM, anil panchal anil.kan...@gmail.comwrote: -- Forwarded message -- From: anil panchal anil.kan...@gmail.com Date: Mon, Mar

$$Excel-Macros$$ Hi Please Help ME

Hi All A NB MTRL NB Width Extra NB Height Extra A NB MTRL Extra CNB Width CNB Height A CNB MTRL sum OF SB sum OF GB 0 0 0 0 0 0 48 72 24 SB 10.22 GB 0 0 0 0 72 20 10 SB 20.236111 GB 0 0 0 0 64 30 13.33 SB 23.291667 GB 0 0 0 0 130 35 31.597222 SB 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Re: $$Excel-Macros$$ Re: pdf converter software code needed (able2extract)

Share With Exe File Please Regards Anil Kumar On Fri, Feb 26, 2010 at 12:02 PM, ankur ankurpande...@gmail.com wrote: ya sure this is the code 127418901528 Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On

$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP

Hi Amresh, Please find the attached file, Thanks Anil Kumar On Thu, Sep 3, 2009 at 2:30 PM, amresh kumar amreshkushw...@gmail.comwrote: Hi My All Friends, Please find the attached file i want count working days absent date and half day of employee Please let me know if any doubts.

$$Excel-Macros$$ There is one think Plz Repply Fast

Hi Frnd, suppose maine pivot table banaya sheet 2 me ab chahta hu ki pivot chart bhi bane sheet 2 me hi na ki sheet 3 me is it possible or not? Thanks Regards Anil Kumar 9278256426 --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Need help to remove the * from cell entire row

hi manoj i am new in useing excel On 7/8/09, Manoj S Negi manojsnegi.uttranc...@gmail.com wrote: Hi Friends, Please help meas my query is as follows... In the attached sheet in column there is some data and some cells are having * and I want to remove the * from the cells.

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

Hi All Can anyone send me a ppt or an overview abt macros i want to learn the basics of macros. Please help me Thanks Regards Anil Kumar Executive - Database SOLUTIONS DIGITAS 3rd Floor, Chandra Bhawan, 67-68, Nehru Place | New Delhi - 110019 | India Mobile: +(91) 9211851980 | Email:

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

this is correct On 5/15/09, JAYAVELU SUN jayavelu@gmail.com wrote: =COUNTIF(C8:C66,C8) this is correct formula jayavelu On 5/14/09, Kshitij k.dh...@gmail.com wrote: =COUNTIF(C8,C8:C66) --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Querry !

selcet column press shift+ctrl ) for hide unhide shift+ctrl ( On 5/5/09, shafiq online shafiq_onl...@hotmail.com wrote: Can anyone tell me how can I hide row and column heading?... I mean calumn names for example a.b.c.d in default and row names 1 2 3 etc. Regards