$$Excel-Macros$$ Formula Required

Dear Team, I need a formula for create unique ID. Unique ID=first character of first Name + last name first character + dob + first & character of Home Town. Name Dob Town Ram Kumar 15-Oct Kota Ram kumar Mishra 18-Sep Patna Ram rajat kumar Mishra 20-Jul Delhi Thanks, Prabh

$$Excel-Macros$$ Continuation of VBA for Excel to Word

I don't know how to mark something uncompleted. The code works every other time. Sub CreateReportPDF() Dim wdapp As Word.Application Dim wddoc As Word.Document Run CopyData Set wdapp = Word.Application Set wddoc = wdapp.documents.Add Application.ScreenUpdating = False wdapp.Visible = True

$$Excel-Macros$$ Re: Cognos Developer - Only GC, Citizens

IQ Provides Best Training for Cognos we have dedicated faculty who can guide the students in the best way Our faculty has more than 5 years of Experience and they are working from top MNCs Our motto is to provide quality Training.. we will

Re: $$Excel-Macros$$ Counting Nos formula

Hi prabhakar, Please find the attachment. Regards, Ganesh N On Mon, Oct 21, 2013 at 2:31 PM, Prabhakar S H wrote: > Hi Team, > > need your help to get nos by using formula. I know how to get details > through pivot table but wanted to know formula also. Pls help. > > Rgds, > Prabhakar > > -- >

RE: $$Excel-Macros$$ Counting Nos formula

Use this for equal =SUMPRODUCT((F9=$A$2:$A$241)*(F9=$B$2:$B$241)) And use this for not equal =SUMPRODUCT((F9=$A$2:$A$241)*(F9<>$B$2:$B$241)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhakar S H Sent: Monday

Re: $$Excel-Macros$$ Counting Nos formula

Hi Prabhakar , Use this array formula- =SUMPRODUCT(--($F9=$A$2:$A$241)*($C$2:$C$241=G$8)) i have learnt it from this experts only. With warm regards, Rajan Sharma On Mon, Oct 21, 2013 at 2:31 PM, Prabhakar S H wrote: > Hi Team, > > need your help to get nos by using formula. I know how t