Dear Santosh,
Best Resource of Excel4 Function is :
*http://www.cpearson.com/excel/Call.htm*
On Tue, Jul 17, 2012 at 12:02 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Noorain,
>
> Thank you for your solution,yes it is working fine.
>
> Recently I have come with these funct
Pl share u r excel sheet to make us clear...
Regards,
Gawli Anil
On Tue, Jul 17, 2012 at 11:39 AM, NOORAIN ANSARI
wrote:
> Dear Hanumant,
>
> Please share your workbook with group.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> --
Dear Hanumant,
Please share your workbook with group.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
-- Forwarded message --
From: hanumant shinde
Date: Sat, Jul 14, 2012 at 1:36 AM
Subject: $$Excel-Macros$$ Error--Cant Exit Design M
Follow below forum Rule
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
On Tue, Jul 17, 2012 at 11:32 AM, NOORAIN ANSARI
wrote:
>
> On Mon, Jul 16, 2012 at 11:12 PM, sherry .. wrote:
>
>>
>>
>> *Hi,*
>>
>> *Hope you are doing great today..*
>>
>
Follow below forum Rule
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
On Mon, Jul 16, 2012 at 11:12 PM, sherry .. wrote:
>
>
> *Hi,*
>
> *Hope you are doing great today..*
>
> *Please find the updated hotlist of my consultants..*
>
> *Please s
Hi Sherry,
Please follow forum rule no. 5
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
On Mon, Jul 16, 2012 at 11:12 PM, sherry .. wrote:
>
>
> *Hi,*
>
> *Hope you are doing great today..*
>
> *Please find the updated hotlist of my consulta
Thanks a Ton Master :-)
Working fine !!
have a gud day!
JP.
On Tue, Jul 17, 2012 at 11:03 AM, NOORAIN ANSARI
wrote:
> Dear JP,
>
> Please use below formula for desired output.
>
> =CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM"))
>
> or
>
> =TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm
Dear JP,
Please use below formula for desired output.
*=CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM"))*
or
*=TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm:ss AM/PM")
*See attached sheet for reference.*
*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.bl
Dear Experts,
Good Morning...
Need your Help in formatting the Given Date in to customised format
per attachment...
Thanks in Advance!
JP.
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Ne
goto calculations field, then click on field items and set then click on
calculation field then click the dropdown button of Name field and click on
delete.
Regards,
Gawli Anil
On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay <> wrote:
> Please help me on below problem.
> Thanks
>
>
> On Mon, Jul
Dear Mangesh,
To create this calendar in the range B2:H9, follow these steps:
1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
Center.
2. Enter a date into the merged range. The day of the month isn’t important.
3. Enter the abbreviated day names in the range B3:H3.
STOP!!
"sherry .." wrote:
> *Hi,*
>
> *Hope you are doing great today..*
>
> *Please find the updated hotlist of my consultants..*
>
> *Please send the requirements to she...@nityainc.com or feel free to call
> me at 801-833-0416*
>
> * *
>
> *Consultant*
>
> *Technology*
>
> *Locat
Do as you like.
2012/7/17 Venkatesh Narla
> Hi,
> Please find the attachment and let me know.. any thing els need..
>
>
> Thanks,
> Venkatesh.
>
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay
> wrote:
> > Hi Friends,
> >
> > Please solve my VLookup Query.
> > Description is given in atta
Your question and title are contradicting.
Do you want to convert words to numbers, or vice versa?
Regards,
Sam Mathai Chacko
On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861 wrote:
> Dear All,
>
> Kindly help me to convert numbers in digits. I'll apply the formula
> "spellnums" but, I think
*Hi,*
*Hope you are doing great today..*
*Please find the updated hotlist of my consultants..*
*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*
* *
*Consultant*
*Technology*
*Location*
*Relocation*
*Karthik*
*Oracle apps Finance functional cons
*Hi,*
*Hope you are doing great today..*
*Please find the updated hotlist of my consultants..*
*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*
* *
*Consultant*
*Technology*
*Location*
*Relocation*
*Karthik*
*Oracle apps Finance functional cons
Hi,
Please find the attachment and let me know.. any thing els need..
Thanks,
Venkatesh.
On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> Please solve my VLookup Query.
> Description is given in attached file.
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM R
Hi All,
This is Venkatesh Narla i am 26 years old and worked as Release
manager in Accenture(Bangalore Location). Currently looking out for
new job. 5+ years in MIS. I am from Andhra Pradesh.
Thanks,
Venkatesh Narla.
On Mon, Jun 11, 2012 at 9:04 AM, Anand Kumar wrote:
> Hi,
>
> I am Anand Kum
Hi Ashish.
My name: Trần Văn Bé, of birth 1957, as state employees.
Form: Việt Nam
I love Excel and a member of the forum, when the new free visit, to exchange
knowledge and help other members on the board, I have participated
less frequently
for free time.
2012/7/16 kumar.ashish861
> Hi All,
>
Hi Prince,
Unfortunatelly I think as well that the macro is the only one solution for
this, but is outside of my confort zone.
Thanks anyway
Pawel
From: Prince Dubey
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Monday, July 16, 2012 5:21
Hi Santosh,
Please refer attach sheet it may help you.
Regards
Prince dubey
On Monday, 16 July 2012 14:52:01 UTC+5:30, santosh wrote:
>
> Hi Group,
>
> I want the list of all the sheet names available or to created in sheet1
> automatically via formula of a workbook *without a macro.*
>
> Thank
Joseph,
paste special is not workig as its refering to different sheet
Regards,
Pawel
From: "joseph.cam...@gmail.com"
To: excel-macros@googlegroups.com
Sent: Monday, July 16, 2012 3:41 PM
Subject: Re: $$Excel-Macros$$ copy color from cell base on conditi
Please help me on below problem.
Thanks
On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay wrote:
> Hi Noorain,
>
> If I have to delete some fields as below then How could I do this? Like
> Salary in Dollar, Field1, Avg Sal in $
> Please help.
> [image: Inline image 1]
>
>
> On Mon, Jul 16, 2012 at 6
Hi Pawel,
In case of conditional formatting we can not refer other sheet. So for this
problem you can use macro.
regards
prince dubey.
On Monday, 16 July 2012 20:08:57 UTC+5:30, lupinskip wrote:
>
> Hi All,
> I'd like to ask you for favour. I have an issue with copy of the colour
> from condit
Hi moderators,
Per rule please ban this user.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "sherry .."
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 21:24:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sherry's H
*Hi,*
*Hope you are doing great today..*
*Please find the updated hotlist of my consultants..*
*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*
* *
*Consultant*
*Technology*
*Location*
*Relocation*
*Karthik*
*Oracle apps Finance functional cons
You might try expanding column C to find out that that is NOT
true
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SG
Sent: Monday, July 16, 2012 10:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-
Yes, if you see..from row 12 to row 40, the data is blank..can it be
possible after running the macro...it would consolidated without such
blanks in the data??
On Monday, July 16, 2012 8:31:55 PM UTC+5:30, Don Guillett wrote:
>
>
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Soft
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SG
Sent: Monday, July 16, 2012 9:30 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning
Hi Don,
It's working perfectly.but one more problem is this i have shown only 3 column
I don’t understand. Look at before/after sheets to see what macro is doing.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SG
Sent: Monday, July 16, 2012 9:30 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning
Hi Don,
It'
Please try paste special format
Sent on my BlackBerry® from Vodafone
-Original Message-
From: pawel lupinski
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 07:38:57
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ copy col
Hi All,
I'd like to ask you for favour. I have an issue with copy of the colour from
condition formating to new place.
What I'd like to do is: copy values and colour to "Sheet2" cell B3 in the way
that I will have the value and the same colour.But the issue is colour can not
be base on conditio
Hi Don,
It's working perfectly.but one more problem is this i have shown only 3
columns in my sample file but in real ...i have atleast 23 columns & last
column is the Error column on which this macro will work...now this macro
is consolidating the data at the end.Please have a look.For instan
I wrote it to continue what you had already done. The TTC could be
incorporated.
Option explicit forces use of dim
Look in vba help index for resize
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SG
Sent: Monday, July 16, 2012 8:49 AM
To: excel-macros@googl
Dear Santosh,
I think it is not possible to get all the sheets name by using only formula.
Regards,
Lalit Mohan
On Mon, Jul 16, 2012 at 3:21 PM, NOORAIN ANSARI
wrote:
> Dear Santosh,
>
> Please create a name range with below formula..
>
> =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),""
Hi Mangesh,
If you want to learn how vlookup works may be below links helps you..
http://www.free-training-tutorial.com/function-vlookup.html
http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm
Regards,
Lalit Mohan
On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay wrote:
> Its r
Hi Don,
Thanks for the help. I haven't run the macro.I'm a begineer to the
macro.Can you please explain the "option Explicit" & use of "resize" &
would i run this macro after text to column splitting?
uillett wrote:
> Should do it
>
> Option Explicit
> Sub getlists()
> Dim lr As Long
> Di
Should do it
Option Explicit
Sub getlists()
Dim lr As Long
Dim i As Long
Dim dr As Long
Dim btc As Range
lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
Set btc = Cells(2, 1).Resize(lr, 2)
For i = 2 To lr + 1
dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
btc.Copy Cells(dr, 1)
Cells(2, i + 1).Resize(lr).
Hi Noorain,
If I have to delete some fields as below then How could I do this? Like
Salary in Dollar, Field1, Avg Sal in $
Please help.
[image: Inline image 1]
On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay wrote:
> Thanks a ton !!!
>
>
> On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI
> wrote:
Thanks a ton !!!
On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI wrote:
> Dear Manesh,
>
> As desired, Please find step by step screen shot with complete explanation
> as attachment.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mo
Hi Noorain.
Thanks but I do not understand how did you calculated the Average Salary
($) by using *calculated field*. Please provide me documentation so that I
could understand. I know it is time consuming job for you and really sorry
for that. But I dont have alternative. So please help me dear. S
Its really helpful.
U have done full R & D here.
Thanks lot.
On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI wrote:
> Dear Mangesh,
>
> You can also use..
>
> *=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)*
>
> or
>
> *=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))*
>
Hi Anil,
Thanks lot.
But I need to calculate the average($) by using Calculated Field option
given in Options ---> Formulas ---> calculated field.
Is it possible by using above method. Please let me know.
Thanks again.
On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli wrote:
> Pls find Attached sheet
Pls find Attached sheet ...Like this u want?
Regards,
Gawli Anil
On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help to solve my PT Problem.
> The description is given in sheet itself. Please FA.
>
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM
Dear Mangesh,
You can also use..
*=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)*
or
*=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))*
or
*=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)*
with ctrl+shift+Enter
See attached sheet.
--
Thanks & regard
Please tell us so that we can edit and learn it. How to make ?
calender_Simple.xls file
On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI
wrote:
> Dear Manoj,
>
> Please find attached simple Calender.
>
> You can create it simply.
>
> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar
> wrote:
>
>> De
so much
On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay wrote:
> Thank you much Suman
>
>
> On Mon, Jul 16, 2012 at 4:48 PM, Suman wrote:
>
>> Dear Mangesh,
>> Please find the attached file as I have learnt this one form Noorain sir
>> in this group.
>>
>> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh
Thank you much Suman
On Mon, Jul 16, 2012 at 4:48 PM, Suman wrote:
> Dear Mangesh,
> Please find the attached file as I have learnt this one form Noorain sir
> in this group.
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> Please solve my VLookup Query.
>> Descri
Hi Friends,
I need your help to solve my PT Problem.
The description is given in sheet itself. Please FA.
Thanks.
--
With regards,
MaNgEsH
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need H
Thanks Noorain it's working fine, thank for your valuable support.
On Mon, Jul 16, 2012 at 4:15 PM, Anil Gawli wrote:
> dear noorian
> Thanks Bro...
>
>
> Regards,
> Gawli Anil
>
> On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Anil Bro,
>>
>> Please right click on
Hi Friends,
Please solve my VLookup Query.
Description is given in attached file.
Thanks.
--
With regards,
MaNgEsH
--
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, Cod
[█ ▆ ▅ ▃ ▂★Great Noorain Sir★▂ ▃ ▅ ▆ █]
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Mon, Jul 16, 2012 at 4:21 PM, Manoj Kumar wrote:
> Dear K
Dear Kuldeep,
thanks..
I need function witch I already provide by Noorain...
On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh wrote:
>
> Hi,
>
> Use this
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the
dear noorian
Thanks Bro...
Regards,
Gawli Anil
On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI wrote:
> Dear Anil Bro,
>
> Please right click on Toolbox goto Additional Control and select Microsoft
> Date and Time Picker.
>
> see attached screenshot
>
> or
>
> if your system doesn't support Dat
Happy to Help
On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar wrote:
> Thanks Noorain Ji...
>
>
> On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Manoj,
>>
>> Please try it.
>>
>>
>> =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))
>>
>>
>> --
>> T
Thanks Noorain Ji...
On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI wrote:
> Dear Manoj,
>
> Please try it.
>
>
> =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.
Dear Manoj,
Please try it.
=INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar wrote:
> Dear Expert,
>
> Please help me to ma
Hi All,
My Name is Ganesh from India - Chennai, I am working with Inscribe - BPO
for last 7 years as a Project Leader. In our office most the works
processed by ms excel, so it is most important to our daily work. Mr Ashish
referred to join this forum and it was more useful and reduced our rou
Dear Santosh,
Please create a name range with below formula..
*=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")*
and use below formula to extract sheet name in column A.
*
=IF(ROWS($A$2:A2<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"")
*
See attached sheet for
hi santosh,
PFA below vbacode to findout the sheetsname.
Sub sheets_nm()
Dim sh As Worksheet
Dim i As Integer, k As Integer
Set sh = ThisWorkbook.Sheets("sheet1")
For i = 1 To Sheets.Count
k = Range("a5").End(xlUp).Row + 1
sh.Cells(k, 1) = Sheets(i).Name
Next
End Sub
Regards,
excelvb
dear noorian
How u add the Dt picker in user form... pls let me know..
Regards
Gawli Anil
On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI wrote:
> Dear DS,
>
> Please try it..
>
> *Private Sub CommandButton1_Click()
> Dim i As Integer
> Dim dt As Date
> i = Cells(Rows.Count, "A").End(xlUp).Row
Dear DS,
Please try it..
*Private Sub CommandButton1_Click()
Dim i As Integer
Dim dt As Date
i = Cells(Rows.Count, "A").End(xlUp).Row + 1
dt = Me.DTPicker1
With Application.WorksheetFunction
If .WeekNum(dt) > (.WeekNum(Date) - 1) Then
Cells(i, 1) = Me.DTPicker1.Value
Else
MsgBox "Restricted Last
Hi Group,
I want the list of all the sheet names available or to created in sheet1
automatically via formula of a workbook *without a macro.*
Thanks & Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem
is this that the data is in thousandsr rows & manually it takes so much
time.i have attached a file & i hope it clears the doubts brfore cleaning
the data & after cleaning the data.
On Friday, July 13, 2012 5:33:35 PM U
Dear Dhartikumar
Pls share us with some data.
Regards,
Gawli Anil
On Mon, Jul 16, 2012 at 12:46 PM, Dhartikumar Sahu <> wrote:
> awaiting for reply..
>
>
> -- Forwarded message --
> From: Dhartikumar Sahu
> Date: Mon, Jul 16, 2012 at 10:18 AM
> Subject: $$Excel-Macros$
Dear Hemant,
Lalit solution is nice
You can also check..
http://www.ozgrid.com/forum/showthread.php?t=58969
On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba wrote:
> Hi Group,
>
>
> How can i declare a global variable for below mentioned.
>
>
>
> Private sub abc()
> dim sh as worksheet
> dim rng as r
66 matches
Mail list logo
