$$Excel-Macros$$ Re: Concatenate Formula

Dear Shyam, Below is the formula for your query *=CONCATENATE(A1&B1&""&TEXT(C1,"dd-mmm-yy"))* regards, siva On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi All, > > I have an issue while using concatenate formula, Can any one of you help me > out with this: > > Query: > > Colum

$$Excel-Macros$$ Re: Calculate total premium amount for a selected person.

Pls find the attachement,...   Using formula..     Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Thu, 10/23/08, Dave Bonallack <[EMAIL PROTECTED]> wrote: From: Dave Bonallack <[EMA

$$Excel-Macros$$ Re: Sorting a column

Thanks Dave Has worked a charm! I have formatted the cells that data shall be placed into (via macro) in advance, so should not be a problem in the future. Thank you kindly once again! On Oct 23, 5:28 pm, Dave Bonallack <[EMAIL PROTECTED]> wrote: > Hi, > Just formatting a cell as number after t

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

Dear Kamlesh, Formula is perfectly reading the text "comm". Please read again the note given in the sheet. Regards CA. Atul Singhal -Original Message- From: kamlesh jain [mailto:[EMAIL PROTECTED] Sent: October 23, 2008 6:24 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macr

$$Excel-Macros$$ Re: Concatenate Formula

Use this =CONCATENATE(D8," ",D9," ",TEXT(D10,"dd-mmm-yy")) where D8 = MS D9= Excel D10 = 24 - Oct - 08 u will get the answer. On Fri, Oct 24, 2008 at 7:04 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi All, > > I have an issue while using concatenate formula, Can any one of you help me >

$$Excel-Macros$$ Re: Concatenate Formula

hi shyam can u try this one =CONCATENATE(D12," ",D13," ",TEXT(D14,"dd-mmm-")) On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi All, > > I have an issue while using concatenate formula, Can any one of you help me > out with this: > > Query: > > Column A : MS > Column B : Exc

$$Excel-Macros$$ Re: Lookup for repetitive items

Dear Nishant Please let me know the solution also. rgds Mayank On Thu, Oct 23, 2008 at 11:51 PM, Nishant Jain <[EMAIL PROTECTED]>wrote: > > I have send you the solution on email. > > Nishant > > On Oct 23, 4:56 pm, "Nidhesh Dhawan" <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I need to apply lo

$$Excel-Macros$$ Re: Calculate total premium amount for a selected person.

Go through with this   Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Thu, 10/23/08, Dave Bonallack <[EMAIL PROTECTED]> wrote: From: Dave Bonallack <[EMAIL PROTECTED]> Subject: $$Excel-Macros$$ Re:

$$Excel-Macros$$ Re: Concatenate Formula

Hi Gyanesh, Thanks so much Its working fine... :) Cheers Shyam 2008/10/24 gyanesh jain <[EMAIL PROTECTED]> > Use this =CONCATENATE(D8," ",D9," ",TEXT(D10,"dd-mmm-yy")) > > where D8 = MS > D9= Excel > D10 = 24 - Oct - 08 > > u will get the answer. > > On Fri, Oct 24, 2008 at 7:04 AM, [EMAI

$$Excel-Macros$$ Re: Lookup for repetitive items

I think advanced filter will solve this...     Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Thu, 10/23/08, Nishant Jain <[EMAIL PROTECTED]> wrote: From: Nishant Jain <[EMAIL PROTECTED]> S

$$Excel-Macros$$ Re: Concatenate Formula

Hi Dear, Use formula =A1&" "&B1&" "&TEXT(C1,"D-MMM-YY"). Regards CA. Atul Singhal -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: October 24, 2008 7:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Concatenate Formula Hi All, I have an

$$Excel-Macros$$ Re: Concatenate Formula

hi. do one thing first paste special the cell value which has date then try concatenation On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi All, > > I have an issue while using concatenate formula, Can any one of you help me > out with this: > > Query: > > Column A : MS > Column B

$$Excel-Macros$$ Re: Concatenate Formula

Hi,   Pls gohead with this attachment.   WISH U HAPPY DIWALI Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Thu, 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: From: [EMAIL PROT

$$Excel-Macros$$ Re: Concatenate Formula

Pls chk attached file Regards Harish Upadhyay On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi All, > > I have an issue while using concatenate formula, Can any one of you help me > out with this: > > Query: > > Column A : MS > Column B : Excel > Column C : 24- Oct-08 ( formated

$$Excel-Macros$$ VBA to extract data from 2 excels

Hello, I am completely new to vba and still learning. I have 2 excels and I want to extract data using VBA based on match criteria on 2 columns. That is: Excel1 has these 4 columns JoinDate, FirstName, LastName, Address. Excel2 has these 9 columns: Transaction Type, Transaction Date, Transactio

$$Excel-Macros$$ Re: Calculate total premium amount for a selected person.

By using sumif() function. it could be done     Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Thu, 10/23/08, Nishant Jain <[EMAIL PROTECTED]> wrote: From: Nishant Jain <[EMAIL PROTECTED]>

$$Excel-Macros$$ Re: Custom Workdays Function

Use the formula, =YourDate + IF(WEEKDAY(YourDate,2) = 6, -1, IF(WEEKDAY(YourDate,2) = 7, 1,0)) Where, YourDate is the date as returned by your UDF. The WeekDay() function, returns am integer From 1(=monday) to 7(=sunday). Regards Ajit On Thu, Oct 23, 2008 at 10:47 PM, David <[EMAIL PROTECTED]>