Re: $$Excel-Macros$$ Help

Hello Sam; A nice solution with Validation. Hello Mahreen; If you use "3", "2", "1" (number inside "") this will return the number as text. When you do calculation excel is considering these as text. Use it without "" or you can simplify the formula to; =IFERROR(LOOKUP($E$2,{-9E+300,3;3,1;4,0

Re: $$Excel-Macros$$ Help

Why don't you use something like this =SUMIF(A1:A10,"<>NA") Regards, Sam On Tue, Nov 1, 2011 at 10:58 PM, Mahreen Ellahi wrote: > Hey thanks, but one more prob, wen i sum up all such scores with few > numbers and text NA, i cant derive the total score. Ofcourse its a text > thatsy but is there

Re: $$Excel-Macros$$ Help

Hey thanks, but one more prob, wen i sum up all such scores with few numbers and text NA, i cant derive the total score. Ofcourse its a text thatsy but is there any possibility i can show the result ignoring the NA On Tue, Nov 1, 2011 at 10:23 PM, Sam Mathai Chacko wrote: > Here's how you do it M

Re: $$Excel-Macros$$ Help

Here's how you do it Mahreen. Create a named range using the formula you already have. And in validation, use List, and type NA,=NmRnge where NmRnge is your named range Check attached. Sam On Tue, Nov 1, 2011 at 9:53 PM, Mahreen Ellahi wrote: > Guys > > I have some serious and need some help.

$$Excel-Macros$$ Help

Guys I have some serious and need some help. I have an excel file with these field Debt : Equity Ratio *Insert Debt to Equity Ratio: * *3.00* Up to 2 3 Above 2 to 3 1 Above 3 to 4 0 Above 4 -3 Score 1 The score is derived through a formula. The cell shall be protected and no formula

Re: $$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP

kbook.Sheets("sheet1").UsedRange.Copy _ ds.Sheets(c").Range("a2") ActiveWorkbook.Close Next c ds.Save Call chgdir End Sub 4. NOT needed as you will close each after getting data. I deleted most of your original post to save lines. = Don Guillett SalesAid Software dguille

$$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP

Dear Sirs, I have a macro which updates my monthly trial balance. But it's too long. Takes time to process. I want to shorten it particularly step 1, step 3 & step 4, using loop which i am not very good at. Please help how to shorten my codes. Below is my macro. Thank you. DanJ STEP 1 Sub

Re: $$Excel-Macros$$ Help needed..?

Hi Sriram, Please find attached solved sheet. Thanks Mukesh - Original Message - From: sriram ji To: excel-macros@googlegroups.com Sent: Monday, October 24, 2011 7:04 PM Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and provide

RE: $$Excel-Macros$$ Help needed..?

Rossoff Sent: Monday, October 24, 2011 8:16 AM To: 'Asa Rossoff'; excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help needed..? I agree with Sam that your requirement isn't 100% clear. He gave a solution for one interpretation. I'll flesh out mine. =IFE

RE: $$Excel-Macros$$ Help needed..?

24, 2011 7:54 AM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Help needed..? For book #s starting at 1001 and changing every 10 rows; Put in cell A2: =IFERROR(OFFSET(A2,-10,0)+1,1001) In case of Excel version prior to 2003, which doesn't support I

Re: $$Excel-Macros$$ Help needed..?

Maybe??? =IF(COUNTIF(A:A,D4)>=10,"No","") Don Guillett SalesAid Software dguille...@gmail.com From: sriram ji Sent: Monday, October 24, 2011 8:34 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find

Re: $$Excel-Macros$$ Help needed..?

So what exactly do you want? Your attachment isn't clear as to what formula you require. >From what I understood, have made a sheet with sequence of receipt leaflets, depending on the number of leaves and starting number. Regards, Sam Mathai Chacko (GL) On Mon, Oct 24, 2011 at 7:04 PM, sriram j

RE: $$Excel-Macros$$ Help needed..?

opy down. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sriram ji Sent: Monday, October 24, 2011 6:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and provide formula

$$Excel-Macros$$ Help needed..?

Dear All, Kindly find the attached file, and provide formula for this Thanks & Regards, Sriram.G Chennai. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://t

Re: $$Excel-Macros$$ HELP REQUIRED

know if u require anything else happy to help. >>>> >>>> Note: in place of your path give \ at the end of the path. i.e. >>>> C:\Documents and Settings\ >>>> >>>> >>>> -- >>>> *From:* Aami

Re: $$Excel-Macros$$ HELP REQUIRED

kbook and paste the code there. >>> >>> let us know if u require anything else happy to help. >>> >>> Note: in place of your path give \ at the end of the path. i.e. >>> C:\Documents and Settings\ >>> >>> >>> --

Re: $$Excel-Macros$$ HELP REQUIRED

; >> let us know if u require anything else happy to help. >> >> Note: in place of your path give \ at the end of the path. i.e. >> C:\Documents and Settings\ >> >> >> -- >> *From:* Aamir Shahzad >> *To:* excel-mac

Re: $$Excel-Macros$$ HELP REQUIRED

- > *From:* Aamir Shahzad > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, 23 October 2011 4:28 PM > *Subject:* Re: $$Excel-Macros$$ HELP REQUIRED > > Can you please brief how to use & apply the codes in excel. > > Aamir Shahzad > > &

Re: $$Excel-Macros$$ HELP REQUIRED

. i.e. C:\Documents and Settings\ > >From: Aamir Shahzad >To: excel-macros@googlegroups.com >Sent: Sunday, 23 October 2011 4:28 PM >Subject: Re: $$Excel-Macros$$ HELP REQUIRED > > >Can you please brief how to use & apply the codes i

Re: $$Excel-Macros$$ Help in Learn advanced excel in noida

Noor is the best teacher . you can contact him. he has great skills in excel . On Sun, Oct 23, 2011 at 10:10 PM, ashish koul wrote: > Contact Noorian Ansari "NOORAIN ANSARI" , > > > On Sun, Oct 23, 2011 at 11:11 AM, ram gopal yadav wrote: > >> Hi all, >> >> Kindly tell me that from where i can l

Re: $$Excel-Macros$$ Help in Learn advanced excel in noida

Contact Noorian Ansari "NOORAIN ANSARI" , On Sun, Oct 23, 2011 at 11:11 AM, ram gopal yadav wrote: > Hi all, > > Kindly tell me that from where i can learn advanced excel in > noida(U.P). > > please tell me the best institute/faculty in noida from where i can > lear macro and VBA > > Thanks in ad

Re: $$Excel-Macros$$ HELP REQUIRED

wrksht.Name & ".xlsx" > ActiveWindow.Close > Next > > End Sub > > > -- > *From:* vijayajith VA > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, 20 October 2011 9:19 PM > *Subject:* $$Excel-Macros$$ HELP REQUIRED > > HI, > > > I

$$Excel-Macros$$ Help in Learn advanced excel in noida

Hi all, Kindly tell me that from where i can learn advanced excel in noida(U.P). please tell me the best institute/faculty in noida from where i can lear macro and VBA Thanks in advance. Ram Gopal 8130155401 -- --

Re: $$Excel-Macros$$ HELP REQUIRED

rksht.Copy     ActiveWorkbook.SaveAs Filename:= "your pah" & wrksht.Name & ".xlsx"     ActiveWindow.Close     Next End Sub > >From: vijayajith VA >To: excel-macros@googlegroups.com >Sent: Thursday, 20 October 2011 9:19 P

Re: $$Excel-Macros$$ Help

Hello Surya; If your data is sorted by Country in Ascending order, use the file sorted_by_Country. The other one will work with sorted or unsorted data. Also used dynamic range. HTH Haseeb -- -- Some important li

Re: $$Excel-Macros$$ Help

Here's an accurate list. Regards, Sam Mathai Chacko (GL) On Mon, Oct 17, 2011 at 8:53 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please see attached sheet with explain > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http:

Re: $$Excel-Macros$$ Help

Dear Ankit, Please see attached sheet with explain Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Oct 17, 2011 at 7:06 PM, Ankit Agrawal wrote: > Hi

Re: $$Excel-Macros$$ Help

Hi Noorain, Could you plz make me understand how has it been done? Thanks Regards, Ankit On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI wrote: > Dear Surya, > > Please see attached sheet > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/

Re: $$Excel-Macros$$ Help

Dear Surya, Please see attached sheet -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.b

$$Excel-Macros$$ Help

Hi All, Can anyone help me on this by using index function. I have a drop down where i click on the required and i need to get the subset details of those drop down Thanks Prasad -- -- Some important links for exce

Re: $$Excel-Macros$$ Help

Send sample file On 15 Oct 2011 21:51, "santhu" wrote: > Hi, > > How to extract a text file data to an excel sheet. > > Ex: Sl.no FirstName MiddleName LastName Place > 1 ABC abc India > 2 DEF def ghi A

Re: $$Excel-Macros$$ Help

Try importing data from external file > Text file. When you import, you'll get an option to use a delimiter. Normally, text files are delimited using tab, or space. Regards, Sam Mathai Chacko (GL) On Sat, Oct 15, 2011 at 6:25 PM, XLS S wrote: > Kindly send text file.. > > On Sat, Oct 15, 201

Re: $$Excel-Macros$$ Help

can you attach the sample file On Sat, Oct 15, 2011 at 5:55 PM, santhu wrote: > Hi, > > How to extract a text file data to an excel sheet. > > Ex: Sl.no FirstName MiddleName LastName Place > 1 ABC abc India > 2 DEF def

Re: $$Excel-Macros$$ Help

Kindly send text file.. On Sat, Oct 15, 2011 at 5:55 PM, santhu wrote: > Hi, > > How to extract a text file data to an excel sheet. > > Ex: Sl.no FirstName MiddleName LastName Place > 1 ABC abc India > 2 DEF def

$$Excel-Macros$$ Help

Hi, How to extract a text file data to an excel sheet. Ex: Sl.no FirstName MiddleName LastName Place 1 ABC abc India 2 DEF def ghi Aus 3 GHI ghi In

Re: $$Excel-Macros$$ Help required

eria1:=Cells(i, "I") Range("A1:H" & lr).Copy .Cells(.Cells(Rows.Count, 1).End(xlUp).Row + 1, 1) Next i Range("A1:H" & lr).AutoFilter .Columns.AutoFit End With Columns("I").Delete End Sub Don Guillett SalesAid Software dguille...@gmail.com From: suryaprasad...@gm

Re: Fw: $$Excel-Macros$$ Help required

Value GoTo lable1: End Sub On Thu, Oct 13, 2011 at 4:21 PM, Mr Excellent wrote: > Hi Group, > > Please help > > Thanks > Prasad. > > -- Forwarded message -- > From: > Date: Thu, Oct 13, 2011 at 10:43 AM > Subject: Fw: $$Excel-Macros$$

Fwd: Fw: $$Excel-Macros$$ Help required

Hi Group, Please help Thanks Prasad. -- Forwarded message -- From: Date: Thu, Oct 13, 2011 at 10:43 AM Subject: Fw: $$Excel-Macros$$ Help required To: excel-macros@googlegroups.com **Hi Guys can anyone help me on this please Thanks Prasad Sent from BlackBerry® on Airtel

Fw: $$Excel-Macros$$ Help required

Hi Guys can anyone help me on this please Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 04:52:12 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help required Hi

$$Excel-Macros$$ Help required

Hi Group, Need a small help, i have a code which runs on the data and seggregates the details as per the Country, but additional to that i require the Country name should come on the top of each rows which are divided by country in the first column and the heading should be applicable to all the s

RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

your point! All the best, Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Wednesday, October 05, 2011 5:32 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Thank

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

ula like this one.** > ** > > ** ** > > Asa > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ChilExcel > *Sent:* Tuesday, October 04, 2011 6:33 PM > *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Jai another excellent solution provided by Rajan Berma Try this : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Dim lngValueAs Long Dim intICounter As Integer Dim strMsg As String Dim lngValue2 As Long lngValue = Target.Value lng

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

excellent solution, launching the message showing the repeat value thank you very much for your time and attention Rajan Chilexcel 2011/10/5 rajan verma > Try this : > > Private Sub Worksheet_Change(ByVal Target As Range) > On Error GoTo Err: > Dim lngValueAs Long > Dim i

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Try this : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Dim lngValueAs Long Dim intICounter As Integer Dim strMsg As String Dim lngValue2 As Long lngValue = Target.Value lngValue2 = Target.Offset(0, -1).Value If Intersect(Target

RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Or (slaps head) -- Just use: =countifs($B$2:$B$1000,$B2,$C$2:$C$1000,$C2)=1 Asa From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Tuesday, October 04, 2011 9:40 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate en

RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

e this one. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Tuesday, October 04, 2011 6:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Thanks Rajan I

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Please see Mathai solution proposed by Sam Chacko Excellent! Private Sub Worksheet_Change(ByVal Target As Range) Dim lngCount As Long Dim lngLoop As Long Dim strMsg As String lngCount = Evaluate("=SUMPRODUCT((Hoja1!$B$2:$B$57&Hoja1!$C$2:$C$57<>)*(Hoja1!$B$2:$B$57=Hoja1!B" & Ta

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Thanks Rajan I need is to columns B and C (together) containing the mirrored pair in same row good solution you propose, but only in column B duplicate Thanks Rajan 2011/10/4 rajan verma > Try this Code : > this Code enable you to check the duplicate entry at the time of Data Entry > .. > >

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Try this Code : this Code enable you to check the duplicate entry at the time of Data Entry .. Private Sub Worksheet_Change(ByVal Target As Range) Dim lngValueAs Long Dim intICounter As Integer Dim strMsg As String lngValue = Target.Value If Intersect(Target, Range("

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

I need also this VB Code On Mon, Oct 3, 2011 at 4:41 AM, ChilExcel wrote: > Urgent !! > i Need VB lines codes for > > 2011/10/1 ChilExcel > >> hi >> >> i Need VB lines codes for >> Alert MsgBox Pair duplicate entry in row >> >> Column D function account and duplicates alerts (NO Problem!

RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Monday, October 03, 2011 12:16 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Chil, Paste this code in the sheet

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Excellent, exactly what I needed thank you very much Sam !!! 2011/10/3 Sam Mathai Chacko > Chil, > > Paste this code in the sheet code module of the respective sheet. Now once > any entry is made in any row of B & C, it will check and display a message > if any duplicate is found. > > Priva

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Chil, Paste this code in the sheet code module of the respective sheet. Now once any entry is made in any row of B & C, it will check and display a message if any duplicate is found. Private Sub Worksheet_Change(ByVal Target As Range) Dim lngCount As Long Dim lngLoop As Long Dim strM

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Urgent !! i Need VB lines codes for 2011/10/1 ChilExcel > hi > > i Need VB lines codes for > Alert MsgBox Pair duplicate entry in row > > Column D function account and duplicates alerts (NO Problem!) > Attach File , thank you all > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Vi

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

el-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko > *Sent:* 02 October 2011 21:28 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help needed to find total & Unique count > from a range of moving dates > > ** ** > > Hi Amit, > &

RE: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

t; range. And yes, thanks a lot for appreciating Meru's service Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: 02 October 2011 21:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ H

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

Hi Amit, Follow steps carefully in sequence Add 3 named ranges as below Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT("z",20),LOG!$E$2:$E$1,1)) EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1)) Data=IF((EntryDate>=Sheet2!$A1)*(EntryDate<=Sheet2!$B1)=1,Vehicl

$$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

hi i Need VB lines codes for Alert MsgBox Pair duplicate entry in row Column D function account and duplicates alerts (NO Problem!) Attach File , thank you all -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- --

Re: $$Excel-Macros$$ Help Needed.

Here is one I like to use for setting variables (Options) in a file that is used by other Macros. Using the Macro below; I can toggle between True and False on the Options and Colors for specific cells. Available Options Star Font Size =16 Label Fo

Re: $$Excel-Macros$$ Help Needed.

Thanks rajan babu, for that link.Can anybody quote some more examples in detail.I just got a little understanding of the function with arguments.But to enhance my knowledge i would like to study more examples...Pls provide me with any other examples. On Sat, Oct 1, 2011 at 12:18 PM, rajan verm

Re: $$Excel-Macros$$ Help Needed.

Please VIsit this Page.. http://www.cpearson.com/excel/Events.aspx On Sat, Oct 1, 2011 at 12:09 PM, XLS S wrote: > Hey Rajan Babu, > > which page? > > > > > > On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote: > >> HI, >> Please visit this Page to know more about Worksheet Events.. >> >> Regar

Re: $$Excel-Macros$$ Help Needed.

Hey Rajan Babu, which page? On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote: > HI, > Please visit this Page to know more about Worksheet Events.. > > Regards > Rajan > > On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote: > >> HI group, >> >> This is a Great & amazing group in learning exce

Re: $$Excel-Macros$$ Help Needed.

HI, Please visit this Page to know more about Worksheet Events.. Regards Rajan On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote: > HI group, > > This is a Great & amazing group in learning excel vba.. > > > *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean)* >

$$Excel-Macros$$ Help Needed.

HI group, This is a Great & amazing group in learning excel vba.. *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)* *Dim st As String* *Dim sh As Worksheet* *Set sh = Sheets("Sheet2")* *st = Target.Address* *sh.Activate* *sh.Range(st).Activate* *ActiveCe

Re: $$Excel-Macros$$ help

Dear naanu, you can also try *Prepare-Inspect Document-Check Hidden Rows and Columns-Press Inspect Button * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ help

Hidden Column Names http://www.excelvbamacros.com/2011/09/find-hidden-column-names-in-sheet.html Hidden Row Numbers http://www.excelvbamacros.com/2011/09/find-hidden-row-number-in-worksheet.html On Sat, Sep 24, 2011 at 4:41 PM, naanu v wrote: > Kindly let me know how to find the hidden rows

Re: $$Excel-Macros$$ Help.

Dear Vijay, Please check below link https://www.odesk.com/.../*Global*-*Reporting* -Analyst-with-strong-background -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Help required offset command

glegroups.com] > *De la part de* Kal xcel > *Envoyé :* vendredi 9 septembre 2011 09:44 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Help required offset command > > ** ** > > Dear Expert, > > > > I need a urgent

Re: $$Excel-Macros$$ Help in IF Function

:00 PM > *Subject:* $$Excel-Macros$$ Help in IF Function > > Hi All, > > Please help me to put the IF function for the below table. If the table > value is 0 the product should not be there > > Attached the file for u r reference > > Tech OFM Apps Systems Res

Re: $$Excel-Macros$$ Help on Indexing and Matching

I would adise you to do the following: 1. Concatenate the three cells I.e., region, province and barangay in both the Sheets. 2. Now use index and match. Let me know if this clear. Regards, Joe On Tuesday, September 6, 2011, John Alliage Tinio Morales < alliage.mora...@gmail.com> wrote: > Hi, I

Re: $$Excel-Macros$$ Help in IF Function

result by IF function regards, Pawel From: anu gomathi To: excel-macros@googlegroups.com Sent: Tuesday, September 6, 2011 9:00 PM Subject: $$Excel-Macros$$ Help in IF Function Hi All,   Please help me to put the IF function for the below table. If the table

$$Excel-Macros$$ Help in IF Function

Hi All, Please help me to put the IF function for the below table. If the table value is 0 the product should not be there Attached the file for u r reference Tech OFM Apps Systems Result should be 1 2 0 1 Tech;OFM;Systems 1 2 0 1 Tech;OFM;Systems 1 2 1 0 Tech;OFM;Apps 1 0 0 1 Tech Systems

Re: $$Excel-Macros$$ Help to create summary table count unique

--- > *From: * ChilExcel > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 4 Sep 2011 12:36:39 -0400 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique > > I have solved

Re: $$Excel-Macros$$ Help to create summary table count unique

s? >>>> >>>> Sent on my BlackBerry® from Vodafone >>>> -- >>>> *From: *NOORAIN ANSARI >>>> *Sender: *excel-macros@googlegroups.com >>>> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >>>> *To:

Re: $$Excel-Macros$$ Help to create summary table count unique

//noorain-ansari.blogspot.com/> >>> >>> On Fri, Aug 26, 2011 at 10:51 AM, wrote: >>> >>>> **Dear excelguru, >>>> >>>> Can u pls elaborate what is unique count? >>>> And how it helps? >>>> >>>> Sent

$$Excel-Macros$$ Help on inputbox

Hi friends i have an issue, i use this do loop to fill cells with a certain text, how i want to choose what i put in "Month i want" and write in columns C until C reaches the value "total", what i pretend is a inputbox where i choose what to write. i think i have to use dim as integer and them de

Re: $$Excel-Macros$$ help

Dear Vijay, if your Word in one cell you can use... =PROPER(Trim(SUBSTITUTE(D4," ",""))) On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote: > Hi, > > i have four words and i need to combine using trim and proper functions. > > Please can you provide me formula > > Thank you > > -- >

RE: $$Excel-Macros$$ help

, August 30, 2011 7:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help Hi, i have four words and i need to combine using trim and proper functions. Please can you provide me formula Thank you -- --

Re: $$Excel-Macros$$ help

Hi vijay, Please send some sample data...for your requirement.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote: > Hi, > > i have four words and i need to combine using trim and proper functions. > > Please can you provide me formula > > Thank you > >

Re: $$Excel-Macros$$ Help to create summary table count unique

t; -- >>> *From: *NOORAIN ANSARI >>> *Sender: *excel-macros@googlegroups.com >>> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >>> *To: * >>> *ReplyTo: *excel-macros@googlegroups.com >>> *Subject: *Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Help to create summary table count unique

BlackBerry® from Vodafone >> -- >> *From: *NOORAIN ANSARI >> *Sender: *excel-macros@googlegroups.com >> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >> *To: * >> *ReplyTo: *excel-macros@googlegroups.com >> *Subject: *Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Help to create summary table count unique

ue count? > And how it helps? > > Sent on my BlackBerry® from Vodafone > -- > *From: *NOORAIN ANSARI > *Sender: *excel-macros@googlegroups.com > *Date: *Fri, 26 Aug 2011 10:49:39 +0530 > *To: * > *ReplyTo: *excel-macros@googlegroups.com &g

Re: $$Excel-Macros$$ Help to create summary table count unique

: $$Excel-Macros$$ Help to create summary table count unique Dear ChilExcel, For Unique Count... Use below function..with Ctrl+shift+Enter.. *=SUM(1/COUNTIF(I1:I28,I1:I28))* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogs

Re: $$Excel-Macros$$ Help to create summary table count unique

Dear ChilExcel, For Unique Count... Use below function..with Ctrl+shift+Enter.. *=SUM(1/COUNTIF(I1:I28,I1:I28))* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel wrote: > h

Re: $$Excel-Macros$$ Help ASAP

uot;X1" > >     Cells(lgRow, 12).AutoFill Cells(lgRow, 12).Resize(3) > >     Cells(lgRow, 13) = Tabl(i, 3) > >     lgRow = lgRow + 1 > >     Cells(lgRow, 13) = Tabl(i, 4) > >     lgRow = lgRow + 1 > >     Cells(lgRow, 13) = Tabl(i, 5) > > Next i >

RE: $$Excel-Macros$$ Help ASAP

= Tabl(i, 5) Next i End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Bhargava Raju Envoyé : lundi 22 août 2011 11:32 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Help ASAP Dear experts, I need help in excel

$$Excel-Macros$$ Help ASAP

Dear experts, I need help in excel ASAP. The attached is a excel file which contains data. I usually given Table 1 or Table 2 and needs to be changed to the Table 3 format. The data in the attached file is very less. But in real time I would be given data containing some 5000 to 8000 line items wi

Re: $$Excel-Macros$$ Help with Formula

August 19, 2011 11:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help with Formula Hi, Can some one help me to create a formula in excel. Using the attached file, please refer to the "Monthly IS" tab, column D. I need help writing a formula that will: 1.. retr

Re: $$Excel-Macros$$ help table percentage

ws.Count, "b").End(xlUp).Row > Range("j4:p" & Cells(Rows.Count, "J").End(xlDown).Row).Delete > Range("J3:P3").AutoFill Destination:=Range("J3:P" & slr) > End Sub > > *From:* ChilExcel > *Sent:* Thursday, August 18, 2011 7:36

$$Excel-Macros$$ help table percentage

Hello everyone please, I need vb code to create percentage range or table 2 msgbox ideal 1 input range 2 output range values ​​and ranges are always different I attached an example of my need to automate -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com

RE: $$Excel-Macros$$ Help for to get the detail from the word document

Please attached Your Word document: From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rengaraj mohan Sent: Thursday, August 18, 2011 11:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help for to get the detail from the word document

$$Excel-Macros$$ Help for to get the detail from the word document

Hi Experts, In the folder location i had a Zip file and inside of the zip file i had a word document. Inside of the document i had a page detail. i want macro to open the particular location zip file and get the page number from the word document. Please help. For Example: 903215610 132165833 13

RE: $$Excel-Macros$$ help required 4

statement. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Saturday, August 13, 2011 6:47 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help required 4 Hi, Can anyone explain me below code ? 1 )for x = 1 To

RE: $$Excel-Macros$$ help required 4

statement. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Saturday, August 13, 2011 6:47 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help required 4 Hi, Can anyone explain me below code ? 1 )for x = 1 To W

RE: $$Excel-Macros$$ Help needed. compare two wxcel files

ehalf Of Rajendra prasad yadav Sent: Tuesday, August 09, 2011 12:01 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed. compare two wxcel files Hi friends, I am not good at excel. I have a requirement now, Can some one please give the macro to compare two works

Re: $$Excel-Macros$$ Help needed. compare two wxcel files

You need to post examples, etc. From: Rajendra prasad yadav Sent: Monday, August 08, 2011 1:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed. compare two wxcel files Hi friends, I am not good at excel. I have a requirement now, Can some one please give the macro

$$Excel-Macros$$ Help needed. compare two wxcel files

Hi friends, I am not good at excel. I have a requirement now, Can some one please give the macro to compare two worksheets in diferent workbooks and display the differences. Regards, Rajendra 8147524172 -- -- Some i

Re: $$Excel-Macros$$ help 4

Next cell2* > > *Next cell* > > ** > > *If Flag = False Then* > > *GetAddress = "No Match Found"* > > *End If* > > *End Function* > > * * > > * * > > *From:* excel-macros@googlegroups.com

$$Excel-Macros$$ help 4

Hi Excel gurus. Can anybody explain me on below code ? Just i wanted to kn About flag with examples ..Please dont scold me for asking this type of silly questions ... i am still learing Thnks For Each cell In rng flag = 0 For t = LBound(List) To UBound(List)

<    5   6   7   8   9   10   11   12   13   14   >