Thanksa ton Sourav. You kind help is highly appreciated.
On Wed, Aug 3, 2016 at 7:46 PM, sourav devrani
wrote:
> please use this file.
> i have change some little formula here you can use this file.
>
> Regards
> Sourav Devrani
>
> On Wed, Aug 3, 2016 at 7:10 AM,
please use this file.
i have change some little formula here you can use this file.
Regards
Sourav Devrani
On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani
wrote:
> please see the attached file.
>
> On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman
please see the attached file.
On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman
wrote:
> Is there any one who can solve this, please ?
>
> On Aug 2, 2016 23:38, "Jayanta Barman" wrote:
>
>> Hello Excel experts,
>>
>> I have a small problem in
Is there any one who can solve this, please ?
On Aug 2, 2016 23:38, "Jayanta Barman" wrote:
> Hello Excel experts,
>
> I have a small problem in excel. Please help me in resolving this.
>
> Problem: I have a set of products launched at different years with their
>
hi,
How i disable cut and paste in word 2007 file.
On Mon, Jun 8, 2015 at 9:25 AM, Kumar Bhanushali
kumar.bhanush...@pmcprojects.com wrote:
*Dear Sir,*
In attached file, Basic sheet is there. In that sheet I had created 4
buttons, Namely, For RA, For Adhoc, Above, Below.
With which macro
as per your requirement
On Fri, May 29, 2015 at 11:25 AM, Titu Sharma niks...@gmail.com wrote:
how can you have bundle of 150, this should be bundle of 50 i think...
On Fri, May 29, 2015 at 11:12 AM, Rashi Singh rashising...@gmail.com
wrote:
Yes Yes, Actually Say i have to give Rs. 2250 to
Ok I have only assume that there is 150, Ok no problem lest 50 Rs. Now my
query is Distribute 100 and 50 to make total amount of Rs. 2250.
Thanks for your revert.
On Fri, May 29, 2015 at 11:25 AM, Titu Sharma niks...@gmail.com wrote:
how can you have bundle of 150, this should be bundle of 50
Thank you so much, those result are as i expected. Thank you so much.
I will study this formula, since i new to excel formulas.
Regards,
Rashi
On Fri, May 29, 2015 at 11:31 AM, Titu Sharma niks...@gmail.com wrote:
as per your requirement
On Fri, May 29, 2015 at 11:25 AM, Titu Sharma
updated as per 50
On Fri, May 29, 2015 at 11:31 AM, Titu Sharma niks...@gmail.com wrote:
as per your requirement
On Fri, May 29, 2015 at 11:25 AM, Titu Sharma niks...@gmail.com wrote:
how can you have bundle of 150, this should be bundle of 50 i think...
On Fri, May 29, 2015 at 11:12 AM,
you are welcome
On Fri, May 29, 2015 at 11:36 AM, Rashi Singh rashising...@gmail.com
wrote:
Thank you so much, those result are as i expected. Thank you so much.
I will study this formula, since i new to excel formulas.
Regards,
Rashi
On Fri, May 29, 2015 at 11:31 AM, Titu Sharma
What's your criteria for how many 100 or 150 you can use.
On Fri, May 29, 2015 at 10:04 AM, Rashi Singh rashising...@gmail.com
wrote:
Dear all,
Please help in enclosed problem solution. i have tried many and even
googled, but i am unable to create formula. Have exlplained xl sheet,
please
how can you have bundle of 150, this should be bundle of 50 i think...
On Fri, May 29, 2015 at 11:12 AM, Rashi Singh rashising...@gmail.com
wrote:
Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my
drawer box, i have bundle of Rs. 100 and Rs. 150 (Assume).
Now How many
please explain your query
On Fri, May 29, 2015 at 10:04 AM, Rashi Singh rashising...@gmail.com
wrote:
Dear all,
Please help in enclosed problem solution. i have tried many and even
googled, but i am unable to create formula. Have exlplained xl sheet,
please find.
Regards,
Rashi
--
Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my
drawer box, i have bundle of Rs. 100 and Rs. 150 (Assume).
Now How many Rs 100 have to take out from my drawer and Rs. 150 from my
drawer. to equivalent Rs. 2250.
Hope i could able to explain my query ! Thanks in advance
What did you search for online? I searched for:excel activex cannot insert
object and received 50,400 hits. many relate to an issue I encountered also. It
relates to an update Excel published that creates or modifies a file called:
MSForms.exd I usually search the C:\ drive for MSForms.exd and
Dat's Cool Vaibhav. Thanks.
On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth michaelvino...@gmail.com
wrote:
Very Nice... Mr.Vabz
On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote:
Suppose you have value in cell A1 then type follo. formula in A2 dont
press enter press F9,
Very Nice... Mr.Vabz
On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote:
Suppose you have value in cell A1 then type follo. formula in A2 dont
press enter press F9, you will get result in curly bracket, after = sign
enter CONCATENATE( press enter to get result
Suppose you have value in cell A1 then type follo. formula in A2 dont
press enter press F9, you will get result in curly bracket, after = sign
enter CONCATENATE( press enter to get result
,To all the people
you can,As long as ever you can.” - John Wesley*
-
*From:* Gaurav Devrani gauravdev1...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thursday, February 26, 2015 11:55 AM
*Subject:* Re: $$Excel-Macros$$ Please help me Urgent
I don't believe you'll be able to do that with standard Excel functions.
you can create a CUSTOM function using VBA and use it like an Excel function.
In your case, you need to process each character and switch the case.
the problem is, within a standard Excel function, there's no way to process
Thanks Paul for your quick reply. Yes I was also trying to create a macro
but Just wanted to confirm before, if that's possible in excel functions.
No worries. I really appreciate your quick response once again. Thank you.
Regards
Gaurav Devrani
On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner
, 2015 11:55 AM
Subject: Re: $$Excel-Macros$$ Please help me Urgent
Thanks Paul for your quick reply. Yes I was also trying to create a macro but
Just wanted to confirm before, if that's possible in excel functions. No
worries. I really appreciate your quick response once again. Thank you
Hi ivavok ,
Please find the attached file as per your requirement...
On Fri, Oct 24, 2014 at 5:31 PM, ivavok ivana.vokrouhlik...@gmail.com wrote:
Hello,
I would be grateful for help. I have had some break using VBA and I now need
to get the table attached adjusted in a certain way
Hi pramodb35,
Thank you very much for your help! It is almost perfect;)
Please have a look at the file attached. I have tried it for more rows for
each type and it does not work correctly in that case:( The type is then
not correctly copied in each row of column type. I cannot figure out what
Dear Ganesh Ravinder,
I am also have this issue.
I saw your attachments, i don't know how to use this...
Kindly give a brief explanation.
On Sun, Apr 27, 2014 at 11:48 AM, Ganesh N ganeshg...@gmail.com wrote:
Hi Yadav,
you can also use this. Just put the data files in separate folder
Dear Sir thanks alot...
i have a one doubt i.e my client places they are using Lotus note we are
used to send this dashboard to my client place is this macro would be work
on that place.
please suggest.
On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote:
Hi
You can do so by
Hi
I am not sure of this.
Thx
On Wed, Apr 30, 2014 at 3:34 PM, renuka chari jva.ch...@gmail.com wrote:
Dear Sir thanks alot...
i have a one doubt i.e my client places they are using Lotus note we are
used to send this dashboard to my client place is this macro would be work
on that
Dear sir,
i dont want to use pivot. i need only formula for offset or index is it
possible...
On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
Hi
You can do using Pivot Table, see attached file.
1. In the Pivot Table, click the drop down arrow in the RowLabels
field
Its not possible to do without any help column.
Another way out is shown in attached file. Ref col E F.
Thx
On Tue, Apr 29, 2014 at 2:34 PM, renuka chari jva.ch...@gmail.com wrote:
Dear sir,
i dont want to use pivot. i need only formula for offset or index is it
possible...
On Tuesday,
Dear sir,
thank you so much.your given a great help..
On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
Hi
PFA alternate method using formula help sheet.
Thanks
On Tue, Apr 29, 2014 at 8:57 PM, renuka chari jva@gmail.comjavascript:
wrote:
Dear sir,
Dear Sir,
countif function creating more violation for huge data range. is there any
possible to overcome or use any other function.
please guide me...
thanks...
On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote:
Dear sir,
thank you so much.your
Hi
You can do using Pivot Table, see attached file.
1. In the Pivot Table, click the drop down arrow in the RowLabels field
heading.
2. In the pop-up menu, click Value Filters, then click Top 10 change
it to 5.
You can sort on Descending on Output by going thru More Sort option
Hi Yadav,
you can also use this. Just put the data files in separate folder and put
the path in cell J2.
Thanks Regards,
Ganesh N
On Sun, Apr 27, 2014 at 11:16 AM, Vaibhav Joshi v...@vabs.in wrote:
Hi,
You can try this excellent codes share by Ashish earlier this month:
Sub merge()
Please see below link for your query.. u just need to select folder where u
have saved the files. please dont save example file in data files folder
http://excelvbasupport.com/forum/showthread.php?tid=17
On Sat, Apr 26, 2014 at 11:18 PM, Ganesh N ganeshg...@gmail.com wrote:
Hi Yadav,
you
Hi,
You can try this excellent codes share by Ashish earlier this month:
Sub merge()
Dim fld As Object, fil As Object, fso As Object, fldpath
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = Choose the folder
.Show
End With
On Error Resume Next
also try with CSE
=MAX(IF($B$2:$B$1944=H2,$D$2:$D$1944))
On Thu, Jan 30, 2014 at 11:56 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Well done Ravindre, Thanks
On Thu, Jan 30, 2014 at 11:59 AM, Ravinder
ravinderexcelgr...@gmail.comwrote:
=TEXT(MAX((H2=$B$2:$B$1944)*$D$2:$D$1944),MM/DD/ H:MM) with CSE
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh kumar
Sent: Thursday, January 30, 2014 11:37 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please Help
Dear
Well done Ravindre, Thanks
On Thu, Jan 30, 2014 at 11:59 AM, Ravinder ravinderexcelgr...@gmail.comwrote:
=TEXT(MAX((H2=$B$2:$B$1944)*$D$2:$D$1944),MM/DD/ H:MM) with CSE
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar
*Sent:*
In your script, you have a line:
FileName = Dir(CurrDir *.*, vbDirectory)
This basically creates a collection of information from CurrDir.
vbDirectory indicates that it is to return directories or folders in addition
to files with no attributes.
the statement itself returns the first entry in
Hi Paul,
Thank you very much. It solved my query. [?]
Regard,
Maksood Alam
On Thu, Dec 5, 2013 at 5:59 PM, Paul Schreiner schreiner_p...@att.netwrote:
In your script, you have a line:
FileName = Dir(CurrDir *.*, vbDirectory)
This basically creates a collection of information from CurrDir.
Hi,
Please find attached solution
Hope its fulfill ur requirement
*Thanks Regards,*
*Santy*
On Sat, Jul 20, 2013 at 7:38 PM, Sanjay Kumar Maurya
mail2sanja...@gmail.com wrote:
Hi All,
I have attached a file in this email.
This is record of incidents that's updated on daily basis.
ratio just change the calculation in formula.
Thanks
Ravinder
--- On *Tue, 6/4/13, Bé Trần Văn betnmtdongna...@gmail.com* wrote:
From: Bé Trần Văn betnmtdongna...@gmail.com
Subject: Re: $$Excel-Macros$$ Please help Excel Gurus
To: excel-macros@googlegroups.com
Date: Tuesday, June 4, 2013
Respected Harish,
On what ratio do you want to distribute the amount based on the date.what
are the specific criteria for distributing.
Regards,
VIJAYKUMAR
On Tue, Jun 4, 2013 at 9:22 AM, Harish P Y py.har...@gmail.com wrote:
Hi Every One,
Please find the attached file,
Kindly help me with
Formula Cell G5
=$F5/($E$5-$D$5)
Fill down and fill right
2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.com
Respected Harish,
On what ratio do you want to distribute the amount based on the date.what
are the specific criteria for distributing.
Regards,
VIJAYKUMAR
On Tue, Jun 4, 2013 at
Dear Vijay ,
I want to distribute it on per day basis.
Regards
Harish
With Regards
*HARISH P Y*
*P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think whether
it is really necessary. Thanks for your support to protect our environment
for the future generation*
*1 ream of paper =
Dear GRKNAIDU,
Please use this formula in the Bonus Qty column and copy down:
=IF(MOD(J4,100)=0,(J4/100)*20,ROUNDDOWN(J4/100,0)*20)
Regards,
Aindril
On Sat, Mar 2, 2013 at 5:33 PM, GRKRISHNA NAIDU grnaidu1...@gmail.comwrote:
Dear all
Will you please help to get the formula
for an
Hi Karthik,
Please check if this your requirement,
Regards,
Jaysheel
On Wed, Jan 9, 2013 at 8:07 PM, karthik N n.karthi...@gmail.com wrote:
Dear Help
Please help for below attached file.
--
*Regards*
--
Join official Facebook page of this forum @
Hi Jayseel,
Thank you for your replay,
But i needed the In between Two difference date Hour min
Thanks
Karthik.N
On Wed, Jan 9, 2013 at 8:17 PM, Jaysheel Bhasme jaysheel...@gmail.comwrote:
Hi Karthik,
Please check if this your requirement,
Regards,
Jaysheel
On Wed, Jan 9, 2013 at
Your question is not that clear can you show an example about your
requirement.
if your looking for the difference then why don't you use Next activity -
Last activity
On Wed, Jan 9, 2013 at 8:23 PM, karthik N n.karthi...@gmail.com wrote:
Hi Jayseel,
Thank you for your replay,
But i
Glad it worked for you.
On Tuesday, November 20, 2012 1:29:45 PM UTC-5, Mangesh wrote:
Thank you so much Natron.
You have made my work very easy.
Thanks again.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
See attached, with the code I used below...there are many other ways to do
this.
'This is hooked to your Export Specific Data Button on your form
Private Sub cmdExport_Click()
Dim intStart As Integer, intEnd As Integer
On Error GoTo whoops
intStart = Me.txtStart
intEnd = Me.txtEnd
Thank you so much Natron.
You have made my work very easy.
Thanks again.
On Tue, Nov 20, 2012 at 6:35 PM, Natron protoc...@gmail.com wrote:
See attached, with the code I used below...there are many other ways to do
this.
'This is hooked to your Export Specific Data Button on your form
-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help me to set default folder for print
PDF's.
Yes, but in the combobox Save as type: I don't have PDF format.
Best regards,
*Constantin ZAMFIR*
Service engineer,
Euritmic Grup SRL http
Hi,
Insted of printing with the help of Nitro PDF you can save file as PDF.
Rgds//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Constantin Zamfir costel...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 10:35:38
To:
Yes, but in the combobox Save as type: I don't have PDF format.
Best regards,
*Constantin ZAMFIR*
Service engineer,
Euritmic Grup SRL http://www.euritmicgrup.ro/ - Romania
Mobil: +40 741-105-012 (Orange)
Mobil: +40 726-226-021 (Cosmote)
*Before printing this e-mail please consider environment
No idea abt this Vist below links . See if they are useful
http://www.sqaforums.com/showflat.php?Number=431568
http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/ActiveX-component-can-t-create-object-TDApiOle80-TDConnection/td-p/4742677#.UHRUTZjMhc0
On Tue, Oct 9, 2012 at 10:13 PM,
Dear Don Guillett,
Thanking you for your kind assistance and help.
Really appreciated.
On Sat, Sep 15, 2012 at 7:01 PM, dguillett1 dguille...@gmail.com wrote:
Is the attached what you want for the SECOND line
Don Guillett
Microsoft Excel Developer
SalesAid Software
$3))*((cold=$M$4)+(cold=$N$4)+(cold=$O$4))*cole)
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Karan Singh
Sent: Friday, September 07, 2012 12:12 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please Help
Hi Jeet,
I think you're
I did NOT look at your attachment because you did not provide a meaningful
subject line in your post and you did not explain your problem in the body of
the email. I hope you explained, with examples, in the file. But, I didn’t look.
Don Guillett
Microsoft Excel Developer
SalesAid Software
you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, September 6, 2012 8:37:44 AM
Subject: Re: $$Excel-Macros
well said. Hopefully these messages will do some good??
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Thursday, September 06, 2012 7:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please Help
Don,
I did (look
Same as don
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 06 September 2012 6:08
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please Help
I did NOT look
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *dguillett1
*Sent:* 06 September 2012 6:08
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Please Help
** **
I did NOT look at your attachment because you did not provide a
meaningful subject line in your post
Hi team,
Thanks so much for help me and give best to best Suggestions
Thanks
Pravesh Kumar
On 8/30/12, Kuldeep Singh naukrikuld...@gmail.com wrote:
Dear Preavesh,
04 solutions of you. for any query please see attachment.
=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
Dear Pravesh,
Your most welcome.
Regards,
Kuldeep Singh
On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
Hi team,
Thanks so much for help me and give best to best Suggestions
Thanks
Pravesh Kumar
On 8/30/12, Kuldeep Singh naukrikuld...@gmail.com wrote:
Hi amresh,
Thanks! for help me
On 8/30/12, Amresh Maurya amreshkushw...@gmail.com wrote:
Hi Pravesh,
Find the attached solved file.
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
Reagrds
Amresh
On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish
vaishpriyanka2...@gmail.com wrote:
Subject: Re: $$Excel-Macros$$ please help me to solve this question it's
very urgent
Hi team,
Thanks so much for help me and give best to best Suggestions
Thanks
Pravesh Kumar
On 8/30/12, Kuldeep Singh naukrikuld...@gmail.com wrote:
Dear Preavesh,
04 solutions of you. for any query please
Hi Noorin
what is logic of last number 4 in formula if I change it nothing change in
output
={INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),),ROW(B1))-4)}
I used excel 2003 so I changed formula like this Pl tell me logic of number
4 in last
On Tue, Aug 28, 2012 at 10:16 PM, maksood
I see you have answers but why is YOUR request more URGENT than any other?
Also, use a meaningful subject line and explain your question in the email
and in the file.
etc.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: PRAVESH
Dear Amar,
We are using No. 4 for row no., If you go through attachment, table start
from row no. 5, row no.4 is heading so, we deduct above all row Number
including header. so we are using 4 because we are deduction 4 row no.
Hope my explanation will help you.
On Thu, Aug 30, 2012 at 5:16
Mr. Pravesh
See the attached file and kindly refer the forum rules, the subject line
must be clear regarding your query
Ashish
On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
Hi Team,
please help me to solve this question it's very urgent
waiting your
Hi Pravesh,
=VLOOKUP($H3,$C$3:$D$9,2,0)
I think this formula would solve your question.
On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
Hi Team,
please help me to solve this question it's very urgent
waiting your response
--
Thanks
Hi Pravesh,
Find the attached solved file.
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
Reagrds
Amresh
On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish
vaishpriyanka2...@gmail.com wrote:
Hi Pravesh,
=VLOOKUP($H3,$C$3:$D$9,2,0)
I think this formula would solve your
Dear Preavesh,
04 solutions of you. for any query please see attachment.
=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
=VLOOKUP(H3,$C$3:$D$9,2,0)
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
Regards,
Kuldeep Singh
On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
Dear Pravesh,
Enclosed herewith your query solu
Regards,
Gawli Anil
On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Dear Preavesh,
04 solutions of you. for any query please see attachment.
=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
can you send us the attachment
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.com wrote:
Hi experts,
I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
B). In 2nd sheet i want a formula if i enter 20 its should show me the name
of all the
cannot send any attchment due to system restrictions.
On Tue, Aug 28, 2012 at 8:20 PM, ashish koul koul.ash...@gmail.com wrote:
can you send us the attachment
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.comwrote:
Hi experts,
I have data in once sheet in two colums like
Dear Maksood,
Please try it..
=IFERROR(INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),),ROW(B1))-4),--)
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.com wrote:
Hi experts,
I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
B). In 2nd
See attachment for more clarity
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.com wrote:
Hi experts,
I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
B). In 2nd sheet i want a formula if i enter 20 its should show me the name
of all the
Thanks Noorain bhai.. its solved my qurey..
On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
See attachment for more clarity
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.comwrote:
Hi experts,
I have data in once sheet in two colums like
the people you can,
As long as ever you can.” - John Wesley
-
From: David Grugeon da...@grugeon.com.au
To: excel-macros@googlegroups.com
Sent: Wed, August 15, 2012 3:06:05 AM
Subject: Re: $$Excel-Macros$$ Please help (Word
Hi Paul
I try to avoid putting chunks of text in merged cells (if possible) because
the cell does not adjust its height so you can easily end up with text
which is hidden and may be important. I know you can kludge this by having
a copy of the cell off to the right made the same width as the
Now I understand why the first requirement was first. This is a fair
implementation of that requirement IMHO.
Some weird things seem to happen if you edit a line after it has been
wrapped. That may not be an issue for MM.
I still think Excel is not cut out to be a word processor and for dealing
What is your issue.? Please explain
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please
I want word wrap option to be active in excel - its effect should be
like this.
Condition 1 : the word / font train should not cross the page break
line.
Condition 2 : on the completion of one line the font should adjust the
line previous and jump to the another cell or row to
Dear Manoj,
Please see attached sheet, Change range as per State Name
Hope it help to you.
On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji.
I need 1st,2nd and 3rd Max sealing model name in every state...
Regard
Manoj
On Fri, Jul 20, 2012
Dear Manoj,
Please see attachment without Array Function.
On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji,
Thanks for reply
Your formula is correct but can you do it without Erry..
Regard
Manoj
On Fri, Jul 20, 2012 at 4:08 PM, NOORAIN
Manoj Please change reference of range, As per need otherwise it will show
same result.
On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji,
when i drag this formula it show same result...
On Fri, Jul 20, 2012 at 5:52 PM, NOORAIN ANSARI
Dear Manoj,
Need more clarification..
What is criteria of Model1,Model2,Model3
Please explain
On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert,
Please help me
Query file attached with mail...
Regard
Manoj
--
--
FORUM RULES (986+
Thanks Deba. Its very nice even before using it I never know that Excel
could do all these stuff so nicely.
Thanks again Dear.
On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan drdeva...@gmail.com wrote:
Dear Mangesh,
To create this calendar in the range B2:H9, follow these steps:
1. Select
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
noorain.ans...@gmail.comwrote:
Dear Manoj,
Please find attached simple Calender.
You can create it simply.
On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar
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.
Hi,
use below formula
=find(B1,A1)
Regards
Amresh
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote:
Dear Expert.
i have 2 Coll A1 B2
A1 Contain (Foto Fast Elec)
B1 Contain (Fast)
I want khow B1 is in A1 or not...
Regard
Manoj
--
FORUM RULES (986+
Dear Manoj,
You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found)
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert.
i have 2 Coll A1 B2
A1 Contain (Foto Fast Elec)
B1 Contain (Fast)
I want khow B1 is in A1 or not...
Regard
Thanks Noorain Ji...
its working..
On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Manoj,
You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found)
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar
kumarmanoj.11...@gmail.comwrote:
Dear
Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!
Regards,
@Suman
Send on the move with Galexy y.
On Jul 11, 2012 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Manoj,
You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found)
On Wed, Jul 11,
Subject: Re: $$Excel-Macros$$ Please help me.
Dear Suman,
It is working fine with table, Pls see the attached sheet.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
http://www.excelmacroworld.blogspot.com www.excelmacroworld.blogspot.com
On Wed, Jul 11, 2012 at 1:43 PM, Suman
Dear Mangesh,
Please use it..
=TEXT(B2-A2,[H]:mm:ss)
On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
I need diff in between these two dates in Hours
Start Date End Date
4/1/2012 5:01 4/3/2012 6:15
Whatever the diff in between these two dats in terms of
Thanks Noorain
On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Mangesh,
Please use it..
=TEXT(B2-A2,[H]:mm:ss)
On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay
mangesh.da...@gmail.comwrote:
I need diff in between these two dates in Hours
Start Date End Date
4/1/2012
Hi Suyog,
I have used the name ranges in the sheet.
If function starts with logical reason, to view the name ranges press
CTRL+F3
So I have defined each logic a diffrent name like criteria 2 ,criteria3
like that
Hope I have cleared you doubt, if you still have any queries please feel
free to
1 - 100 of 216 matches
Mail list logo