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, sourav devrani <
> souravdevrani
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
> wrote:
>
>> Is there any one who can solve this,
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 excel. Please help me in resolving this.
>>
>> Problem:
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
> revenue figures. I want to crea
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
revenue figures. I want to create another table wherein all the product
sales will be displayed from their first year. I have attached t
Dat's Cool Vaibhav. Thanks.
On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth
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, you will get r
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
>
>
> =T
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
=TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),
;
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> *From:* Gaurav Devrani
>
bruary 26, 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
all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Gaurav Devrani
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, February 26, 2015 10:12 AM
>
ong as ever you can.” - John Wesley
-
>
> From: Gaurav Devrani
>To: excel-macros@googlegroups.com
>Sent: Thursday, February 26, 2015 10:12 AM
>Subject: $$Excel-Macros$$ Please help me Urgent
>
>
>
>Hi Guys,
>
>
>
&
Hi Guys,
I have a query . In this sentence.. "This iS a tEst" .
All Upper case alphabets should be lower case and All Lowercase alphabets
should be in Upper case. Please help me . I want that to be done in excel
formulas.(If thats possible).
Thanks & Regards
Gaurav Devrani
--
Are you =EXP(E
Hi
I am not sure of this.
Thx
On Wed, Apr 30, 2014 at 3:34 PM, renuka chari 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 place.
>
> please su
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 b
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
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
> > wrote:
>
>> Dear sir,
>>
>> Thank you so
Dear sir,
Thank you so much for your time and effort into problem.
my dashboard having huge no of sheets and if i make pivot sheet then my
workbook size is increasing more i was applied your formula earlier itself.
but i need even better solution. and my dash board data range is not
constant i
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 wrote:
> Dear sir,
>
> i dont want to use pivot. i need only formula for offset or index is it
> possible...
>
> On Tuesday, 29 April 201
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
>fi
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 un
Dear experts,
please help me
Thanks & Regards´¨)
¸ •´ ¸.•*´¨) ¸.•*¨)
(¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable en
I am attaching a macro that I recorded. But I need the variables to be
updated
Basically this macro is going thru several tabs and update the pivot tables
by simply changing the dates.
So everytime I run the macro, I want dates in these pivot tables to be
updated to today.
Please look at t
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 wrote:
> Dear all
>
> Will you please help to get the formula
>
>
> for an example in attachment
@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://www.euritmicgrup.ro/> - Roma
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Constantin Zamfir
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 19 Oct 2012 10:35:38 -0700 (PDT)
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Pleas
Subject: $$Excel-Macros$$ Please help me to set default folder for print PDF's.
I have a macro in an Excel document that print 5 sheets in different
folders with different names. Always have to navigate to the desired folder
and write the desired name, which slows my work, since I'm doin
I have a macro in an Excel document that print 5 sheets in different
folders with different names. Always have to navigate to the desired folder
and write the desired name, which slows my work, since I'm doing this for
30-50 times per day.
I want to automate this in my macro, but I do not know
groups.com
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 wrote:
Dear Preavesh,
04 solutions of you. for any query please
Hi amresh,
Thanks! for help me
On 8/30/12, Amresh Maurya 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:
>
>> Hi Pra
Dear Pravesh,
Your most welcome.
Regards,
Kuldeep Singh
On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR wrote:
> Hi team,
>
>
> Thanks so much for help me and give best to best Suggestions
>
> Thanks
> Pravesh Kumar
>
>
> On 8/30/12, Kuldeep Singh wrote:
> > Dear Preavesh,
> >
> > 04 solutions
Hi team,
Thanks so much for help me and give best to best Suggestions
Thanks
Pravesh Kumar
On 8/30/12, Kuldeep Singh 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)
> =VLOOKUP(H3,$C$3:$D$9,2,0)
> =
KUMAR
Sent: Wednesday, August 29, 2012 11:30 PM
To: excel-macros ; excelvbaclinic
Subject: $$Excel-Macros$$ please help me to solve this question it's very
urgent
Hi Team,
please help me to solve this question it's very urgent
waiting your response
--
Thanks & Regards
Dear Pravesh,
Enclosed herewith your query solu
Regards,
Gawli Anil
On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh 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)
> =VLOOKUP(H3,$C$3:$D$9,2,0)
> =IF
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 wrote:
> Hi Praves
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
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 wrote:
> Hi Team,
>
> please help me to solve this question it's very urgent
>
>
> waiting your response
>
>
>
> --
>
> Thanks & Regards
>
> Prav
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 wrote:
> Hi Team,
>
> please help me to solve this question it's very urgent
>
>
> waiting your response
>
>
>
> --
>
>
Hi Team,
please help me to solve this question it's very urgent
waiting your response
--
Thanks & Regards
Pravesh Kumar
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurat
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 wrote:
> Dear Mangesh,
>
> To create this calendar in the range B2:H9, follow these steps:
>
>
> 1. Select B2:H2 and merge t
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.
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
Dear Manoj,
Calender in excel can be prepared by Array formula too, its purely full
array for whole the months and years.
=IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(C5),MONTH(C5),1
ros@googlegroups.com
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, 20
Dear Suman,
It is working fine with table, Pls see the attached sheet.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, Jul 11, 2012 at 1:43 PM, Suman wrote:
> Hi,
> Guru Ji,
> Its not working when i applying in table. Please guide...!!
>
> R
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" wrote:
> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01
Thanks Noorain Ji...
its working..
On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote:
> 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
> wrote:
>
>> Dear Expert.
>>
>> i have 2 Coll A1 & B2
>>
>> A
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 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
>
> --
>
Hi,
use below formula
=find(B1,A1)
Regards
Amresh
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 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+ members already
x27;" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent
x27;" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent
yes dilip, i guess u r right. i want the results as per the results
highlighted in red border. and hyperlink format in red font.
regards,
Avinash
On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey wrote:
> Hi Avinash,
>
> Not entirely getting your point.
> Please confirm if you need following <
Hi Avinash,
Not entirely getting your point.
Please confirm if you need following < which I can understand per your post> :)
1) Following results as per Date in first field < this you have
already attached>
DateTotal Product Actual PriceTotal Number Of ProductsGrand
Total She
11:40 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ PLEASE HELP ME
DEAR ALL MY EXCEL FRND.
PLEASE SEND SOME FORMULA FOR MEDAL TALLY & CHAMPIANSHIP
Chandra Singh Bohra
Champawat
Uttrakhand
--
FORUM RULES (934+ members already BANNED for violation)
1) Use con
Dear Friends
Thank your very much for your great reply.
may u define this formula. I can not find any source for *Groups* . I am
using that other place that function is not working.
Thanks again
Sanjay Kumar Maurya
On Thu, Aug 4, 2011 at 5:18 AM, XLS S wrote:
> Hey Sanjay
>
> Try to use In
Hey Sanjay
Try to use Indirect Functionplease find the attachment
On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya wrote:
> Dear Frd
>
> Thanks for your reply and solution but I have more data so pivot table
> is not possible for it. if u have any easy format please tell me.
>
> T
Dear Frd
Thanks for your reply and solution but I have more data so pivot table
is not possible for it. if u have any easy format please tell me.
Thanks
Sanjay Kumar Maurya
On 8/3/11, sreejith k.s wrote:
> hi Sanjay,
>
> just see whether this helps...i created a pivot according to my
> understa
Hi,
Please find the attached sheet with solution.
Thanks
Rupesh Kr.
On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:
> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
>
> --
> Some
hi Sanjay,
just see whether this helps...i created a pivot according to my
understanding of the quwestion...just get back to me if it is not enough
On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:
> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
>
> ---
see if it helps
On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:
> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TW
Hi frds
Please help me.
--
***Thanks
Sanjay Kumar Maurya*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Hi Sukumar,
I am not sure whether this is what you are looking for.. Have a look in the
attached file whether it suits your requirement.
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote:
> Hi,
>
> Students English maths sceience
hi sukumar,
please find attached.
regards,
saber
On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote:
> Hi,
>
> Students English maths sceience Grades
> suresha 45 80 90 90-100 A
> srinivas 25 36 60 80-90 b
>
Hi,
Students English maths sceience Grades
suresha 45 80 90 90-100 A
srinivas 25 36 60 80-90 b
sunyana 38 65 70 60-80c
sunitha 80 90 68 36-60
hi experts
please help me to get my requirements to maintain my drugdata.please find
the attachment.if it possible in excel please helpme.
thanx in advance.
regards
jasmin
--
--
Some important links for excel users
Dear Sudhir,
Just would like to mention that the cells should be in date format, only
then this function will work.
Regards,
Anubhav
On Wed, Jan 19, 2011 at 2:59 PM, Manoj kumar wrote:
> use either of them :-
>
> =(B1-A1)+1
> =DATEDIF(A1,B1,"d")+1
>
>
> Regards,
> Manoj Kumar
>
>
> On Wed, J
use either of them :-
=(B1-A1)+1
=DATEDIF(A1,B1,"d")+1
Regards,
Manoj Kumar
On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar wrote:
> Hi
>
> All Dear members
>
> Plz help on the following point.
>
> I want count no. of Days between two Dates.
>
> Example
>
> 1-12-10 31-12-10
Hi Sudhir,
PFA...
Regards,
Lucky
On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar wrote:
> Hi
>
> All Dear members
>
> Plz help on the following point.
>
> I want count no. of Days between two Dates.
>
> Example
>
> 1-12-10 31-12-1031
>
> thanx
>
>
> --
> Sudhir Verm
Hi
All Dear members
Plz help on the following point.
I want count no. of Days between two Dates.
Example
1-12-10 31-12-1031
thanx
--
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.
Thanks for ur support sumit.
Thanks,
Chandrabhan Singh
On Tue, May 11, 2010 at 7:19 PM, sumit kumar wrote:
> Dear Chandra
>
> here is the attached sheet probably you were looking for.
>
> Sumit
>
> On Tue, May 11, 2010 at 2:54 PM, Born to Win wrote:
>
>> Hi All,
>>
>> Please Help me its urge
can any one help me out i m waiting for your response ..otherwise i have to
apply these thing in all thousand company and its a time taking
On Wed, May 5, 2010 at 9:57 AM, Vikas Chouhan wrote:
> Harry..
>
>
> 2003 format
>
>
> On Tue, May 4, 2010 at 10:11 AM, Harpreet Singh Gujral <
> harpreetgu
Sidhantha,
Is it possible for you to provide Excel 2003 version
Harry
On May 3, 4:33 pm, sidhantha suchit wrote:
> hi
>
> attach one of the sheet and thereis 1000 of such kind of sheet were i have
> to do this wrk please help me.
> On Mon, May 3, 2010 at 9:36 AM, Rahul Gandhi. wrote:
>
>
>
>
>
Can you please give me the example so that we can atleast try to help
you out with query.
On May 2, 6:58 pm, sidhantha suchit wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know its my duty but can if any one he
Can you please give me the example so that we can atleast try to help
you out with query.
On May 2, 6:58 pm, sidhantha suchit wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know its my duty but can if any one he
Sidhantha,
I can give it a try, as i am also studying some things related to
Stock Market...
Let me know
Harry
On May 2, 6:58 pm, sidhantha suchit wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know it
hi
sir
I m new to this group right now i m doing a project on stock market and i
have to do lot of calculation ,I know its my duty but can if any one help me
its reduce my task because i have to apply in 1000 BSE listed company .
what i have to calculate
Volatility (daily)
Jump in script
Mean
R
Hi Sudhir,
Would it be possible for you to attach both the sheets, i will try to work
on it.
If possible, please specify which sheet would serve as the master against
which the other sheet will be compared.
Cheers!
Harry
On Tue, Apr 27, 2010 at 9:25 PM, sudhir kumar wrote:
> Thanks Harpreetj
Thanks Harpreetji, for your valuable solution
I have an another problem,
I have two excel sheets, both are having same format, and
contain huge
amount of data.
now i want to compare them, old one with the new one. and i want to
find out which data is deleted, which one is added, and w
Huh?
Date: Mon, 26 Apr 2010 21:18:44 -0700
Subject: $$Excel-Macros$$ please help me for Excel Conditional formula with
example
From: vikask...@gmail.com
To: excel-macros@googlegroups.com
Dear All,
Please help me for excel condition formula's, pls send formula with example
...pls
Dear All,
Please help me for excel condition formula's, pls send formula with example
...pls it's a urgent.
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_
Hi Sudhir,
Try this,,,
hope u r talking abut grouping and ungrouping
Rows("1:2").Select
Selection.Rows.Group
--- On Sat, 24/4/10, sudhir wrote:
From: sudhir
Subject: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide
the subheading in excel
To: "M
hi harpreet ji ,
thank u very much , thats the thing i want
--
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.com,
--
--
Some important links for exce
Dear friends,
I want a macro for hide and unhide the sub headings in excel, like we
can do in MS project with +mark, when we click on + symbol it
highlights the subtask available in that particular task.
Is it possible??., pleas help me
--
the contents meet the criteria.
>
> (if a1 > H1 then H1 = a1)
> (if a2 < H2 then H2 = a2)
>
> let me know if you need help with the change events.
>
> Paul
>
>
> From: Sach1810
> To: MS EXCEL AND VBA MACROS
> Sent: Fri, March 5, 2010 3:39:
events.
Paul
From: Sach1810
To: MS EXCEL AND VBA MACROS
Sent: Fri, March 5, 2010 3:39:40 AM
Subject: $$Excel-Macros$$ Please help me print a the highest number that
appears from a cell with continuously streaming data
Hi,
I have two cells lets say a1 and a2 b
Hello Dear
Have you Tried MAX()
Please let me know,if more help required.
Hope it will Help
Happy To Help
:)
Shyam
On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 wrote:
> Hi,
>
> I have two cells lets say a1 and a2 both of which are continually
> updating from a live feed. I would like to be abl
Can you send an example file ? That would help to understand better.
Thanks,
On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 wrote:
> Hi,
>
> I have two cells lets say a1 and a2 both of which are continually
> updating from a live feed. I would like to be able to track what the
> highest number of a1
Hi,
I have two cells lets say a1 and a2 both of which are continually
updating from a live feed. I would like to be able to track what the
highest number of a1 has been and what the lowest number of cell a2
has been.
Your help would be much appreciated as I am new to programming
Many Thanks
Sa
hi Subhash
where is file ?
On 01/02/2010, Dilip Pandey wrote:
> Hi Subhash,
>
> You have forgot to attach the files. Please attach the file and explain
> your query as well. Thanks.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B Com(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gm
Hi Subhash,
You have forgot to attach the files. Please attach the file and explain
your query as well. Thanks.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Mon, Feb 1, 2010 at 4:15 PM,
Dear All,
please give me count fourmula in thes sheet
--
Subhash
Pratham Mumbai Education Initiative
9870914252
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Dear Freinds,
please help me
i have a workbook in word there are many pages in workbook but i want Separate
workbook for every pages.
Regards
Amresh
--~--~-~--~~~---~--~~
-
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep http://groups.google.com/groups/unlock?hl=en&_done=/group/e
xcel-macros/browse_thread/thread/2c83a1e4f9fe5b55%3Fhl%3Den&
msg=3b640b5678417efb> @gmail.com> wrote:
> I Need to calculate the range as per the criteria
mentioned in attached
> file please
I Need to calculate the range as per the criteria mentioned in attached file
please help me.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Vid
Hi All,
I want to do conditional formatting on selected cells based on values
inserted in other cells.
I have explained the problem in attached excel. If you still have any query
let me know I will try to explain it again.
Thanks and Best regards,
Swapnil.
--~--~-~--~~~
Dear Friends,
I am looking for the use of “vlookup” function for getting the below
criteria
· To find the description & details from the database if I enter the
Iem code on the working sheet.
· Also cross check the location, because same item code has
different description accord
please help me with count function
--
Shay
A Thinker tends to use reason and logic
A feeler tends to use values and subjective Judgement.
Be a Thinker in Life.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.
I cannot use hyperlink in my pc, when I try to click the link computer
showing the following message.
*"the operation has been canceled due to restriction in effect on this
computer, Please contact your system administrator"*
I'm working on administrative mode. Please help me.
--
aJaY :) (R)™
98 matches
Mail list logo
