Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

1 is 1500 and >>> the rate for 2 pax is 1700, same way for room no 202,203 and 204 the >>> rate for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file >>> in which upon entering the room no and pax the value should be >>> automatically generated in

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

oops attachment missing -- On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel wrote: > Hi Enclosed solution with simple vlookup. > > It would be great if you can share the tariff plan calculation logic so > that we are create this more dynamic > > -- > > On Tue, Oct 11

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

Hi Enclosed solution with simple vlookup. It would be great if you can share the tariff plan calculation logic so that we are create this more dynamic -- On Tue, Oct 11, 2016 at 1:55 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > pl reply > > *Thanks & Regards* > > *Sohil S. Hu

Re: $$Excel-Macros$$ Need Help in VBA

Hi Try below VBA code Option Base 1 Sub rr() For Each r In Range("b2:b" & Range("b9").End(xlUp).Row) x = Split(r, ",") For t = LBound(x) To UBound(x) Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1) Range("i9").End(xlUp).Offset(1).Value = x(t) Next Next End S

Re: $$Excel-Macros$$ Macro run very slow

please share your code. -- On Tue, Sep 20, 2016 at 1:33 PM, chandrashekarb.xls < chandrashekarb@gmail.com> wrote: > > Hi Team, > Am trying to format few rows using vba code but it taking lot of time > still have kept screenupdating & enableevent to false. > > Regards, > Chandru > > > Sent fr

Re: $$Excel-Macros$$ Re: Outlook 2016 - Macro Help!

No, You can not record macro on Outlook, if you are looking for basic of outlook macro thn please refer below url- http://www.easytweaks.com/add-macros-outlook-2016/ -- On Mon, Sep 19, 2016 at 8:54 PM, dza49 wrote: > Anyone have any idea on how to record macros in Outlook and have a place > w

Re: $$Excel-Macros$$ VBA MACRO NEEDED (SIMPLE??)

Hey Bil, You can do this thru formula only. Enclosed without macro solution, let us know if you still required macro. -- On Sun, Sep 18, 2016 at 8:42 AM, Bill Q wrote: > Please see attached. > > Looking for a macro to automate a repetitive task. > > 1. It is to look for a specific text in Col

Re: $$Excel-Macros$$ Query on formula

Welcome back Ashish!.😉 -- On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote: > =IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N") > > On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote: > >> Dear Experts, >> >> Please help me to solve the attached query. >> >> -- >> *Kalyan Chattopadhyay* >>

Re: $$Excel-Macros$$ Macro to extract datas from PDF form to Excel sheet

Hey, If you are good in VBA coding then you can search "pdf to excel convert vba" and take reference. Please see below the some useful urls- https://www.linkedin.com/groups/1871310/1871310-74131482 http://quickvba.blogspot.in/2010/12/import-pdf-in-excel.html http://www.vbaexpress.com/kb/getarti

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

No, you can not add more thn 250 ppls -- On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote: > is there any option in whatsup appln to add unlimited members(in single > group) > paid or free ? > > On 11 September 2016 at 11:50, Learner Excel wrote: > >> Thanks Prabhu!..

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

Thanks Prabhu!.. Happy to here from you!>=. -- On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky wrote: > Hi Friends, > > Since i have created Whatsapp group for VBA Macro learners/experts. > > And i have added many peoples in this group. Please Msg me to 9500087194 > in whatsapp to get added in

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

Please go thru below url http://dailydoseofexcel.com/archives/2015/02/13/converting-an-excel-range-to-html-the-hard-way/ -- On Sat, Sep 10, 2016 at 9:49 PM, Learner Excel wrote: > Hey please refer enclosed sample workbook (excel table to html code) > > > > -- > > On Sat,

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

Hey please refer enclosed sample workbook (excel table to html code) -- On Sat, Sep 10, 2016 at 4:35 PM, Dheeraj Bankoti wrote: > hi > is any expert there in group who can short out the issue.. > > Regards > -- Forwarded message -- > From: Dheeraj Bankoti > Date: Sun, Sep

Re: $$Excel-Macros$$ Excel Table to HTML table

Please refer below url https://gist.github.com/jkatricak/801024 http://windowssecrets.com/forums/showthread.php/107929-VBA-code-to-HTML http://dailydoseofexcel.com/archives/2011/09/20/roll-your-own-html-from-excel-vba/ -- On Sat, Sep 10, 2016 at 12:18 PM, Devendra Sahay < devendrasahanypt...@gma

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

Who's making this group, please reply? else I can take initiave to do the same. -- On Sat, Sep 10, 2016 at 11:07 AM, Satheesh Arumugam Naidu < satheesh.arumu...@gmail.com> wrote: > please add 8861087687 > > On Thu, Sep 8, 2016 at 1:01 PM, prkhan56 wrote: > >> Please add me >> 8291577844 >> Rash

Re: $$Excel-Macros$$ Macro not working

Try enclosed one -- On Fri, Sep 9, 2016 at 9:37 AM, GENIUS wrote: > working perfectly, thank you very much for your help > > one more question, if I have figures in column A as shown in the sheet > and I want to take the 17% in column B of the amount of column A as shown > in the attachment t

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Is there any relation between both sheets? If yes you can use vlookup. It would be great if you can upload (attache) some sample data with your requirement -- On Fri, Sep 9, 2016 at 5:17 PM, Sandeep Kumar Baranwal < sandeepkumarbaran...@gmail.com> wrote: > Hi > > I have a spreadsheet with two t

Re: $$Excel-Macros$$ Macro not working

Opps you have register incorrect data type against variable j, data type should be string [image: Inline image 1] -- On Thu, Sep 8, 2016 at 10:01 PM, GENIUS wrote: > > Sir >>> >> Thanks for your follow up, I enable which you have mentioned in the last >> mail but there is another message pleas

Re: $$Excel-Macros$$ Macro not working

Attachment missing -- On Thu, Sep 8, 2016 at 9:59 PM, GENIUS wrote: > Sir >> > Thanks for your follow up, I enable which you have mentioned in the last > mail but there is another message please see the attachment > > right now I have three version of excel i.e. 2007,2010 & 2013, I opened > th

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

ile if possible >> >> -- >> >> On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote: >> >>> Can you please upload some same ASCII same file if possible >>> >>> -- >>> >>> On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote: >>&g

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

sorry typo error, Can you please upload some sample ASCII file if possible -- On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote: > Can you please upload some same ASCII same file if possible > > -- > > On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote: > >> the data is a

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

Can you please upload some same ASCII same file if possible -- On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote: > the data is an ASCII file that I need to parse > > On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote: >> >> Hi Pirerre, >> >> Please help me understand - >> 1. Is this

Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

Is the data in PDF is text or image? If text, please refer below urls for your reference http://www.vbaexpress.com/kb/getarticle.php?kb_id=1101 http://www.ozgrid.com/forum/showthread.php?t=186024 https://acrobatusers.com/forum/general-acrobat-topics/search-text-pdf-vba-only-adobe-reader-installed

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

Hi Pirerre, Please help me understand - 1. Is this in excel only? 2. There is any unique identifier if the blocks are more than one. Suggestions - 1. We can you us Text to column than use some formulas to make table 2. You can extract value thru using LEFT,RIGHT formula -- On Wed, Sep 7, 20

Re: $$Excel-Macros$$ Macro not working

Brother, you have to add Outlook reference as well [image: Inline image 1] -- On Tue, Sep 6, 2016 at 9:18 AM, GENIUS wrote: > Sir > > I'm waiting for your reply very anxiously > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join offici

Re: $$Excel-Macros$$ I need help breaking a numerical data range. I have an excel worksheet with over 6000000 rows of dat

If the row count is really 60lac than I strongly suggest you to please use MS-Access for any DB (like MYSql or MSSQL) as Excel have rows limit (10lac only.) -- On Tue, Sep 6, 2016 at 1:24 PM, Malungo Tomson Banda < malungotoms...@gmail.com> wrote: > I need help breaking a numerical data range.

Re: $$Excel-Macros$$ Macro not working

You need to add "Microsoft Outlook 14.0 Object Library" in references -- On Sat, Sep 3, 2016 at 10:10 PM, Izhar wrote: > > Please see the question in the attachment > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

Please add 886006795 -- On Sat, Sep 3, 2016 at 8:17 AM, Ankit Monga wrote: > Pls add my number 9560718272 > > On Sep 3, 2016 7:19 AM, "Suhas" wrote: > >> Hi, Please add me to the whatsapp excel group. My Nbr +91 9791760609 >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Macro is not working

For list of file name, use enclosed code. -- On Fri, Sep 2, 2016 at 10:33 PM, Izhar wrote: > > Please open the file and see the question > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

Hey Dheeraj Please see below urls hope this will help http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/outlook-2010-some-names-in-sent-items-appear-in/c3c1ef47-6af0-44d5-bdec-ae7d4b0f7bef?auth=1 https://www.experts-exchange.com/questions/26282293/Single-Quotes-in-E-mail-Address

Re: $$Excel-Macros$$ Re: Need help in macro

Yes, its working for me, can you please share the screenshot. thanks -- On Sat, Aug 27, 2016 at 10:48 PM, Manju Keerthi wrote: > Was it working fine for you? i am getting error in the below two line > (error #1044) so, Else part "Range("b2").Validation.Delete" is not > working. > > .Add Type:

Re: $$Excel-Macros$$ Re: Need help in macro

Try enclosed one. -- On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi wrote: > Thank you so much. This helped me a lot:-) > > Is there any option to disappear the dropdown when user does not have any > value in column B. instead of disable the drop down in the column B. > > once again Thanks a l

Re: $$Excel-Macros$$ Need help in macro

HI Manju, See this help you -- On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote: > Hi > > > > I need your help to create a macro for the below mentioned scenario. > > > > *Scenario* > > > > We need two columns namely User, drop down > > > > *“IF user enter data in User column(cells) a automa

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

WelCome Manju, Keep posting and learn more and more. Why you need this thru marco/VBA? Are you familiar with VBA or macor -- On Sat, Aug 27, 2016 at 11:12 AM, Manju Keerthi wrote: > Hi, > > I am a beginner in excel i need your help to solve the following scenario > i need to create a macro wh

$$Excel-Macros$$ UserForm control property reference

e does not work. What I need is a correct statement to pass property name by variable. Please help ASAP, regards, Learner -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.co

$$Excel-Macros$$ Auto filter criteria

hi Experts, Once again am back with another query on Autofilter i could able to manage Advance filter criteria function perfectly in case of one criteria but unable to proceed in case if two criteria or existing Ex: In Column A i need filter only1, 2 and in columnd i need filter on

Re: $$Excel-Macros$$ Loop issue

; efficient, simpler, easier to follow, and less error-prone to just perform > the action on the range. For example, you have > > Rows("102:" & k).Select > Selection.Delete Shift:=xlUp > > This could be > > Rows("102:" & k).Delete Shi

$$Excel-Macros$$ Excel Analytics

Hi Experts, Does any one of you have finance models which are built in excel or any excel analytics related spreadsheets. i am basically appearing for financial planning and analysis interview so just in case if any of you have such models please do share with me.. Thanks, Ram -- Are you =EXP(E

$$Excel-Macros$$ new workbook saving with defined names

hi All, please guide me how to declare variable to save the new worbook with Names listed in A column. i am trying to create new workbook and also rename that sheets as per defined names in column b, or c or d tabs respectively. Col A Col B Col C Col D RAMTODAY TOM

Re: $$Excel-Macros$$ Loop issue

not, where is the > active cell after this line is run? > > Regards > David Grugeon > > > > On 28 April 2013 16:36, excel learner wrote: > >> hi David, >> >> I tried step by step execution but still it is executing fine without any >> error but deletio

Re: $$Excel-Macros$$ Loop issue

hi Team, Can anyone please resolve my concern. Thanks. On Sun, Apr 28, 2013 at 12:06 PM, excel learner wrote: > hi David, > > I tried step by step execution but still it is executing fine without any > error but deletion part in first transaction tab is not done.. > > Thank

Re: $$Excel-Macros$$ Loop issue

hi David, I tried step by step execution but still it is executing fine without any error but deletion part in first transaction tab is not done.. Thanks & Regards, Ram On Sun, Apr 28, 2013 at 12:04 PM, David Grugeon wrote: > You have highlighted 5 lines > > Try stepping through the code and f

Re: $$Excel-Macros$$ Count in cell formula

uestion is for everyone who are all in practice of doing copy paste of someones suggestion by saying THIS ALSO WORKS, ANOTHER METHOD * On 18-01-2013 4:17 PM, अनिल नारायण गवली wrote: Dear Ms-Exl-Learner, Hey Dear, Keep helping others that's good but don't tally with others

Re: $$Excel-Macros$$ Count in cell formula

, Jan 18, 2013 at 2:46 AM, Excel_Lover <mailto:idforex...@gmail.com>> wrote: ha ha!!! On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner mailto:ms.exl.lear...@gmail.com>> wrote: @ Noorain Ansari, Could you please explain what is the use

Re: $$Excel-Macros$$ Count in cell formula

@ Noorain Ansari, Could you please explain what is the use of /*Sumproduct*/ in your below formula? /*=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1)*/ Why not it should be /*LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1*/? Since both will result the same answer. *My Suggestion Posted HALF AN HOU

Re: $$Excel-Macros$$ Count in cell formula

* In D5 cell =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"") Drag it down...* On 17-01-2013 3:40 PM, amar takale wrote: Dear champs Pl suggest simple count formula in cell -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use co

Re: $$Excel-Macros$$ Re: formula required

@ Prince, Do you think is it a quality answer? and Dont you think you are re-directing the OP in wrong approach? =SUM(($D$2:D5=D2)**1**(G2:M2))*with CSE*in Cell "O2" Could you please explain what is the need of **1* *and what is the need ofCSE here* *why not then one (Non Array Approach)

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

*In F1 cell *- _*Non Array formula *_ *=LOOKUP(2,1/(A1:A8=D1),ROW(A1:A8))* OR *=SUMPRODUCT((MAX((A1:A8=D1)*ROW(A1:A8* On 10-01-2013 4:41 PM, Hilary Lomotey wrote: Hi Experts, In the attached, i have a list of items, some are repetitive in the list, if i want to find the relative positi

Re: $$Excel-Macros$$ need formula

In A2 cell *=INDIRECT("'"&$D$1&"'!"&ADDRESS(ROW(),COLUMN()+1))* Drag it down and right... On 10-01-2013 1:14 PM, Rajesh Agarwal wrote: Dear Sir If I change the sheet name in column D1 all the rows of column A & B change accordingly need formula not macro -- *Rajesh Kumar Agarwal* *981106300

Re: $$Excel-Macros$$ Need Help to seperate Date & time

Please make it in an excel workbook and send it to us for our better understanding of your data structure. On 10-01-2013 1:01 PM, kumar.ashish861 wrote: Dear Seniors, Pls help to seperate date & time, if both are in 1 cell. 7/11/2012 13:51 Formula req..! Thanks in advance Ashish k

Re: $$Excel-Macros$$ Index of sheets

@ Noorain, But Change in Worksheet Name or addition of sheets are not automatically getting added in your solution, for which the user needs to press F2 in the formula cell or close the workbook and re-open it for getting it reflected. Slight enhancement has been done Your A2 cell formula *

Re: $$Excel-Macros$$ How to get max number from a database ?

*In C4 cell* - *Non Array Formula* =SUMPRODUCT(MAX(($A$4:$A$9567=A4)*$B$4:$B$9567)) Drag it down. On 09-01-2013 3:35 PM, karan kanuga wrote: Hi Can anyone pls let me know how do i get the max value or date (using a formula and not pivot) from the database that i have. Attached is the databas

Re: $$Excel-Macros$$ Index of sheets

Not possible without the help of Excel VBA or Third Party Addins. On 10-01-2013 10:57 AM, Hari wrote: Thanks for your help. but is there any formulae to get the same answers. Thanks, Harish On 10 January 2013 10:11, The Viper > wrote: Perhaps! He requires the

Re: $$Excel-Macros$$ Needs excel formula to find the running totals between two dates

@ Jeet Singh, It's surprising, you took almost a day time to***edit **Ashish Koul* Suggestion??? On 08-01-2013 2:13 PM, jeet singh wrote: =SUMIFS(C2:C11,A2:A11,">="&F2,A2:A11,"<="&G2)-SUMIFS(B2:B11,A2:A11,">="&F2,A2:A11,"<="&G2) REGARDS JEET SINGH On Mon, Jan 7, 2013 at 7:06 PM, Yahya M

Re: $$Excel-Macros$$ Needs excel formula to find the running totals between two dates

_*Compatible, Faster & Shorter Length formula *_*=SUMPRODUCT((A2:A11>=F2)*(A2:A11<= G2),(-B2:B11)+(C2:C11))* On 07-01-2013 9:00 PM, Yahya Muhammad wrote: Thanks Ashish. Is there any way we can combine two SUMPRODUCTS/SUMIFS into one, to reduce the length of formula ? On Mon, Jan 7, 2013

Re: $$Excel-Macros$$ Excel Fun Video

I don't know why you guy's are getting surprised for this one =-O . Because any of you can create lot more like this by just inserting any of your flash files in excel. *Whatever the magic is happening is just a shadow of the flash files and excel is just a window which holds it :-P * Same t

Re: $$Excel-Macros$$ Re: Sumif not working

@Prince, Thanks for the understanding :) On 26-12-2012 2:27 PM, Prince wrote: Yes Dear Ms-Exl-Learner, I also belive in correcting the things so that anything we do should be perfect and smooth. It is best form me that guys like you are always there who can ping me whenever i do any thing

Re: $$Excel-Macros$$ Re: Sumif not working

usage***of functions. Whenever I see any formula with error I just point out, so that you will be aware of the drawbacks which will help you when building formula's in future. On 26-12-2012 1:38 PM, Prince wrote: Hi Ms-Exl-Learner, Yes dear, you are right. There are so many ways to d

Re: $$Excel-Macros$$ Re: Sumif not working

@Prince, Why not just added another "m" in your text function *TEXT(C16:C35,"mmm")*which will avoid unnecessary MID Function. One more thing I don't think you need any case sensitivity function here (Proper in your formula). (TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) TEXT(C16:C35,"mmm") = Thi

Re: $$Excel-Macros$$ Re: Sumif not working

@ Lalit Mohan, You're Welcome and *accept my thanks to you* for *not taking anything in negative* :) Anyone can point out my solutions too... if my suggestion goes wrong :) On 26-12-2012 12:29 PM, Lalit Mohan Pandey wrote: Thanks Ms-Exl-Learner for the suggestion. Regards, Lalit Moha

Re: $$Excel-Macros$$ Re: Sumif not working

@Lalit, Why not a *Non Array Formula* suggestion? In D2 cell =SUMPRODUCT((TEXT($B$16:$B$380,"")=$B2)*(D$16:D$380)) Drag it right Do you think your solution will work in all systems? The answer is *NO*. It *FAIL* in many systems because of different date formatting in *Regional Date&Tim

Re: $$Excel-Macros$$ Sumif not working

*In C16**cell* =IF(ISNUMBER(B16),TEXT(B16,""),"") *Drag it down.* *In D2 cell* =SUMIF($C$16:$C$380,$B2,(D$16:D$380)) *Drag it to right...* On 26-12-2012 11:24 AM, Rajesh thrissur wrote: Hi Experts, In the attachment file the sumif formula is not working I don't know why.kindly point the mi

Re: $$Excel-Macros$$ Merge entry cell

cell something cell also miss=one number which same If single number=show single number that it simple. I used Ms-Exl-Learner that perfect but if all cell same but last cell different number then show that numbers,I want that time show error then i will know something is problem.If there are no

Re: $$Excel-Macros$$ Merge entry cell

t; > > On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner > wrote: > >> =LOOKUP(10^10,E7:H7,E7:H7) > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Merge entry cell

*In K7* =LOOKUP(10^10,E7:H7,E7:H7) *Non *Array Solution. On 14-12-2012 5:50 PM, amar takale wrote: Dear Experts Pls can anybody help me on this matter. As always, Thank you very much for all the help Regards Amar On Thu, Dec 13, 2012 at 1:00 PM, amar takale

Re: $$Excel-Macros$$ Help on V Lookup

In addition to the below post, you cannot use Sumproduct to get the Text Data as result. <><><><><><><> *Ms-Exl-Learner* <><><><><><><> On 10-10-2012 11:13 PM, Kuldeep Singh wrote: Hi Srinivas, Please

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need to find out date of latest data

assistance. <><><><><><><> *Ms-Exl-Learner* <><><><><><><> On 08-10-2012 12:44 PM, Vijayendra Rao wrote: Dear All, I have some data which includes amount data. I need the latest data’s date. Request you to let me know what form

Re: $$Excel-Macros$$ Re: Help on Macro

Hi Shrinivas, A sample workbook with the parameters and the expected output will be helpful for giving exact solution. <><><><><><><> *Ms-Exl-Learner* <><><><><><><> On 06-10-2012 9:01 AM, Shrinivas Shev

Re: $$Excel-Macros$$ St id Reqd on Max Date

Hi Manoj, Go through the below for Non Array Formula Solution. *Try this for getting the Maximum Date based on Name* =SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2))) *Try this for getting the ID based on Maximum Date of a name* =SUMPRODUCT(($C$2:$C$47=$E2)*($A$2:$A$47=SUMPRODUCT(MAX($A$2:$A$47*($

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Or in one shot... =IF(SUMPRODUCT(--((F11:L11)<($F$10:$L$10))),"Failed","Passed") Refer the attached sheet for detail. . <><><><><><> *Ms.Exl.Learner* <><><><><><> -- <><><><><><> *Ms.Exl.Learner* <><><><><><> On Wed, Sep 5, 2012 at 1:24 PM, Manoj Kumar wrote: > Dear Amar, > > Please Use it

Re: $$Excel-Macros$$ Simple formula required

Or =IF(ISERR(FIND(")",D3)),"",TRIM(MID(D3,FIND(")",D3)+1,255))) <><><><><><> *Ms.Exl.Learner* <><><><><><> --- On Tue, Sep 4, 2012 at 2:01 PM, amar takale wrote: > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members alrea

Re: $$Excel-Macros$$ NUM ERROR

s is a beautiful formula pal , i am learning new stuff > everyday , but tell me what is the essence of =--(ROW()&O2) in the formula? > > thanks > > > On Fri, Aug 24, 2012 at 4:47 AM, Ms-Exl-Learner . < > ms.exl.lear...@gmail.com> wrote: > >> Refer the attache

Re: $$Excel-Macros$$ Need Help Urgent !!!!!!!!!!!!!!!!!!!

Better you should have created it in Ms-Access. <><><><><><> *Ms.Exl.Learner* <><><><><><> On Fri, Aug 24, 2012 at 5:45 PM, jocky Beta wrote: > > Hi, > > Please find the attached excel sheet in which their is a report Tab > which generates following report automatically > > 1)Current Stock > 2

Re: $$Excel-Macros$$ Need help

You're Welcome --- Ms.Exl.Learner --- On Wed, Aug 22, 2012 at 4:26 PM, Manoj Kumar wrote: > Many many Thanks for solution... > > > On Wed, Aug 22, 2012 at 4:23 PM, Ms-Exl-Learner . < > ms.exl.lear...@gmail.com> wrote: > >&g

Re: $$Excel-Macros$$ Need help

For Macro Solution Try the below code Option Explicit Sub SplitNumber() Dim i As Long, j As Long, EndCol As Long EndCol = Range("A2").CurrentRegion.Rows(1).Cells.Count For i = 1 To EndCol For j = 1 To Cells(2, i).Value Cells(3 + j, i).Value = Cells(3, i).Value / Cells(2, i).Value

Re: $$Excel-Macros$$ Need help

Type or copy and paste the below formula in A4 cell. A4 cell =A$3/5 Drag the A4 cell formula upto A8 cell and drag it to the right if required. --- Ms.Exl.Learner --- On Wed, Aug 22, 2012 at 3:41 PM, Manoj Kumar wrote: > i need the formula witch divide

Re: $$Excel-Macros$$ Need a Suggestion for the formula

Try This... =SUMPRODUCT(('Jan12'!F4:F60={"Corrective","Implementation","Training","Information"})*('Jan12'!H4:H60="DATA")*('Jan12'!G4:G60="Completed")) Let us know in case of any further assistance. --- Ms.Exl.Learner --- On Fri, Aug 17, 2012 at 10:13 PM,

Re: $$Excel-Macros$$ Re: plz solve problem

Hi Pravesh, Copy and paste the below formula in C15 cell =VLOOKUP($D$2,INDIRECT("'"&$D$3&"'!"&"$A$1:$E$7"),MATCH(C$14,INDIRECT("'"&$D$3&"'!"&"$A$1:$E$1"),0),0) Drag the C15 cell formula to Right upto F15 cell. Hope that helps! --- Ms.Exl.Learner --- On S

$$Excel-Macros$$ Delete controls that were created at run time with the Add method

given. Following statements give error "Could not find specified object". UserForm2!Label1.Clear UserForm2!Controls.Label1.Clear I have tried "!" & "." either alone or in combination at various positions without success. Help with correct syntax to refer con

Re: $$Excel-Macros$$ Split text in cell

Another Approach Copy and paste the below formula in 2nd Row of any cell other than A2 cell and drag it below. =IF((LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ","")))>1, TRIM(MID(TRIM(A2), FIND(" ",TRIM(A2))+1, (FIND("^",SUBSTITUTE(TRIM(A2)," ","^",(LEN(TRIM(A2))-LEN(SUBSTITU

Re: $$Excel-Macros$$ shortcut key .

On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . < > ms.exl.lear...@gmail.com> wrote: > >> Alt+D+F+F >> >> --- >> Ms.Exl.Learner >> --- >> >> >> On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA >&

Re: $$Excel-Macros$$ shortcut key .

Alt+D+F+F --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote: > Hello sir > > Can you tell me what is shortcut key for data clear(filter)? > > > Thanks > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use co

Re: $$Excel-Macros$$ Cell Formatting

Hi, Just convert it to real time and apply time format as well. =--(LEFT(A1,2)&":"&RIGHT(A1,2)) --- Ms.Exl.Learner --- On Tue, Nov 22, 2011 at 5:30 PM, jmothilal wrote: > use this > > =LEFT(A1,2)&":"&RIGHT(A1,2) > > Mothilal.J > > > > On Tue, Nov 22, 20

Re: $$Excel-Macros$$ Rounding Method

Hi Mothilal, Yours is the exact and simplified solution. In fact, I forgot that function and I was unable to recollect it while replying to the OP's question. But, your reply helped me to recall it. Thanks Dude... --- Ms.Exl.Learner --- On Wed, Nov 9, 2

Re: $$Excel-Macros$$ Rounding Method

Hi Sajid, Refer the reply given to another post for the same subject. --- Ms.Exl.Learner --- On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj wrote: > Dear Experts, > > I want rounding method in excel 2003 > when i typed 124.90 the rounding should come 120 &

Re: $$Excel-Macros$$ Rounding method

Hi, Assume that your input data is A2 cell and apply the below formula in B2 cell. =A2-MOD(A2,5) Refer the attachment for details. --- Ms.Exl.Learner --- On Wed, Nov 9, 2011 at 2:11 PM, SAJID MEMON wrote: > Dear Experts, > > I want rounding method in

Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

Hi Sara, Refer the below thread for feasibility. http://www.excelforum.com/excel-worksheet-functions/639013-number-of-the-week-in-month.html --- Ms.Exl.Learner --- On Mon, Oct 31, 2011 at 6:49 AM, Sara Lee wrote: > hi > > i have a column in excel with t

Re: $$Excel-Macros$$ Formula needed to extract the text from string

is one of it, since the Legendary Excel MVP Don Guillett also getting joined in this group. --- Ms.Exl.Learner -- On Wed, Oct 12, 2011 at 4:13 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Amazing… Ms-Exl-learner… > >

Re: $$Excel-Macros$$ Formula needed to extract the text from string

Hi Anil, I Assume that your data is in Column A and your first row is having the column header. So your data will start from 2nd row of Column A (i.e. from A2 cell) A1 Data A2 /ENTRY-10 OCT TRF/REF 6004ABS6834230 /ORD/ Q-FAST TELECOM BV STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO 201

Re: $$Excel-Macros$$ Need a help -----very urgent

Hi B.N Chetan kumar, Try this... =--SUBSTITUTE(A3," ","-") Or =IF(ISERR(--SUBSTITUTE(A3," ","-")),"",--SUBSTITUTE(A3," ","-")) Hope that helps! --- Ms.Exl.Learner --- On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar < chetankumar1...@gmail.com> wrote

Re: $$Excel-Macros$$ date format in Excel

Hi Sanjib, If it is real date then sir dguillett suggestion will work fine... --- Ms.Exl.Learner --- On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear > > I like to put the date format in Excel as "dd/mm/yyy

Re: $$Excel-Macros$$ examine three columns return the one that matches criteria

Hi, Something like this.. =IF(ISNUMBER(SEARCH("FL",IR3)),IR3,IF(ISNUMBER(SEARCH("FL",IS3)),IS3,IF(ISNUMBER(SEARCH("FL",IT3)),IT3,IF(ISNUMBER(SEARCH("FL",IU3)),IU3,"" The above formula check from Cell IR3 to IU3, if any match is found from the starting cell then it stops the the remaining con

Re: $$Excel-Macros$$ Message on Cell

Hi Ankit, Go through the below links to have a better understanding about Validation in Excel. http://www.contextures.com/xlDataVal06.html http://www.contextures.com/xlDataVal04.html http://www.contextures.com/xlDataVal07.html Hope that helps! --- Ms.Exl.Learner

Re: $$Excel-Macros$$ Find the month of sales cross the target

Hi Deepak, Copy and paste the below formula in Second Row after Column H. =IF(B2>100,B$1,IF(SUM(B2:C2)>100,C$1,IF(SUM(B2:D2)>100,D$1,IF(SUM(B2:E2)>100,E$1,IF(SUM(B2:F2)>100,F$1,IF(SUM(B2:G2)>100,G$1,IF(SUM(B2:H2)>100,H$1,"Not Qualified"))) I have attached an example file for your better unde

Re: $$Excel-Macros$$ Converting date with time to date withOUT time

Hi Mich Mac, It's better if you provide some sample data in excel file, so that we can suggest you the exact formula to your expectation. --- Ms.Exl.Learner --- On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac wrote: > I am exporting a file from online which au

Re: $$Excel-Macros$$ Problem with Sumifs formula

Hi Kalyan, Try the below formula. =SUMPRODUCT((TRIM(A2:A37)=TRIM(F11))*(TRIM(B2:B37)=TRIM(G7))*(LEFT(TRIM(C2:C37),3)=LEFT(TRIM(G8),3))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)>=--MID(TRIM(G8),FIND(" ",TRIM(G8))+1,255))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)<=--MID(TRIM(G9),FIN

Re: $$Excel-Macros$$ Two columns and three criteria

Hi ArtySin, Refer the attachment file for details. Hope That Helps! --- Ms.Exl.Learner --- On Thu, Sep 15, 2011 at 9:39 PM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (unfortunately, corporate > no spend policy): These columns ha

$$Excel-Macros$$ Change excel file logo separate for single files

Hi! I keep four excel workbooks in a folder and need to change logo of each file separately to distinguish them by logo. The logo change in Excel applies to all files. I need to have each file a different logo. Please guide how to pick up logos? Mahess -- --

Re: $$Excel-Macros$$ Vlookup with more than one condition

f this group for last more than 2 years. > I can proudly say that u will find the solutions(not solution) for all u r > problem. > By reading the above mail (from Noorani and Excel Learner) I got some > different feeling.So my suggestion is dont critise any one > Dont write any mail

Re: $$Excel-Macros$$ Vlookup with more than one condition

; > -- > *Thanks & regards,* > *Noorain Ansari* > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Fri, Sep 2, 2011 at 11:11 PM, Ms-Exl-Learner . < > ms.exl.lear...@gmail.com> wrote: > >> Hi Noorain Ansari, >> >&

  1   2   >