$$Excel-Macros$$ HELP - MACRO TO INCREMENT A COLUMN IN FOR EACH UNIQUE VALUE IN ANOTHER COLUMN

Good day Group, I need some URGENT assistance with a MACRO TO INCREMENT A COLUMN IN FOR EACH UNIQUE VALUE IN ANOTHER COLUMN. Below is how it should work; I extracted some rows from the attached sheet *“*NBR ALL.xlsx*”*. For each* *unique text in column C there is a corresponding unique value in c

RE: $$Excel-Macros$$ Help: VBA code for RGB values

Thank you so much for this, it is as perfect as I wanted. One Love. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Sunday, March 11, 2012 12:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help: VBA code for

Re: $$Excel-Macros$$ Help Needed

Try this Sub CreateWordDocs() Dim xsht As Worksheet Dim rng As Range Dim lngLoop As Integer Set xsht = ActiveWorkbook.Worksheets("Sheet1") lngLoop = xsht.Cells(Rows.Count, 3).End(xlUp).Row If lngLoop > 1 Then With CreateObject("Word.Application") .Vis

Re: $$Excel-Macros$$ Help Needed

Dear Sir I can able to create Notepad files , but i getting following error when trying to create word files Run Time Error User Defined is not found On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar wrote: > Hi, > > check this out > > Sub CreateWordDocs() > ' add a reference to the Word-library >

Re: $$Excel-Macros$$ Help Needed

Hi, Please find the attached text file. Copy and paste in that excel file and run. Regards Kumar On Tue, Mar 13, 2012 at 2:08 PM, Patil MG wrote: > Hi All > > can any one help me pl..its very urgent,,, > > > On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote: > >> Dear Exper

Re: $$Excel-Macros$$ Help Needed

Hi, check this out Sub CreateWordDocs() ' add a reference to the Word-library ' this is for creating number word Documents and renaming them with file names mentioned in 'C' column ' this code doesn't write any content, it just creates word documents and saves them Dim newapp As

Re: $$Excel-Macros$$ Help Needed

Hi All can any one help me pl..its very urgent,,, On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote: > Dear Experts, > > I have to create 'N' number of empty files of word and note pad files, > this word will long time to do can any one help to write a macro where in > which

$$Excel-Macros$$ Help Needed

Dear Experts, I have to create 'N' number of empty files of word and note pad files, this word will long time to do can any one help to write a macro where in which i can create empty word files or note pad files by running the macro, my files will be listed in excel file (please refer the attache

Re: $$Excel-Macros$$ help on copy and past data needed

i Sent: Monday, March 12, 2012 8:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help on copy and past data needed Hi All, I need your help on this one, please help. What I need to do on weekly base I need to copy the report (like the one in "REPORT" tab)and find t

Re: $$Excel-Macros$$ Help Formula to find last date please

Or a non-array formula =LOOKUP(2,1/(C3:Z3<>0),$C$2:$Z$2) Kris -- 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, and Need Advice will not get quick atte

Re: $$Excel-Macros$$ Help Formula to find last date please

Dear marcio, You can also use.. =INDEX($2:$2,0,LARGE(IF(C3:Z3>0,COLUMN($C$2:$Z$2),""),COLUMN(A2))) with ctrl+shift+enter See attached sheet. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Mon, M

Re: $$Excel-Macros$$ Help Formula to find last date please

Hi Marcio, It has been done using Excel formula, see the attachment and let me know if this is what you were looking for. Feel free to get back in case of any queries. Thanks. Regards, DILIPandey On Mon, Mar 12, 2012 at 6:53 AM, Marcio Bandeira de Azevedo < marciobandeir...@gmail.com> wrote:

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

Sheet protection easy to defeat while vba protection is more difficult. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Seraj Alam Sent: Sunday, March 11, 2012 10:01 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help... Hi, Please find

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

Hi, Please find below link to hide formula in spreadsheets... http://www.techonthenet.com/excel/cells/hide_formulas.php Thanks Seraj On Sun, Mar 11, 2012 at 4:57 PM, ashjain2...@yahoo.co.in < ashjain2...@yahoo.co.in> wrote: > Dear Team > > I use many formulas in the excel sheet and i want th

Re: $$Excel-Macros$$ Help: VBA code for RGB values

8aff74067d&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=1066&bih=670 or tinyurl http://tinyurl.com/6rozprj Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Saturday, March 10, 2012 10:06 PM To: excel-macros@googlegroups.com

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

@googlegroups.com Cc: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help... Dear Team I use many formulas in the excel sheet and i want that no one can see the formulas... Request you to please suggest how to lock it.. Ashok - -- FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Help...

Dear Team I use many formulas in the excel sheet and i want that no one can see the formulas... Request you to please suggest how to lock it.. Ashok - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Help: VBA code for RGB values

2012 at 2:43 AM, dguillett1 wrote: > http://www.cpearson.com/excel/colors.aspx > & see att > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Janet Dickson > *Sent:* Saturday, March 10, 2012 6:43 AM > *To:* excel-m

$$Excel-Macros$$ Help: VBA code for RGB values

Hi All, I have attached a file to show my challenge. The file shows one column with colors in cells and second column empty, but I want to add RGB Values automatically using VBA. Help please. cheers -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate threa

Re: $$Excel-Macros$$ help

Hi Try : Sub Mtest() Dim i As Long Application.ScreenUpdating = False On Error Resume Next For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If InStr(1, Cells(i, 1).Value, "This page", 1) Or _ InStr(1, Cells(i, 1).Value, "Search Results", 1) Or _ InSt

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

> *From:* Jorge Marques > *Sent:* Wednesday, February 29, 2012 5:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and > counting > > Sorry my friends for writting again in the post, it just that i > understood

Re: $$Excel-Macros$$ help

hi shaik. Sorry. i need code for ths.. On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA wrote: > Hi Sahik,, > > Sorry ..i need required code for ths .. Thanks'' > > > On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed wrote: > >> Hi, >> PFA solved, hope this is what u need. >> >> Steps:1) Select ur dat

Re: $$Excel-Macros$$ help

Hi Sahik,, Sorry ..i need required code for ths .. Thanks'' On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed wrote: > Hi, > PFA solved, hope this is what u need. > > Steps:1) Select ur data range--> click on "data" menu, ---> Remove > Duplicates--->Just click OK. > > On Fri, Mar 2, 2012 at 12:14 P

Re: $$Excel-Macros$$ help

Hi, PFA solved, hope this is what u need. Steps:1) Select ur data range--> click on "data" menu, ---> Remove Duplicates--->Just click OK. On Fri, Mar 2, 2012 at 12:14 PM, vijayajith VA wrote: > Hi > > > > Please find the attached query/// > > > Thanks > > -- > FORUM RULES (986+ members already B

$$Excel-Macros$$ help

Hi Please find the attached query/// Thanks -- 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, and Need Advice will not get quick attention or may not be

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Software dguille...@gmail.com From: Jorge Marques Sent: Wednesday, February 22, 2012 10:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it suited me for doing another thing

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

1 >>> >>>> Glad to help >>>> >>>> Don Guillett >>>> SalesAid Software >>>> dguille...@gmail.com >>>> >>>> *From:* Jorge Marques >>>> *Sent:* Wednesday, February 22, 2012 10:00 AM >>&

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

you again :). >> >> 2012/2/22 dguillett1 >> >>> Glad to help >>> >>> Don Guillett >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Jorge Marques >>> *Sent:* Wednesday, February 22, 2012 10:00 AM >

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

; >> *From:* Jorge Marques >> *Sent:* Wednesday, February 22, 2012 10:00 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and >> counting >> >> >> Hi, Aamir Shahzad was option was good, bu

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

*From:* Jorge Marques > *Sent:* Wednesday, February 22, 2012 10:00 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and > counting > > > Hi, Aamir Shahzad was option was good, but it suited me for doing another &g

Re: $$Excel-Macros$$ help needed??

"," & Cells(1, c) Next c Cells(r, "I") = Right(ms, Len(ms) - 1) Next r End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Sunday, February 26, 2012 10:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help needed??

Re: $$Excel-Macros$$ help needed??

thanks for help sir i am already done with if statement. chk attachment. and provide other solution vlookup/index-match On Sun, Feb 26, 2012 at 9:33 PM, xlstime wrote: > please find the attachment > > On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > >> Dear sir, >>plz dow

Re: $$Excel-Macros$$ help needed??

Instead of using the CONCATENATE function with multiple if conditions, better to use a simple helper column with a small formula like this J2=IF(C2="Y",IF(I2<>"",I2&",","")&C$1,TEXT(I2,"")) And H2=LOOKUP("ZZ",J2:N2) Regards, Sam Mathai Chacko On Sun, Feb 26, 2012 at 9:33 PM, xlstime w

Re: $$Excel-Macros$$ help needed??

My Try, =IF(AND(C2="Y",COUNTIF(D2:G2,"Y")),$C$1&",",IF((C2)="Y",$C$1,""))&IF(AND(D2="Y",COUNTIF(E2:G2,"Y")),$D$1&",",IF((D2)="Y",$D$1,""))&IF(AND(E2="Y",COUNTIF(F2:G2,"Y")),$E$1&",",IF((E2)="Y",$E$1,""))&IF(AND(F2="Y",COUNTIF(G2:G2,"Y")),$F$1&",",IF((F2)="Y",$F$1,""))&IF(G2="Y",$G$1,"") On Sun, F

Re: $$Excel-Macros$$ help needed??

please find the attachment On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > Dear sir, >plz download the attachment and help me... > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > He

Re: $$Excel-Macros$$ Help with code please.

I do not disagree. Don Guillett SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Wednesday, February 22, 2012 7:36 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help with code please. Hey Don, I wasn't saying my modification would be faster. Find s

Re: $$Excel-Macros$$ Help plz

thanks :) On Tue, Feb 21, 2012 at 8:41 PM, Sam Mathai Chacko wrote: > =IF(AND(A1>=3000,A1<=4500),B1*0.5,B1) > > Sam Mathai Chacko > > > On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail wrote: > >> Please check attached >> I need this function necessary now . >> >> thanks, >> >> >> * >> --

Re: $$Excel-Macros$$ Help plz

thanks :) On Wed, Feb 22, 2012 at 2:47 PM, m7md.gmail wrote: > thanks :) > > > On Tue, Feb 21, 2012 at 8:41 PM, Sam Mathai Chacko wrote: > >> =IF(AND(A1>=3000,A1<=4500),B1*0.5,B1) >> >> Sam Mathai Chacko >> >> >> On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail wrote: >> >>> Please check attached >>>

RE: $$Excel-Macros$$ Help with code please.

A1. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, February 21, 2012 1:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help with code please. Asa, Agree about the "undue attention". My ex

Re: $$Excel-Macros$$ Help plz

=IF(AND(A1>=3000,A1=<4500),B1*0.5,"") On Wed, Feb 22, 2012 at 11:14 PM, Seraj Alam wrote: > Please try this in C1 > > =IF(A1>=3000,IF(A1<=4500,B1*0.5,""),"") > > > seraj alam > > > On Tue, Feb 21, 2012 at 12:31 AM, m7md.gmail wrote: > >> Please check attached >> I need this function necessary

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Glad to help Don Guillett SalesAid Software dguille...@gmail.com From: Jorge Marques Sent: Wednesday, February 22, 2012 10:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

gmail.com > > *From:* Aamir Shahzad > *Sent:* Monday, February 20, 2012 11:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and > counting > > Dear Jorge, > > See the third table in attached sheet. >

Re: $$Excel-Macros$$ Help with code please.

t: Tuesday, February 21, 2012 7:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help with code please. Don, your code works fine for the selection. I would gladly accept any correction if somebody did that to me. My only point is that 1. Find doesn't stop the loop in other

Re: $$Excel-Macros$$ Help with code please.

> > > On Wed, Feb 22, 2012 at 3:03 AM, dguillett1 wrote: > > >>   Asa, Agree about the “undue attention”. My experience tells me that > >> just leaving it out ( as I did) serves the purpose. Maybe you can time > >> it.?? > > >&g

Re: $$Excel-Macros$$ Help with code please.

Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Sam Mathai Chacko > *Sent:* Tuesday, February 21, 2012 6:56 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help with code please. > > Haha, I like the way you put that Don. I agree 6 of

Re: $$Excel-Macros$$ Help with code please.

sAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, February 21, 2012 6:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help with code please. Haha, I like the way you put that Don. I agree 6 of 1 is half a dozen of another. On the other point however

Re: $$Excel-Macros$$ Help with code please.

uille...@gmail.com > > *From:* Asa Rossoff > *Sent:* Tuesday, February 21, 2012 2:10 PM > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ Help with code please. > > > Too true Don// > > > > .Find finds the first match… and stops. >

Re: $$Excel-Macros$$ Help with code please.

Subject: RE: $$Excel-Macros$$ Help with code please. Too true Don// .Find finds the first match… and stops. However, with all the undue attention to this code, I will offer a suggested update. The Set mg = .Cells.Find lines can be changed to the following to prevent an oft-overlooked issue

RE: $$Excel-Macros$$ Help with code please.

[mailto:a...@lovetour.info] Sent: Tuesday, February 21, 2012 12:11 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Help with code please. Too true Don// .Find finds the first match. and stops. However, with all the undue attention to this code, I will offer a sugges

RE: $$Excel-Macros$$ Help with code please.

ooglegroups.com] On Behalf Of dguillett1 Sent: Tuesday, February 21, 2012 11:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help with code please. Sam, The code I provided does stop the macro with the selection. Yes, goto could be used but OP said select sheet select cell

Re: $$Excel-Macros$$ Help with code please.

To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help with code please. You'd want to exit the routine if the cell is found. Also, you can use application.goto to select the cell. I would also be weary about hidden sheets if any. Sub lookinallsheets() Dim wks As Work

Re: $$Excel-Macros$$ Help plz

Try it in C1, =IF(AND(A1>3000,A1<4500),B1*0.5,"") If A1 is not in between 3000 and 4500, nothing will show. On Tue, Feb 21, 2012 at 12:31 PM, m7md.gmail wrote: > Please check attached > I need this function necessary now . > > thanks, > > > * > -- > * > > Regard

Re: $$Excel-Macros$$ Help plz

=IF(AND(A1>=3000,A1<=4500),B1*0.5,B1) Sam Mathai Chacko On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail wrote: > Please check attached > I need this function necessary now . > > thanks, > > > * > -- > * > > Regards, > > Mohamed Mahmoud > > > > > -- > FORUM RULES (986+

Re: $$Excel-Macros$$ Help with code please.

Original Message- From: Bob > Sent: Monday, February 20, 2012 2:28 PM > > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ Help with code please. > > > There will never be more than 1 of the same number. I just need it to > select the sheet that it's o

Re: $$Excel-Macros$$ Help with code please.

hDirection:=xlNext) If Not mf Is Nothing Then .Select mf.Select End If End With Next ws End Sub Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Bob Sent: Monday, February 20, 2012 2:28 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Help with c

Re: $$Excel-Macros$$ Help with code please.

e info?? > > Don Guillett > SalesAid Software > dguille...@gmail.com > > > > -Original Message- > From: Bob > Sent: Sunday, February 19, 2012 6:33 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Help with code please. > > I almost have the

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

ells(i + 1, "f")) + Val(Cells(i, "f")) Cells(i, "g") = Val(Cells(i + 1, "g")) + Val(Cells(i, "g")) Rows(i + 1).Delete End If Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Monday, February 20, 20

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Dear Jorge, See the third table in attached sheet. Aamir Shahzad On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques wrote: > Hi friends, i have a problem, > 1. i trying to use a report and i have to sum the column H, G, F, if the > orders numbers are equal and > 2. leave the information in column

$$Excel-Macros$$ Help on gathering duplicate summing and counting

Hi friends, i have a problem, 1. i trying to use a report and i have to sum the column H, G, F, if the orders numbers are equal and 2. leave the information in column B,C,D, gathered. 3. The problem is that i was doing it with formulas, but didn´t have a dinamic range that´s the first, 4. then the

Re: $$Excel-Macros$$ Help with code please.

work with the found item. More info?? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Bob Sent: Sunday, February 19, 2012 6:33 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Help with code please. I almost have the code the way I need it. BUT I wa

$$Excel-Macros$$ Help with code please.

I almost have the code the way I need it. BUT I want it to Find everything within in the same Workbook, not just on the Index Worksheet. Thanks in advance!!! Private Sub CommandButton1_Click() Dim IndividualSearch As String IndividualSearch = InputBox("What's the part number you're looking for?",

Re: $$Excel-Macros$$ Help required-Macro to Convert numeric value to words in Excel

http://www.4shared.com/file/3WYWaW-Y/Indian.html On Mon, Feb 13, 2012 at 1:26 PM, NOORAIN ANSARI wrote: > Dear Vikram, > > Please find attached Converter. > > On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar wrote: > >> Hi, >> >> Please find enclosed macro to convert numeric value to words in excel >>

Re: $$Excel-Macros$$ Help required-Macro to Convert numeric value to words in Excel

Dear Vikram, Please find attached Converter. On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar wrote: > Hi, > > Please find enclosed macro to convert numeric value to words in excel > (Rupees). > > I have enclosed macro related to Dollar value but i need the same for > Rupees. > > Kindly help regardin

$$Excel-Macros$$ Help required-Macro to Convert numeric value to words in Excel

Hi, Please find enclosed macro to convert numeric value to words in excel (Rupees). I have enclosed macro related to Dollar value but i need the same for Rupees. Kindly help regarding the same if possible. Regards, VENUS -- FORUM RULES (986+ members already BANNED for violation) 1) Use conci

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

The easiest way is to uncheck the show zeroes in the Excel option. Regards, Sam Mathai Chacko On Thu, Feb 9, 2012 at 6:31 PM, Shaik Waheed wrote: > Thanks noorain > > thats wonderful, > > On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI > wrote: > >> Dear waheed, >> >> It is also possible witho

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Thanks noorain thats wonderful, On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI wrote: > Dear waheed, > > It is also possible without Indirect function.. > > =IF(ISBLANK(EMP.DATA),"",EMP.DATA) > > With ctrl+shift+Enter > > On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed wrote: > >> Thank you Maris

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Dear waheed, It is also possible without Indirect function.. =IF(ISBLANK(EMP.DATA),"",EMP.DATA) With ctrl+shift+Enter On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed wrote: > Thank you Maris for ur reply.its working fine. > > > On Thu, Feb 9, 2012 at 5:18 PM, Maries wrote: > >> Hi, >>

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Thank you Maris for ur reply.its working fine. On Thu, Feb 9, 2012 at 5:18 PM, Maries wrote: > Hi, > > Use this formula with CSE. > > *=IF(INDIRECT("EMP.DATA")="","",INDIRECT("EMP.DATA"))* > > Regards, > > MARIES. > > On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed wrote: > >> Hi Experts

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Hi, Use this formula with CSE. *=IF(INDIRECT("EMP.DATA")="","",INDIRECT("EMP.DATA"))* Regards, MARIES. On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed wrote: > Hi Experts, > > I have an excel sheet with defined named ranges. When I am using Indirect > array formula to capture the named range it

$$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Hi Experts, I have an excel sheet with defined named ranges. When I am using Indirect array formula to capture the named range it is showing zeros (0's) in place of blanks that are available in my named range. Is there any way to get only blanks as result because i dont want zeros. Please find th

Re: $$Excel-Macros$$ help

< >>> noorain.ans...@gmail.com> wrote: >>> >>>> Dear Vijay, >>>> >>>> You can also try... >>>> >>>> =MID(A1,FIND("(",A1)+1,FIND(")",A1,1)-FIND("(",A1)-1) >>>> >>>> See attached

Re: $$Excel-Macros$$ help

gt;> >> See attached sheet.. >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blog

Re: $$Excel-Macros$$ help

om/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > -- Forwarded message ------ > From: vijayajith VA > Date: Sun, Dec 25, 2011 at 3:01 PM > Subject: $$Excel-Macros$$ help > To: excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Help Required

attachment Missing On Tue, Jan 31, 2012 at 9:26 AM, PRAVESH KUMAR wrote: > Hi Group, > > I want to extract my data horizently according to my header from vertical > row data. > See attached sheet for more clearity. > > Thanks in advance > > > With Regards, > Pravesh > > -- > FORUM RULES (986+ me

$$Excel-Macros$$ Help Required

Hi Group, I want to extract my data horizently according to my header from vertical row data. See attached sheet for more clearity. Thanks in advance With Regards, Pravesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ help

Venkat, You are digressing from the question, although explaining what absolute and relative reference is good for common understanding. The question in particular, however, is regarding relative reference in vb developer tab. Vijay, the Relative Reference button is just a way to tell the VBA wh

Re: $$Excel-Macros$$ help

Hi Vijay, Look Below about relative refrence.. *What are the types of references?*1. Absolute Column/Absolute Rowe.g. $A$1means Whether you use auto-fill across column or across row, the reference won't be changed. 2. Absolute Column/Relative Rowe.g. $A1means When you use auto-fill across column,

$$Excel-Macros$$ help

Hello sir, Just i want to know about use relative reference in vb developer tab.? What is use of that ? Thanks in advance ' -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

Re: $$Excel-Macros$$ help

Dear Vijay, You can use.. *=SUM(INDEX((MONTH($A$2:$A$28)=1)*($C$2:$C$28="Passed"),0,0))* See attached sheet.. On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA wrote: > Hi Gurus, > > > Please find the attached querY > > Thanks in adv. > > -- > FORUM RULES (986+ members already BANNED for viola

Re: $$Excel-Macros$$ help

Sumproduct should work as well withOUT array entering Don Guillett SalesAid Software dguille...@gmail.com From: Maries Sent: Saturday, January 14, 2012 5:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help Find the attached file... On Sat, Jan 14, 2012 at 11:08 AM

Re: $$Excel-Macros$$ help

*Find the attached file...* On Sat, Jan 14, 2012 at 11:08 AM, Sam Mathai Chacko wrote: > You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it > will work in Excel 2003 or 2007+ > > Regards, > > Sam Mathai Chacko > > > On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA > wrote: >

Re: $$Excel-Macros$$ help

You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it will work in Excel 2003 or 2007+ Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA wrote: > Hi Gurus, > > > Please find the attached querY > > Thanks in adv. > > -- > FORUM RULES (986+ members alrea

$$Excel-Macros$$ help

Hi Gurus, Please find the attached querY Thanks in adv. -- 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, and Need Advice will not get quick attention or

Re: $$Excel-Macros$$ HELP - Can´t sum the same columns of a comparative column

...@gmail.com From: Jorge Marques Sent: Friday, January 13, 2012 9:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ HELP - Can´t sum the same columns of a comparative column Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011, 2012, the problem is that i need to

Re: $$Excel-Macros$$ HELP - Can´t sum the same columns of a comparative column

Hi Friend, as per my observation, please find the attachment Team XLS On Fri, Jan 13, 2012 at 8:37 PM, Jorge Marques wrote: > Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011, > 2012, the problem is that i need to compare days, like if i choose to see > day 10 January o

$$Excel-Macros$$ HELP - Can´t sum the same columns of a comparative column

Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011, 2012, the problem is that i need to compare days, like if i choose to see day 10 January of 2012 with the 2011, i must compare the same number of cells with values, so it has to compare 11 january 2011 that has 7 numbered sums

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

roups.com] On Behalf Of Raghav Sent: Dec/Sat/2011 05:21 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help.. Yes i want this. Sent from my Nokia phone -Original Message- From: Rajan_Verma Sent: 31/12/2011 5:15:04 pm Subject: RE: $$Excel-Macros$$ Help.. Hi ragh

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

Yes i want this. Sent from my Nokia phone -Original Message- From: Rajan_Verma Sent: 31/12/2011 5:15:04 pm Subject: RE: $$Excel-Macros$$ Help.. Hi raghav, Do you want to make short cut key to Navigate worksheets?? Rajan. -Original Message- From: excel-macros

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

Hi raghav, Do you want to make short cut key to Navigate worksheets?? Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raghav Sent: Dec/Sat/2011 12:51 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help

$$Excel-Macros$$ Help..

How to set a shortcut key for level?? Sent from my Nokia phone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attentio

Re: $$Excel-Macros$$ Help

Hi Kris, you right..it is very complex with formula..I have to use Pivot table.itwill very easy.. Thanks Nikhil Shah On Fri, Dec 30, 2011 at 1:18 PM, Kris wrote: > Hi, > > With the help of a helper column, a Pivot table would do the trick. > > PFA. > > Kris > > -- > FORUM RULES (934+ members

Re: $$Excel-Macros$$ Help

Hi, With the help of a helper column, a Pivot table would do the trick. PFA. Kris -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will no

Re: $$Excel-Macros$$ Help

o: > excel-macros@googlegroups.com] *On Behalf Of *Nikhil Shah > *Sent:* Dec/Fri/2011 12:37 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help > > ** ** > > Dear Rajan > > ** ** > > Opps..Sorry..Answer is wrong

Re: $$Excel-Macros$$ Help

roups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Maries > *Sent:* Dec/Thu/2011 12:14 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help > > ** ** > > Find the attachment > > On Wed, Dec 28, 2011 at 9:23 PM, Nikhil Shah

RE: $$Excel-Macros$$ Help

Try this =SUMPRODUCT(--(B2:B32<0),--(B3:B33<0)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nikhil Shah Sent: Dec/Wed/2011 10:14 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Dear Friend, I want to find out Conse

Fwd: $$Excel-Macros$$ help

in-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- Forwarded message -- From: vijayajith VA Date: Sun, Dec 25, 2011 at 3:01 PM Subject: $$Excel-Macros$$ help To: excel-macros@googlegroups.com Hi , i have some data like 1) floo see r eree

Re: $$Excel-Macros$$ Help

ree Consecutive year have negative % then what output you want..? > > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Nikhil Shah > *Sent:* Dec/Wed/2011 10:14 > *To:* excel-macros@googlegroups.com > *S

RE: $$Excel-Macros$$ Help

What if three Consecutive year have negative % then what output you want..? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nikhil Shah Sent: Dec/Wed/2011 10:14 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Dear Friend, I want

$$Excel-Macros$$ Help

Dear Friend, I want to find out Consecutive Negative Return (%) in Times & Number Years : Answer is : 2 Times & 2 Years Now i want EXCEL Formula..I am using EXCEL 2003 ..No VBA Code...Pl help me .. *Year* *Return* *Year* *Return* 1980 28.86% 1996 4.24% 1981 49.56% 1997 13.31% 19

$$Excel-Macros$$ Help

Dear Friend, I want to find out Consecutive Negative Return (%) in Times & Number Years : Answer is : 2 Times & 2 Years Now i want EXCEL Formula..Pl help me .. *Year* *Return* *Year* *Return* 1980 28.86% 1996 4.24% 1981 49.56% 1997 13.31% 1982 3.56% 1998 -17.17% 1983 7.20%

<    3   4   5   6   7   8   9   10   11   12   >