Re: $$Excel-Macros$$ How to add a name column to scatter chart's data label?

Hi, I have tried the charting, please check whether you want like this. Regards Prakash Paul On Sat, Aug 6, 2011 at 6:04 AM, Excel 009 wrote: > Hi All, > > I have the following data and want to create a scatter chart. I am > using either 2003 or 2007. > > Person X1 X2 > --

FW: $$Excel-Macros$$ Subtract the minimum value based on multiple criteria

Hi Mukesh Did you shoot this query again , I have sent a solution for this , see the attached sheet, Revert if any query you have? From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Friday, August 05, 2011 6:02 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Subtra

RE: $$Excel-Macros$$ UNIQUE values in Array

Hope this will Help You. Function UniqueList(rng As Range, Pos As Long) As String Dim List() As String Dim cell As Range Dim i As Long Dim t As Long i = 0 ReDim List(rng.Cells.Count) As String For Each cell In rng flag = 0 For t = LBound(List) To UBound(List)

RE: $$Excel-Macros$$ Excel test

visible property of sheet2 is 2- xlSheetVeryHidden From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hanumant shinde Sent: Saturday, August 06, 2011 2:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel test Hi Noorain, how did

RE: $$Excel-Macros$$ Syntax error on calling subroutine

Call sampling Function like this Sampling allData, SomeData From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of marston.go...@allstardirectories.com Sent: Friday, August 05, 2011 11:48 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Syntax

$$Excel-Macros$$ How to add a name column to scatter chart's data label?

Hi All, I have the following data and want to create a scatter chart. I am using either 2003 or 2007. Person X1 X2 -- --- --- a2 4 b8 2 c9 3 d1 5 e8.51 (The range is =S

Re: $$Excel-Macros$$ Excel test

Hi Noorain, how did you hide the sheet2. i could unhide it but programatically not manually. its not even xlsheetveryhidden > >From: NOORAIN ANSARI >To: excel-macros@googlegroups.com >Sent: Fri, 5 August, 2011 11:51:51 AM >Subject: Re: $$Excel-Macros$$ Excel test > > >Dear XLS, > >Please see

$$Excel-Macros$$ UNIQUE values in Array

Hi friends, i have some values in column A. i want to take only UNIQUE values in some array. how can i do so? i have developed below function and is working exactly i want it to be but i think there should be more efficient way of doing so like there may be array function for storing only UN

Re: $$Excel-Macros$$ Syntax error on calling subroutine

try this Call Sampling(AllData, SomeData) add call before calling subroutine see if it helps On Fri, Aug 5, 2011 at 11:48 PM, marston.go...@allstardirectories.com < marston.go...@allstardirectories.com> wrote: > I found a subroutine that creates random samples from a data set. > Trying to uti

$$Excel-Macros$$ Syntax error on calling subroutine

I found a subroutine that creates random samples from a data set. Trying to utilize within another subroutine, but I'm getting a syntax error. Sub Seer is the main routine; Sampling is the routine I'm trying to call. Advice appreciated. Sub Seer() Dim Ndays As Integer Dim Sdays As Integer Nday

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

Congratulations Rajan... :) - Manish On Aug 5, 9:37 pm, neil johnson wrote: > Congratulation Rajan. > > On Fri, Aug 5, 2011 at 8:57 AM, Haseeb Avarakkan > > > > wrote: > > Congratulations Rajan...! > > > Regards, Haseeb > > > -- > > >

$$Excel-Macros$$ Microsoft Excel World Champion

Meet Microsoft Excel World Champion http://gizmodo.com/5827731/the-microsoft-excel-world-champion-yes-srsly-is-a-15-year-old-english-girl -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.posterous.com/ *akoul*.wordpress.com

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

Congratulation Rajan. On Fri, Aug 5, 2011 at 8:57 AM, Haseeb Avarakkan wrote: > Congratulations Rajan...! > > Regards, Haseeb > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips t

$$Excel-Macros$$ Multicriteria search using arrays

Hello All, I am trying to make a userform with 3 criteria and option to search combining those criteria. The database is a second workbook. The result is displayed in a listbox on the userform. Any way it is all working but as I use all the 3 criteria but when i try to search for only on of the

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

congratulations Rajan verma keep ur good work ahead. regards, Dinesh Babu.j -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

RE: $$Excel-Macros$$ Plz help me how can posible

Hi Anil, We can also use Hyperlink in the same workbook to go Other sheet or other cell, Select a Cell and press Ctrl+k, Choose Place in this document , A list will show with the name of all sheets present in the Workbook , You can select any Sheet to Make Hyperlink Thanks Rajan From

RE: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

See if it helps Regards Rajan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dilip Pandey Sent: Thursday, August 04, 2011 11:31 AM To: excel-macros@googlegroups.com Cc: tuffhu...@yahoo.com Subject: Re: $$Excel-Macros$$ Creating L

Re: $$Excel-Macros$$ Help with =now()

Hello Rajan Thanks a lot. It works Thanks Ashish Pradhan On 8/5/2011 5:44 PM, Rajan_Verma wrote: *Use this Format :* *-* ** *From:*excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *On Behalf Of *Venkat CV *Sent:* Friday, August 05, 2011 5:05 PM *To:* excel-

RE: $$Excel-Macros$$ Need help in Meeting room booking system

Hope it will help you Add this in Your code If Day(Me.DTPicker1.Value) >= Day(Now()) And Month(Me.DTPicker1.Value) >= Month(Now()) And Year(Me.DTPicker1.Value) >= Year(Now()) Then If Hour(Me.DTPicker2.Value) >= Hour(Now) & Minute(Me.DTPicker2.Value) >= Minute(Now) Then MsgBox

RE: $$Excel-Macros$$ VBA Code to consolidate all data in a cell

Try this Sub ConcateAll() Dim Resultcell As Range Dim rng As Range Dim cell As Range Dim resultString As String Set rng = Application.InputBox("Please select A Range For Input ", , , , , , , 8) Set Resultcell = Application.InputBox("Please select A Range For Out ",

RE: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

Thank You -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of renuka chari Sent: Friday, August 05, 2011 11:59 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11 Congrats Rajan On

Re: $$Excel-Macros$$ VBA Code to extract data in row

hi Raghavendra, please find the attached file with the solution. On Fri, Aug 5, 2011 at 4:57 PM, Raghavendra wrote: > Hi , > > ** ** > > Can anyone suggest me VBA code to perform task as mentioned in the attached > file. > > ** ** > > Regards, > > Raghavendra > > -- > >

RE: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

Follow The Link For your Answer : http://answers.microsoft.com/en-us/windows/forum/windows_7-desktop/does-micr osoft-word-and-excel-2000-work-on-windows/845d0337-1348-4db3-a123-061c12cb26 de From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Se

RE: $$Excel-Macros$$ Subtract the minimum value based on multiple criteria

Try this =C3-MIN(OFFSET(INDEX(A:A,MATCH(A3,A:A,0),1),,2,COUNTIF(A:A,A3),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mukesh Gupta Sent: Friday, August 05, 2011 2:58 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Subtract the

RE: $$Excel-Macros$$ VBA Code to extract data in row

Try this Sub Extract() Dim rng As Range Dim cell As Range Dim iCounter As Integer Dim Rng2 As Range Dim cell2 As Range Range("A:A").Copy Range("E1") Range("E:E").Select Selection.RemoveDuplicates 1 Set rn

RE: $$Excel-Macros$$ Help with =now()

Use this Format : - From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Friday, August 05, 2011 5:05 PM To: excel-macros@googlegroups.com Cc: ashlyprad...@gmail.com Subject: Re: $$Excel-Macros$$ Help with =now() Hi Ashish, Yes

Re: $$Excel-Macros$$ Help with =now()

*Hi Ashish,* * * *Yes you can Just Type in Custom "As on" mmm you will get output as a "As on August 2011"* * * *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 5, 2011 at 4:53 PM, Ashish Pradhan wrote: > Hello Venkat > > Amazing :-) > > Wonder why I couldn't think of it earlier :-) > >

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

congratulation raj On Fri, Aug 5, 2011 at 5:02 PM, vijayajith VA wrote: > contrats raj > > > On Thu, Aug 4, 2011 at 11:18 AM, Rajan_Verma wrote: > >> *Thank You All, **J*** >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Brajesh Kum

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

contrats raj On Thu, Aug 4, 2011 at 11:18 AM, Rajan_Verma wrote: > *Thank You All, **J*** > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Brajesh Kumar Porwal > *Sent:* Thursday, August 04, 2011 10:23 AM > *To:* excel-macros@googlegroups

$$Excel-Macros$$ VBA Code to extract data in row

Hi , ** ** Can anyone suggest me VBA code to perform task as mentioned in the attached file. ** ** Regards, Raghavendra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Help with =now()

Hello Venkat Amazing :-) Wonder why I couldn't think of it earlier :-) Is the second part possible. For eg. In the same cell, I want the cell to display as "As on August 2011" (Where August 2011 will be obtained using the now() formula as described earlier and as you have suggested.. Thanks

Re: $$Excel-Macros$$ Subtract the minimum value based on multiple criteria

Dear Friend, You just need to use the following formula A B C D CityCarrier Total Diff Albertville A 700.00 In the D field type =C3-$C$3 and just copy and paste this to remaining below in the Diff field. Do revert for further clarification. Regards Mukesh Gupta On T

$$Excel-Macros$$ Help with =now()

Hello All, I am using Excel 2010 version and I need clarification w.r.t =now() function. In one cell, I can use the =now() to get August after formatting the cell under "Custom" and changing the Type to My query: 1. Can I get August 2011 (not just August-11 which can be obtained unde

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

*Hi **Charlie,* * * *Please try with some Others UserAccount Logins else Create a New Login Account and try...* * * *Best Regards,* *Venkat * *Chennai* On Fri, Aug 5, 2011 at 12:44 PM, Cab Boose wrote: > Hi Venkat > > Thanks for the reference. I was pretty sure that it would work. > Unfortuana

Re: $$Excel-Macros$$ VBA Code to consolidate all data in a cell

Hi Noorain, Can u please provide Formula for macro to consolidate multiple columns in to one cell as per the attached file. Regards Shiek On Thu, Aug 4, 2011 at 11:52 PM, NOORAIN ANSARI wrote: > Dear Raghavendra, > > Please use below code and see attached sheet... > > > Sub consolidate

Re: $$Excel-Macros$$ Excel test

which course u are talking about --- On Fri, 8/5/11, Venkat CV wrote: From: Venkat CV Subject: Re: $$Excel-Macros$$ Excel test To: excel-macros@googlegroups.com Date: Friday, August 5, 2011, 11:39 AM Hi xlstime,   Updated Excel test below...     Best Regards, Venkat  Chennai On Fri, Aug

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

Hi Venkat Thanks for the reference. I was pretty sure that it would work. Unfortuanately no. I still get the same message. Any other options ? I am sure we will find it eventually. Thanks Charlie On Fri, Aug 5, 2011 at 6:19 PM, Venkat CV wrote: > Hi, > > Look below links See if help