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

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

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

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,

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

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:

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

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

Re: $$Excel-Macros$$ please help

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 whic

Re: $$Excel-Macros$$ Please help in dividing equal numbers

you are welcome On Fri, May 29, 2015 at 11:36 AM, Rashi Singh 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 wrote: > >> as per

Re: $$Excel-Macros$$ Please help in dividing equal numbers

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 wrote: > as per your requirement > > On Fri, May 29, 2015 at 11:25 AM, Titu Sharma wrote: > >> how can

Re: $$Excel-Macros$$ Please help in dividing equal numbers

updated as per 50 On Fri, May 29, 2015 at 11:31 AM, Titu Sharma wrote: > as per your requirement > > On Fri, May 29, 2015 at 11:25 AM, Titu Sharma 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 >> wrote: >>

Re: $$Excel-Macros$$ Please help in dividing equal numbers

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 wrote: > how can you have bundle of 150, this should be bundle of 50 i think... > > O

Re: $$Excel-Macros$$ Please help in dividing equal numbers

as per your requirement On Fri, May 29, 2015 at 11:25 AM, Titu Sharma 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 > wrote: > >> Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my >> drawe

Re: $$Excel-Macros$$ Please help in dividing equal numbers

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 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 Rs 100 have to take

Re: $$Excel-Macros$$ Please help in dividing equal numbers

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

Re: $$Excel-Macros$$ Please help in dividing equal numbers

What's your criteria for "how many 100 or 150 you can use". On Fri, May 29, 2015 at 10:04 AM, Rashi Singh 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. > > > Reg

Re: $$Excel-Macros$$ Please help in dividing equal numbers

please explain your query On Fri, May 29, 2015 at 10:04 AM, Rashi Singh 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 > > -- > Are you =E

Re: $$Excel-Macros$$ Please help with Activex "cannot insert object". error

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 d

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

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

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

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

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

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))),

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

; > *“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 >

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

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

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. Regards Gaurav Devrani On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner

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 "proces

Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data

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 wh

Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data

Hi ivavok , Please find the attached file as per your requirement... On Fri, Oct 24, 2014 at 5:31 PM, ivavok 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 to be able to work with >

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

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

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

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

Re: $$Excel-Macros$$ please help for consolidate in excel

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 wrote: > Hi Yadav, > > you can also use this. Just put the data files in separate folder and put > the path

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

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

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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ please help for consolidate in excel

Hi Use this code instead, this is simple & easy: Sub dataupdate() Range("A2").Select Range(ActiveCell.End(xlDown), Selection.End(xlToRight)).Select Selection.Copy Worksheets("Data update").Select Range("A100").End(xlUp).Offset(1, 0).Select ActiveCell.PasteSpecial Application.CutCopyMode = Fal

Re: $$Excel-Macros$$ please help for consolidate in excel

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 wrote: > Hi Yadav, > > you can also use this. J

Re: $$Excel-Macros$$ please help for consolidate in excel

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 wrote: > Hi, > > You can try this excellent codes share by Ashish earlier this month: > > Sub merge() > > D

Re: $$Excel-Macros$$ please help for consolidate in excel

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

Re: $$Excel-Macros$$ Please Help

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 wrote: > Well done Ravindre, Thanks > > > On Thu, Jan 30, 2014 at 11:59 AM, Ravinder > wrote: > >> =TEXT(MAX((H2=$B$2:$B$1944)*$D$2:$D$1944),"MM/DD/ H:MM") with CSE >> >> >> >> *From:* e

Re: $$Excel-Macros$$ Please Help

Well done Ravindre, Thanks On Thu, Jan 30, 2014 at 11:59 AM, Ravinder wrote: > =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,

RE: $$Excel-Macros$$ Please Help

=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 a

Re: $$Excel-Macros$$ Please help on FileName = Dir()

Hi Paul, Thank you very much. It solved my query. [?] Regard, Maksood Alam On Thu, Dec 5, 2013 at 5:59 PM, Paul Schreiner wrote: > In your script, you have a line: > FileName = Dir(CurrDir & "*.*", vbDirectory) > This basically creates a "collection" of information from "CurrDir". > vbDirector

Re: $$Excel-Macros$$ Please help on FileName = Dir()

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 e

Re: $$Excel-Macros$$ Please help

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 b

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

> ratio just change the calculation in formula. > > Thanks > Ravinder > > --- On *Tue, 6/4/13, Bé Trần Văn * wrote: > > > From: Bé Trần Văn > Subject: Re: $$Excel-Macros$$ Please help Excel Gurus > To: excel-macros@googlegroups.com > Date: Tuesday, June 4, 2013,

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

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 = 6%

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

Formula Cell G5 =$F5/($E$5-$D$5) Fill down and fill right 2013/6/4 P.VIJAYKUMAR > 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, Haris

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

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 wrote: > Hi Every One, > Please find the attached file, > Kindly help me with the required for

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

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

Re: $$Excel-Macros$$ Please Help

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 wrote: > Hi Jayseel, > > Thank you for your replay, > > But i needed the In between

Re: $$Excel-Macros$$ Please Help

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 wrote: > Hi Karthik, > > Please check if this your requirement, > > Regards, > Jaysheel > > > On Wed, Jan 9, 2013 at 8:07 PM, kart

Re: $$Excel-Macros$$ Please Help

Hi Karthik, Please check if this your requirement, Regards, Jaysheel On Wed, Jan 9, 2013 at 8:07 PM, karthik N wrote: > Dear Help > > Please help for below attached file. > > > -- > > *Regards* > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FOR

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

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, accura

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Thank you so much Natron. You have made my work very easy. Thanks again. On Tue, Nov 20, 2012 at 6:35 PM, Natron 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 > Private Sub cmdExp

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

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

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

@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

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 - Romania Mobil: +40 741-105-012 (Orange) Mobil: +40 726-226-021 (Cosmote) *Before printing this e-mail please consider environmen

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

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 Sender: excel-macros@googlegroups.com Date: Fri, 19 Oct 2012 10:35:38 To: Reply-To: excel-macros@googlegroups.com Sub

Re: $$Excel-Macros$$ Please HELP

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, sre

Re: $$Excel-Macros$$ Please Help to Find out the solution

Dear Don Guillett, Thanking you for your kind assistance and help. Really appreciated. On Sat, Sep 15, 2012 at 7:01 PM, dguillett1 wrote: > Is the attached what you want for the SECOND line > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:

Re: $$Excel-Macros$$ Please Help

$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'r

Re: $$Excel-Macros$$ Please Help

gards* >> >> *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:*

RE: $$Excel-Macros$$ Please Help

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 at

Re: $$Excel-Macros$$ Please Help

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

Re: $$Excel-Macros$$ Please Help

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: dguillett1 To: excel-macros@googlegroups.com Sent: Thu, September 6, 2012 8:37:44 AM Subject: Re: $$

Re: $$Excel-Macros$$ Please Help

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 dgui

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

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

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

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

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

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

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 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) > =

Re: $$Excel-Macros$$ please help with array formula

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 P

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

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 K

Re: $$Excel-Macros$$ please help with array formula

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

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

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

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

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

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

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

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

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

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

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 > > > > -- > >

Re: $$Excel-Macros$$ please help with array formula

Thanks Noorain bhai.. its solved my qurey.. On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI wrote: > 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)

Re: $$Excel-Macros$$ please help with array formula

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 c

Re: $$Excel-Macros$$ please help with array formula

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

Re: $$Excel-Macros$$ please help with array formula

cannot send any attchment due to system restrictions. On Tue, Aug 28, 2012 at 8:20 PM, ashish koul wrote: > 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*(c

Re: $$Excel-Macros$$ please help with array formula

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 ca

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

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

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

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 merg

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

imes you can, To all the people you can, As long as ever you can.” - John Wesley - From: David Grugeon To: excel-macros@googlegroups.com Sent: Wed, August 15, 2012 3:06:05 AM Subject: Re: $$Excel-Macros$$ Please help

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

Hi Muneer In essence this is almoost impossible. The width of each letter varies so if you type and they each contain the same number of characters but the width of each is very different. The only way I know of to work out how much of a particular string will fit in a given ce

RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

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 continue

RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

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 help

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

ok thanks On Fri, Jul 20, 2012 at 6:00 PM, NOORAIN ANSARI wrote: > 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 > wrote: > >> Dear Noorain Ji, >> >> when i drag this formula it show same result... >>

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

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 wrote: > Dear Noorain Ji, > > when i drag this formula it show same result... > > > On Fri, Jul 20, 2012 at 5:52 PM, NOORAIN ANSARI > wrote: > >> Dear Manoj, >> >>

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

Dear Manoj, Please see attachment without Array Function. On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar wrote: > 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 ANSARI > wrote: >

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

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 wrote: > Dear Noorain Ji. > > I need 1st,2nd and 3rd Max sealing model name in every state... > > Regard > Manoj > > > On Fri, Jul 20, 2012 at 11:21 AM, NOORA

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

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 wrote: > > Dear Expert, > > Please help me > > Query file attached with mail... > > Regard > Manoj > > > -- > -- > FORUM RULES (986+ members alread

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

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

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

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.

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

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

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

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

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

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 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

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

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

  1   2   3   >