$$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<

Hello Ayush, Thank you very much for the macro which worked exactly as expected. The only problem was that I already had entries filled up, for which I used your macro as a separate module and it solved the issue. Although not related to this question - I am going to send this file to my managers

Re: $$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<

Hi Abhishek, Jai Jinendra ! You are most welcome ! Attached is the updated solution. Please see the file and let me know if this is the desired solution. I have added data validation in column E. Best regards, Ayush Jain [Group Manager & Owner] --- On Sun, 15/11/09, Abhishek Jain wrote: Fro

$$Excel-Macros$$ excel certificate course

Hi all, I am from chennai.If any body knows about online excel certificate course.Pls let me know. txs karthik -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins dow

$$Excel-Macros$$ lenghty IF formula

I need to use the IF 53 times ! I have 53 rows which I am using filter and Subtotal (row70) I need to get one of the columns "C" to enter its text (names) into the subtotal row 70. However I can only use the brackets up to 9 times ( I think) can does anyone know how to reduce the formula size.

Re: $$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<

Hello Ayush, This is exactly what I wanted. Thank you very much. Jai Jinendra ! Abhishek Jain On Sun, Nov 15, 2009 at 4:25 PM, Ayush Jain wrote: > Hi Abhishek, > > Jai Jinendra ! You are most welcome ! > > Attached is the updated solution. Please see the file and let me know if > this is t

Re: $$Excel-Macros$$ lenghty IF formula

Dear Johnny, First you should try to identify important factors or key locators in your data and they you can try SUMPRODUCT formula or some other array functionality to achieve the desired result. For better explanation, attach a sample spreadsheet. Best Regards, -- DILIP KUMAR PANDEY MBA-H

Re: $$Excel-Macros$$ Flagging duplicate values with Countif and Search functions re partial matches

Dear Dan, I have tried to build up the data as mentioned by you and able to get the desired result. Same spreadsheet is attached herewith for your review. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 1

Re: $$Excel-Macros$$ excel certificate course

i took exams at brainbench.com. This is good. Regards, Sarfaraz Ahmed Microsoft Excel and VBA help On Sun, Nov 15, 2009 at 4:40 PM, karthikeyan wrote: > Hi all, > > I am from chennai.If any body knows about online excel certificate > course.Pls let me know. >

Re: $$Excel-Macros$$ Patron List

Dear Tommy, One thing you can do here is to use key combination CTRL + Down Arrow to go to the last record of the column and then use CTRL + SHIFT + HOME to select the data - Note this will select the data only till freeze line and by this way you can skip the data which are lying above from the f

RE: $$Excel-Macros$$ lenghty IF formula

Hi, Try using this formula instead: =INDIRECT("C"&A70) Regards - Dave. > Date: Sun, 15 Nov 2009 03:39:46 -0800 > Subject: $$Excel-Macros$$ lenghty IF formula > From: intermediatec...@googlemail.com > To: excel-macros@googlegroups.com > > I need to use the IF 53 times ! I have 53 rows whic

Re: $$Excel-Macros$$ lenghty IF formula

Hi, got the answer I am using either of these, but the shorter one works just the same. Thanks for your reply. Johnnyboy ROW 70 in the MAIN sheet =IF(AND(A70>=3,A70<=53),INDIRECT ("C"&A70)) ROW 70 in the MAIN sheet =INDIRECT("c" & A70) On 15 Nov, 12:37, Dilip Pandey wrot

Re: $$Excel-Macros$$ Re: text and date in one cell

Hi Dilip, Thanks a lot, You are a genius Thanks Prashanth On Sat, Nov 14, 2009 at 10:38 PM, Dilip Pandey wrote: > Hi Prashanth, > > You can use following formula to get the desired output. > =C3&TEXT(D3," MMM-YY") > > Solved workbook is also attached. > Let me know if solves your query > > Best

$$Excel-Macros$$ Re: Problem.Pls help

There is no explanation in your worksheet! -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.

$$Excel-Macros$$ Re: PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file

Hello, I think i did some effort to solve your problem take a look at this post : http://groups.google.com/group/excel-macros/browse_thread/thread/29083fc9f3da2cdc Hope this helps you -- -- Some important links for

Re: $$Excel-Macros$$ procdure to limit the printing to fix number of times

how about a custom doc property, something like "times printed"? is there an event at print to update such a property, and set it to the next count? then maybe we can use that event to not allow printing when this custom prop. reaches your limit. On Thu, Nov 12, 2009 at 1:05 PM, Hemant Hegde wrot

Re: $$Excel-Macros$$ hi

Your being troubled by "array functions". those curly brackets cannot be entered manually. On Fri, Nov 13, 2009 at 3:45 AM, Shraddha Shah wrote: > Hi, > > > > We are using the attached file to prepare certain reports for the bank. > > > > We need to actually bucket the all the deposits as per th

Re: $$Excel-Macros$$ Re: text and date in one cell

You are always welcome..!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Nov 15, 2009 at 9:09 PM, Prashanth Banneni wrote: > Hi Dilip, > > Thanks a lot, You are a genius > Thanks > P

Re: $$Excel-Macros$$ Fwd:Urgent. I have a Problem.Pls help

Dear Hemant There is nothing written in the attached sheet. Please resend Regards, Andy On Mon, Nov 16, 2009 at 12:55 AM, hemant shah wrote: > Hi Mr-excel, > > Pls help me on my query. Have a look at attached sheet > > > -- Forwarded message -- > From: hemant shah > Date: Thu, N

$$Excel-Macros$$ Re: excel certificate course

Dear Karthikeyan There are numerous online institute providing the online teaching and conduct certificate examinations. I am sending u the one link for that. They must charge u in dollar somewhere near about $50. http://www.technologyed.com/teach.php Thanks Regards Shashi Ranjan On