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

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

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

which will hurt someone > Shrinivas > > On Sat, Sep 3, 2011 at 6:07 AM, Ms-Exl-Learner . > wrote: > >> I am tired... >> >> --- >> Ms.Exl.Learner >> --- >> >> >> On Fri, Sep

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

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

SARI wrote: > Dear Ms-Exl-Learner, > Thanks for your valuable suggestion.. > > Case -I, In case of duplicay all formulas are successfull working except > vlookup(vlookup) example. > You can see fresh attachement.. > > Case -II, You can't compare Sumproduct with If function

Re: $$Excel-Macros$$ difference time calculation

Hi Noorain Ansari, But the text function will result text value instead of real value. It's better to format the cell as per your desired format by using custom format. --- Ms.Exl.Learner --- On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI wrote: > Dear W

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

Hi Noorain Ansari, It might be better if you might have constructed your example data with some duplicates, since the questioner can able to understand the difference between the *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs, Dsum]*. The *First set of formula's / Functions* just

Re: $$Excel-Macros$$ Help on condition and return value

Try this… =IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),FIND(" ",TRIM(B2))),IF(LEN(TRIM(B2))<>0,B2,"")) --- Ms.Exl.Learner --- On Thu, Mar 24, 2011 at 4:20 AM, Jorge Marques wrote: > Hi guys, is there any way i can do to for example if a cell B2 has th

Re: $$Excel-Macros$$ Value Required based on status updation in column

Hi Maulik, I am sure you will get it resolved if you explain your expectation with some more brief about the way of pulling the data with cell reference and how it can be derived. Because you know very well about your data and the way your expected result. But for us the data is a new one and we

Re: $$Excel-Macros$$ One lookup and different corresponding values

ou all are just Wow !!! !! > > Regds, > Manish > > On Feb 6, 2:01 pm, "Ms-Exl-Learner ." > wrote: > > Hi Bhushan, > > > > Sumproduct can be used when the result is Numeric Value. > > > > Have a look in the attached excel for r

Re: $$Excel-Macros$$ One lookup and different corresponding values

gt; > > > Thanks for valuable post. > > > > > Is it possible to hide the complete row based on lookup value?? > > > > > For example in your solution, if i lookup value x than i want to > hide > > > > > row 14 because the lookup result is 0

Re: $$Excel-Macros$$ One lookup and different corresponding values

Hi Bhushan, Have a look in the attached files. I never suggest array formula when the same can be done in normal way. HTH :) --- Ms.Exl.Learner --- On Tue, Feb 1, 2011 at 6:22 PM, Bhushan wrote: > Dear Ayush, > > Pls assist me for the below formula. I

Re: $$Excel-Macros$$ How to extract data from an array

Hi, Have a look in the attached file. HTH :) --- Ms.Exl.Learner --- On Tue, Feb 1, 2011 at 12:22 AM, jmccaski wrote: > I have an arry of over 21,000 rows with data in this format: > VarName TimeString VarValue > Pos 27.01.2011 12:49:35 32

Re: $$Excel-Macros$$ query for a solution

Hi Thamu, I don't know what is the need for the comparison of 2003 & 2007 excel column versions since the query is not very much related to the 2003 column issue. I agree that the column will be the issue in Excel 2003 when the repetition of UNIQUE IDNO goes beyond 127 times then we could not abl

Re: $$Excel-Macros$$ Formula

Hi John, It will work in version 2003 if you refer the cell reference to part of the column range instead of referring it to the whole column. =LOOKUP(2,FIND(A1,Sheet2!A1:A65535),Sheet2!B1:B65535) See the attached file for detail. --- Ms.Exl.Learner ---

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give b

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Hi All, Have a look in the attached excel and you can find the solution. The formula is given below for your reference. Adapt the Cell Range A3:A8 to your desired Range. =IF(COUNTIF(A3:A8,LARGE(A3:A8,1))=COUNTIF(A3:A8,MODE(A3:A8)),LARGE(A3:A8,1),MODE(A3:A8)) *Suggestions For All* * * 1) Always

Re: $$Excel-Macros$$ Excel Daily Tip : Convert month in text to number

I hope you need to go through each and every post before using / declaring the below words to the group! --- Ms.Exl.Learner --- On Sat, Jan 8, 2011 at 3:28 PM, Ayush Jain wrote: > Ayush Jain has sent you a link to a blog: > > Dear Group, I have published

Re: $$Excel-Macros$$ Nested IF functions?

Yes it's very clear now. Try any one of the below formula which will do the trick. =IF(ISNUMBER(A3),IF(A3>1000,2.5,IF(A3>=500,3,IF(A3<500,3.5,""))),"") OR =IF(ISNUMBER(A3),IF(A3<500,3.5,IF(AND(A3>=500,A3<=1000),3,IF(A3>1000,2.5,""))),"") At the same time herewith I have attached a sample file f

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Hi, In addition to the above post I would like to remove the helper column and we make the formula to do the work. Have a look in the attached file. --- Ms.Exl.Learner --- On Sun, Dec 26, 2010 at 6:29 PM, ashish koul wrote: > > check the attachment > On

Fwd: $$Excel-Macros$$ Help on Advance Formula

for this. --- Ms.Exl.Learner --- -- Forwarded message -- From: Ms-Exl-Learner . Date: Sat, Dec 25, 2010 at 8:39 AM Subject: Re: $$Excel-Macros$$ Help on Advance Formula To: excel-macros@googlegroups.com Hi Chandra Shekar, Have a look in

Re: $$Excel-Macros$$ Help on Advance Formula

Hi Chandra Shekar, Have a look in the attached file. Hope it's clear to you and this is what you are looking for. --- Ms.Exl.Learner --- On Fri, Dec 24, 2010 at 8:09 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Team, > > How to get u

Re: $$Excel-Macros$$ Need to be able to find duplicates before a space

In addition to the below the cursor (Activecell) should be in B2 cell. --- Ms.Exl.Learner --- On 12/23/10, siti Vi wrote: > select the range of your Numbers > for example: B2:B200 > you can apply a conditional formatting on that range > > the condition FOR

Re: $$Excel-Macros$$ help required for large range of data filteration

Excel 2003:- You can see only 1000 records in the Autofilter Dropdown. Not more than that. Excel 2007/2010:- You can see 1 records in the Autofilter Dropdown. Not more than that. So try to use some helper column based on your data criteria use some formula in helper column like Istext, Isnu

Re: $$Excel-Macros$$ Missing Entries

Hi Vebhav, Have a look in the attached file. Hope it helps! --- Ms.Exl.Learner --- On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain wrote: > Hi All, > > Please help me in finding the missing entries from the below data. > > ListAListB > 1

Re: $$Excel-Macros$$ problem in sumif

Hi Rajesh, You are welcome! --- Ms.Exl.Learner --- On Sat, Dec 18, 2010 at 4:56 PM, Rajesh K R wrote: > hi > Thanks for ur answer, i checked the formula , it is working well > > Regards & Thanks > Rajesh Kainikkara > > On

Re: $$Excel-Macros$$ problem in sumif

Copy and paste the below formula:- =SUMIF($R$8:$R$96,$A12,($X$8:$X$96)) Drag the formula cell below to the remaining cells and the criteria cell will be getting changed and the Range and Sum Range will remains same. But past the above formula other than R8:R96, X8:X96 range and A12 cell. Otherwi

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

You can use substitute in front of the UDF to replace the word to your desired local currency right. Another Method:- Follow the below link and download the MoreFuction Addin from that and run the setup. http://download.cnet.com/Morefunc/3000-2077_4-10423159.html After doing that open excel and

Re: $$Excel-Macros$$ Re: Ctrl + Tilde

Hi Sreedhar, Check whether the buttons are working properly (Cntrl & Tilde buttons) --- Ms.Exl.Learner --- On Fri, Dec 3, 2010 at 10:28 PM, Shreedar Pandurangaiah < shreedar.panduranga...@gmail.com> wrote: > Any help on this would really great. > > Thank

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

Check whether your cntrl button is working. Ms-Exl-Learner On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar wrote: > Dear All, > > > When i am using scroll wheel of mouse my excel sheet gets Zoom In (Moving > Forward) & Zoom out