Re: $$Excel-Macros$$ Please help me

2016-08-04 Thread Jayanta Barman
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,

Re: $$Excel-Macros$$ Please help me

2016-08-03 Thread sourav devrani
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

Re: $$Excel-Macros$$ Please help me

2016-08-03 Thread sourav devrani
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

Re: $$Excel-Macros$$ Please help me

2016-08-03 Thread Jayanta Barman
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 >

$$Excel-Macros$$ Please help me

2016-08-02 Thread Jayanta Barman
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

Re: $$Excel-Macros$$ Please help me Urgent

2015-03-12 Thread Gaurav Devrani
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,

Re: $$Excel-Macros$$ Please help me Urgent

2015-03-11 Thread Michael Vinoth
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

Re: $$Excel-Macros$$ Please help me Urgent

2015-03-11 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-27 Thread Gaurav Devrani
,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

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Paul Schreiner
- From: Gaurav Devrani gauravdev1...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, February 26, 2015 10:12 AM Subject: $$Excel-Macros$$ Please help me Urgent Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Gaurav Devrani
Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, February 26, 2015 10:12 AM *Subject:* $$Excel-Macros$$ Please help me Urgent Hi Guys, I have a query . In this sentence.. This iS a tEst

$$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Gaurav Devrani
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

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread 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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-30 Thread renuka chari
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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-30 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-29 Thread renuka chari
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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-29 Thread Vaibhav Joshi
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,

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-29 Thread renuka chari
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,

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-29 Thread renuka chari
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

$$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-28 Thread Renukachari Kasee
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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-28 Thread Vaibhav Joshi
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

$$Excel-Macros$$ Please help me adding variables to my macro

2013-06-05 Thread Mccue
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

Re: $$Excel-Macros$$ please help me GRK

2013-03-02 Thread Aindril De
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

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

2012-10-20 Thread vba
-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

$$Excel-Macros$$ Please help me to set default folder for print PDF's.

2012-10-19 Thread Constantin Zamfir
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

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

2012-10-19 Thread vba
@googlegroups.com Reply-To: excel-macros@googlegroups.com 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

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

2012-10-19 Thread Constantin Zamfir
-- *From: * Constantin Zamfir costel...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Fri, 19 Oct 2012 10:35:38 -0700 (PDT) *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Please help me to set default

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread PRAVESH KUMAR
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)

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread Kuldeep Singh
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:

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread PRAVESH KUMAR
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:

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread dguillett1
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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-30 Thread dguillett1
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 Pravesh Kumar

$$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread PRAVESH KUMAR
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,

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Ashish Bhalara
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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Priyanka Vaish
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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Amresh Maurya
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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Kuldeep Singh
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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread अनिल नारायण गवली
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)

Re: $$Excel-Macros$$ Please help me.

2012-07-17 Thread Mangesh Vimay
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

Re: $$Excel-Macros$$ Please help me.

2012-07-16 Thread Mangesh Vimay
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

Re: $$Excel-Macros$$ Please help me.

2012-07-16 Thread Deba Ranjan
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.

Re: $$Excel-Macros$$ Please help me.

2012-07-11 Thread Amresh Maurya
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+

Re: $$Excel-Macros$$ Please help me.

2012-07-11 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Please help me.

2012-07-11 Thread Manoj Kumar
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

Re: $$Excel-Macros$$ Please help me.

2012-07-11 Thread Suman
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,

RE: $$Excel-Macros$$ Please help me.

2012-07-11 Thread Rajan_Verma
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

$$Excel-Macros$$ Please Help me to create summary and Macro.

2012-02-01 Thread Avinash Patil
, January 27, 2012 7:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help me to create summary and Macro. Hi Experts, i am currently facing very serious problem cuz every day i have to generate data from various workbooks wich is bassed on the daily reports. and i have

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

2012-01-29 Thread Avinash Patil
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 dilipan...@gmail.com wrote: Hi Avinash, Not entirely getting your point. Please confirm if you

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

2012-01-28 Thread Dilip Pandey
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 Sheet

Re: $$Excel-Macros$$ PLEASE HELP ME

2011-12-10 Thread dguillett1
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 concise

$$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread Sanjay Maurya
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

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread ashish koul
see if it helps On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya mail2sanja...@gmail.comwrote: Hi frds Please help me. -- ***Thanks Sanjay Kumar Maurya* -- -- Some important links for excel users: 1.

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread sreejith k.s
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 mail2sanja...@gmail.comwrote: Hi frds Please help me. -- ***Thanks Sanjay Kumar Maurya* --

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread Rupesh Shrivastava
Hi, Please find the attached sheet with solution. Thanks Rupesh Kr. On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya mail2sanja...@gmail.comwrote: Hi frds Please help me. -- ***Thanks Sanjay Kumar Maurya* --

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread Sanjay Maurya
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 sreejith.ks1...@gmail.com wrote: hi Sanjay, just see whether this helps...i created a pivot

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread XLS S
Hey Sanjay Try to use Indirect Functionplease find the attachment On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya mail2sanja...@gmail.com 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

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread always online
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 xlst...@gmail.com wrote: Hey Sanjay

$$Excel-Macros$$ please help me Urgent

2011-06-07 Thread vijayajith VA
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

Re: $$Excel-Macros$$ please help me Urgent

2011-06-07 Thread mohd saber
hi sukumar, please find attached. regards, saber On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, Students English maths sceience Grades suresha 45 80 90 90-100 A srinivas 25 36 60 80-90

$$Excel-Macros$$ Please help me

2011-01-19 Thread sudhir kumar
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

Re: $$Excel-Macros$$ Please help me

2011-01-19 Thread lucky singh
Hi Sudhir, PFA... Regards, Lucky On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar bluecore...@gmail.com 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

Re: $$Excel-Macros$$ Please help me

2011-01-19 Thread Manoj kumar
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 bluecore...@gmail.com wrote: Hi All Dear members Plz help on the following point. I want count no. of Days between two Dates. Example 1-12-10

Re: $$Excel-Macros$$ Please help me

2011-01-19 Thread Anubhav Somani
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 manoj.vishwakarma...@gmail.com wrote: use either of them :- =(B1-A1)+1 =DATEDIF(A1,B1,d)+1 Regards, Manoj

Re: $$Excel-Macros$$ Please Help me its urgent//Not able to apply count if function in Attached sheet.

2010-05-12 Thread Born to Win
Thanks for ur support sumit. Thanks, Chandrabhan Singh On Tue, May 11, 2010 at 7:19 PM, sumit kumar sagars...@gmail.com 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 cs4...@gmail.com wrote: Hi All,

Re: $$Excel-Macros$$ Please help me

2010-05-05 Thread sidhantha suchit
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 vikask...@gmail.com wrote: Harry.. 2003 format On Tue, May 4, 2010 at 10:11 AM, Harpreet Singh Gujral

Re: $$Excel-Macros$$ Please help me

2010-05-03 Thread Rahul Gandhi.
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 s.suc...@gmail.com 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

$$Excel-Macros$$ Please help me

2010-05-02 Thread sidhantha suchit
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

Re: $$Excel-Macros$$ Please help me

2010-05-02 Thread Harpreet Singh Gujral
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 s.suc...@gmail.com 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

RE: $$Excel-Macros$$ please help me for Excel Conditional formula with example

2010-04-27 Thread Dave Bonallack
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 it's

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

2010-04-27 Thread sudhir kumar
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

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

2010-04-27 Thread Harpreet Singh Gujral
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 sudhir.p...@gmail.com

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

2010-04-26 Thread sudhir kumar
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

$$Excel-Macros$$ please help me for Excel Conditional formula with example

2010-04-26 Thread Vikas Chouhan
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

$$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

2010-04-24 Thread sudhir
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 --

$$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Sach1810
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

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Abhishek Jain
Can you send an example file ? That would help to understand better. Thanks, On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 sach1...@googlemail.com 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

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread rf1234 rf1234
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 sach1...@googlemail.com wrote: Hi, I have two cells lets say a1 and a2 both of which are continually updating from a live feed. I

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Paul Schreiner
. Paul From: Sach1810 sach1...@googlemail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com 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

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Paul
From: Sach1810 sach1...@googlemail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com 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

$$Excel-Macros$$ Please help me fourmula

2010-02-01 Thread subhash tambe
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

Re: $$Excel-Macros$$ Please help me fourmula

2010-02-01 Thread ankur
hi Subhash where is file ? On 01/02/2010, Dilip Pandey dilipan...@gmail.com 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

$$Excel-Macros$$ Please Help Me !!!!!!!!

2009-08-17 Thread amresh kumar
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 --~--~-~--~~~---~--~~

$$Excel-Macros$$ Please Help Me!!!

2009-08-10 Thread Sandeep
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

$$Excel-Macros$$ Please help me to solve the problm

2009-07-11 Thread shijomon joseph
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

$$Excel-Macros$$ please help me with count function !!!URGENT!!!

2009-02-04 Thread shay shay
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

$$Excel-Macros$$ Please Help me

2008-11-19 Thread Ajay Kumar
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)™