Re: $$Excel-Macros$$ pls help in matching two ledgers through Vlookup or any other method

To me, if you just want to "match" the simplest option would be to use a pivot table. Copy all you ledger numbers in a column. put the locations in another and draw a pivot. Attached is an example. HTH On Fri, Apr 29, 2016 at 11:39 PM, Cute Awesome wrote: > Dear All, > I'm unable to have exact

Re: $$Excel-Macros$$ pls help in match two columns

Some part of your query is not clear. Please give a sample output as to what exactly you want. Rgds, On Fri, Mar 25, 2016 at 7:10 PM, Cute Awesome wrote: > Dear All, > > Pls help me out in matching two columns wherein i'll be having cost of > products which i have send back to supplier and in o

Re: $$Excel-Macros$$ pls help in matching in two different column

Here's the approach I took:You need to make each entry "unique".so, I used =COUNTIF(A2:$A$35,A2) in column B to count the number of occurrences of the value in column A,but only from the current position DOWN.That means that since 223.20 appears twice in the list,the first time, the count is 2,b

Re: $$Excel-Macros$$ pls help -Required out[ut in a cell

thnks ganesh..working fine.. Chandra Singh Bisht On Tue, Nov 4, 2014 at 5:01 PM, Ganesh N wrote: > Dear chandan, > > PFA. If you have any concern let me know. > > Regards, > Ganesh N > > On Tue, Nov 4, 2014 at 3:41 PM, Chandan Bisht wrote: > >> >> Hi Group >> >> i m creating a macro by vba

Re: $$Excel-Macros$$ pls help -Required out[ut in a cell

Dear chandan, PFA. If you have any concern let me know. Regards, Ganesh N On Tue, Nov 4, 2014 at 3:41 PM, Chandan Bisht wrote: > > Hi Group > > i m creating a macro by vba but getting some error ... > > pls help i want to output in a cell.using below code .. > > example atteched..

Re: $$Excel-Macros$$ Pls help another approach.

Dear All, Any Progress.Pls ...Help. Warm Regards, Gawli Anil On Sat, Mar 30, 2013 at 2:58 PM, अनिल नारायण गवली wrote: > Dear Friends, > > From the attached sheets i want the smallest amt soldtocode lookup with > material code > > for eg:- now the material code is 16421126161 > > This mate

Re: $$Excel-Macros$$ Pls help

Hi, try this, Ctrl+F, put value in Find What, Find All, Ctrl+A and then Esc regds On Thu, Nov 1, 2012 at 8:30 PM, karthikeyan sankaran < karthikeyansankar...@gmail.com> wrote: > Hi, > > How to select particular cell value within one click.I need to select > value 2 only. > without using macr

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings. *

THANKS BOSS On Fri, Oct 19, 2012 at 5:20 PM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (palande.swapni...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

Hi, Try below formula. =IF(AND(A1<=-0.5,A1>=-1),"STRONG BUY",IF(AND(A1<=-0.2,A1>=-0.49),"BUY",IF(AND(A1<=0.19,A1>=-0.19),"HOLD",IF(AND(A1<=0.49,A1>=0.2),"STRONG SELL",IF(AND(A1<=1,A1>=0.5),"SELL",FALSE) Regards, Swapnik. On Oct 19, 2012 10:08 PM, "Hilary Lomotey" wrote: > Hello Experts >

Re: $$Excel-Macros$$ Pls Help Me on this

Anil, if possible pls share a sample sheet with group. On Fri, Oct 19, 2012 at 3:30 PM, अनिल नारायण गवली wrote: > suppose there is one two excel file > one is A > second is B > in A file there is 2 fields like (Shiptocode) and (Productcode). > in B file there is 5 fields like (Shiptocode) and (Pr

Re: $$Excel-Macros$$ Pls help me on this.

- From: अनिल नारायण गवली To: NOORAIN ANSARI ; excel-macros@googlegroups.com Sent: Wed, October 17, 2012 5:32:48 AM Subject: Re: $$Excel-Macros$$ Pls help me on this. Dear noorian, Pls help me awaiting for your reply On Mon, Oct

Re: $$Excel-Macros$$ Pls help me on this.

Dear noorian, Pls help me awaiting for your reply On Mon, Oct 15, 2012 at 5:37 PM, अनिल नारायण गवली wrote: > Dear Groups and Noorian, > > I want a macro that import other worksheets in a excel workbook by using > filedailogbox . > > 1) when filedailogbox opens i have to select the required file

Re: $$Excel-Macros$$ pls help urgent- need data in the format as required

Yes please needs that urgently On Sep 7, 2012, at 8:46 AM, "Rajan_Verma" wrote: > Will Suggest you a Code ,if you need? > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On > Behalf Of Sara Lee > Sent: 07

RE: $$Excel-Macros$$ pls help urgent- need data in the format as required

Will Suggest you a Code ,if you need? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sara Lee Sent: 07 September 2012 10:36 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ pls help urgent

Re: $$Excel-Macros$$ pls help urgent- need data in the format as required

Please do not RE post at a later time. RUDE! And, VERY RUDE to use URGENT. Your request is NOT more urgent than anyone else. Since not all students would always have all years I would suggest a vba macro to do this. Is that OK. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@

Re: $$Excel-Macros$$ pls help me solve my query.

dguille...@gmail.com From: amar takale Sent: Tuesday, August 14, 2012 2:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ pls help me solve my query. Dear dguillett Sir, How to do it & which stock price show? And also VBA code create passwords So I cant

Re: $$Excel-Macros$$ pls help me solve my query.

uille...@gmail.com > > *From:* amar takale > *Sent:* Tuesday, August 14, 2012 2:23 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ pls help me solve my query. > > Dear dguillett Sir, > How to do it & which stock price show? > And also VBA code crea

Re: $$Excel-Macros$$ pls help me solve my query.

Send YOUR file to ME with this msg and I’ll take a look. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Tuesday, August 14, 2012 2:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ pls help me solve my query. Dear

Re: $$Excel-Macros$$ pls help me solve my query.

Dear dguillett Sir, How to do it & which stock price show? And also VBA code create passwords So I cant see code. Pls Explain it It is very useful for me to update comparative valuation. Thanks Amar On Sat, Aug 4, 2012 at 6:23 PM, dguillett1 wrote: > > > Don Guillett > Microsoft Excel Developer

Re: $$Excel-Macros$$ pls help me solve my query.

please explain some more.. On Fri, Aug 3, 2012 at 11:39 AM, Kenil Gala wrote: > hi folks, > i am having a query in getting external data, > pls help me for the same. > i have written my query in the excel sheet. > > > Thanks in adv, > > Regards, > > -- > FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ pls help in conditional formating

Please share the code. Regards Iqbal M On Fri, Jul 13, 2012 at 5:15 AM, ChilExcel wrote: > Hi Mohammed > > Please see attached file, I think is what you need > > > Chilexcel > > > 2012/7/12 Mohammed Hamed Ajaz > >> Pls help in conditional formatting >> >> Example >> >> Column A Colum

Re: $$Excel-Macros$$ pls help in conditional formating

Dear Ajaz, Please share a sample sheet On Fri, Jul 13, 2012 at 2:24 AM, Mohammed Hamed Ajaz wrote: > Pls help in conditional formatting > > Example > > Column A Column B name Column C due date columne D last due > date > > 5/7/12 colony > > pls provide me a formula so

Re: $$Excel-Macros$$ pls help in conditional formating

Hi Mohammed Please see attached file, I think is what you need Chilexcel 2012/7/12 Mohammed Hamed Ajaz > Pls help in conditional formatting > > Example > > Column A Column B name Column C due date columne D last due > date > > 5/7/12 colony > > pls provide me a fo

Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no

Thanks It works. On Wed, May 16, 2012 at 9:41 PM, Maries wrote: > Hi, > > Try it, > * > =COLUMN()*25+ROW()* > > > > On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote: > >> I am happy for your kind support >> >> Pls help me again for below issue . >> >> Find attached sheet >> >> >> Thanks. >>

Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no

*PFA...* On Wed, May 16, 2012 at 8:11 PM, Maries wrote: > Hi, > > Try it, > * > =COLUMN()*25+ROW()* > > > > On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote: > >> I am happy for your kind support >> >> Pls help me again for below issue . >> >> Find attached sheet >> >> >> Thanks. >> >> -- >>

Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no

Hi, Try it, * =COLUMN()*25+ROW()* On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote: > I am happy for your kind support > > Pls help me again for below issue . > > Find attached sheet > > > Thanks. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate

Re: $$Excel-Macros$$ pls help with matching postal codes

@googlegroups.com Subject: Re: $$Excel-Macros$$ pls help with matching postal codes actually, if there is no exact value, it should give me next smallest or largest value- which ever is closest. i tried vlook up with true- but a lot of cases, it is not the closest. pls check out after u use vlookup true

Re: $$Excel-Macros$$ pls help with matching postal codes

actually, if there is no exact value, it should give me next smallest or largest value- which ever is closest. i tried vlook up with true- but a lot of cases, it is not the closest. pls check out after u use vlookup true. It is not always the closest Best case scenario is exact and then next

Re: $$Excel-Macros$$ pls help with matching postal codes

Hi Sara, You can also you use.. *=IFERROR(LOOKUP(H2,Sheet1!$C$1:$C$72),"")* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 9:39 AM, Sara Lee wrote: > > > -- > > *col i *in Sheet 2 needs to be filled up > > by looking

Re: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently

You finish Option Explicit Sub transposeqmSAS() 'fire from qmform sheet Dim dlr As Long With Sheets("raw") dlr = .Cells(Rows.Count, "b").End(xlUp).Row + 1 Range("C4:C40").Copy Sheets("Raw").Cells(dlr, "b").PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=True R

RE: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently

Hi, How many worksheet of QM Form do you have ? Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mukesh Kukreja Sent: Apr/Fri/2012 03:30 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently

Re: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently

why need macros? use paste as transpose only. From: Mukesh Kukreja To: excel-macros@googlegroups.com Sent: Friday, April 27, 2012 3:29 PM Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently   Hi All,     Request you to kindly help me very u

Re: $$Excel-Macros$$ pls help with sum if formula

also you can use the below formula if you are using ms office 2007 or later versions =sumifs(d3:d409,g3:g409,">350", g3:g409,"<450") On Mon, Apr 9, 2012 at 10:11 AM, Maries wrote: > Hi, > > Try Below Formulas, > > =SUMPRODUCT(--((G3:G409>350)*(G3:G409<450))*D3:D409) > > =SUM(IF(--(G3:G409>35

Re: $$Excel-Macros$$ pls help with sum if formula

Hi, Try Below Formulas, =SUMPRODUCT(--((G3:G409>350)*(G3:G409<450))*D3:D409) =SUM(IF(--(G3:G409>350)*(G3:G409<450),D3:D409,0)) Note: second one is Array formula. Apply with Ctr + Shift = Enter. Regards, MARIES. On Mon, Apr 9, 2012 at 5:09 AM, Sara Lee wrote: > =SUMIF(G3:G409,"<350",$D$3:$D$

Re: $$Excel-Macros$$ pls help

hi Pls clearify your issue in your query or you can google it. On 17/09/2011, Shankar Bheema wrote: > Pls do reply experts.. > > On Fri, Sep 16, 2011 at 10:16 PM, Shankar Bheema > wrote: > >> where do i get help for Crystal reports 9 problems ? >> >> -- >> >> -

Re: $$Excel-Macros$$ pls help

Pls do reply experts.. On Fri, Sep 16, 2011 at 10:16 PM, Shankar Bheema wrote: > where do i get help for Crystal reports 9 problems ? > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ pls help

Hi CC, Use this formula, {=IF(F5:J5<35,"Fail","Pass")} *Best Regards,* *Venkat * *Chennai* On Thu, Aug 11, 2011 at 5:49 PM, vijayexcel m wrote: > Dear All , > > Pls help how to evelate the student performance . > > I want to find below 35 marks consider as fail ,more then 35 its pass > > Pls

Re: $$Excel-Macros$$ pls help

Dear Vijay, See attached sheet if it help. On Thu, Aug 11, 2011 at 5:49 PM, vijayexcel m wrote: > Dear All , > > Pls help how to evelate the student performance . > > I want to find below 35 marks consider as fail ,more then 35 its pass > > Pls find the attached file > > Regards, > vijay

Re: $$Excel-Macros$$ pls help

advance filter is used to filter the qunique data. On Wed, Apr 20, 2011 at 4:35 PM, rohit gupta wrote: > hiii, > > kindly let me know what are the benifits of ADVANCE FILER in Excel 2003. > > wating for reply... > > Thanks in advance... > > Regards, > > -- > > ---

Re: $$Excel-Macros$$ pls help

Hey, Find the below mention link and read it. Advance Filter Intro. On Wed, Apr 20, 2011 at 4:35 PM, rohit gupta wrote: > hiii, > > kindly let me know what are the benifits of ADVANCE FILER

Re: $$Excel-Macros$$ pls help

try this link http://www.contextures.com/xladvfilter01.html On Wed, Apr 20, 2011 at 4:35 PM, rohit gupta wrote: > hiii, > > kindly let me know what are the benifits of ADVANCE FILER in Excel 2003. > > wating for reply... > > Thanks in advance... > > Regards, > > -- > > -

Re: $$Excel-Macros$$ Pls help!!! Macro for Editi link

search for the string using Find&Replace Feb 11 - Circle\AA\GA - AA_F&F_FEB and replace with Mar 11 - Circle\AA\GA - AA_F&F_MAR On Thu, Mar 17, 2011 at 10:38 PM, Ankit wrote: > _MAR_ -- Rakesh kumar khowal +91 9540084660 +91 9868532105 --

Re: $$Excel-Macros$$ Pls Help me in the attached file

n u explain this please. >> >> Thanks & Regards >> Dharmesh Shah >> >> >> On Fri, Mar 4, 2011 at 4:18 AM, siti Vi wrote: >> >>> for your info only.... >>> >>> >>> -- Forwarded message -- >

Re: $$Excel-Macros$$ Pls Help me in the attached file

>> -- Forwarded message -- >> From: STDEV(i) >> Date: Fri, Mar 4, 2011 at 5:40 AM >> Subject: Re: $$Excel-Macros$$ Pls Help me in the attached file >> To: excel-macros@googlegroups.com >> >> >> why not >> =SUMPRODUCT( >>

Re: $$Excel-Macros$$ Pls Help me in the attached file

011 at 4:18 AM, siti Vi wrote: > >> for your info only >> >> >> -- Forwarded message -- >> From: STDEV(i) >> Date: Fri, Mar 4, 2011 at 5:40 AM >> Subject: Re: $$Excel-Macros$$ Pls Help me in the attached file >> To: excel-macr

Re: $$Excel-Macros$$ Pls Help me in the attached file

r your info only > > > -- Forwarded message -- > From: STDEV(i) > Date: Fri, Mar 4, 2011 at 5:40 AM > Subject: Re: $$Excel-Macros$$ Pls Help me in the attached file > To: excel-macros@googlegroups.com > > > why not > =SUMPRODUCT( > ('C

Re: $$Excel-Macros$$ Pls Help me in the attached file

good keep it up On Thu, Mar 3, 2011 at 3:02 PM, Dharmesh Shah wrote: > Dear All > > I want some specific value using formula or any other method. > > Please help me to get the required answer. > > Thanks & Regards > > Dharmesh Shah > > -- >

Re: $$Excel-Macros$$ Pls Help..

*Thnx.. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı On Thu, Feb 24, 2011 at 10:15 AM, Rohan Young wrote: > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > 2011/2/23 кαяαηη yα∂αν > > >> To post to this group, send email to excel-macros@googlegroups.com >> > >

Re: $$Excel-Macros$$ Pls Help..

To post to this group, send email to excel-macros@googlegroups.com 2011/2/23 кαяαηη yα∂αν > > To post to this group, send email to excel-macros@googlegroups.com > -- -- Some important links for excel users: 1. F

Re: $$Excel-Macros$$ PLS HELP

but I don't think > it can be done within a formula. > Dave. > > -- > Date: Wed, 23 Jun 2010 21:28:14 +0530 > Subject: Re: $$Excel-Macros$$ PLS HELP > From: cs4...@gmail.com > > To: excel-macros@googlegroups.com > > Dear Darmesh, > &g

RE: $$Excel-Macros$$ PLS HELP

No, I think he wants the formatting present in Cell A3, but I don't think it can be done within a formula.Dave. Date: Wed, 23 Jun 2010 21:28:14 +0530 Subject: Re: $$Excel-Macros$$ PLS HELP From: cs4...@gmail.com To: excel-macros@googlegroups.com Dear Darmesh, Please elaborate i think you

Re: $$Excel-Macros$$ PLS HELP

Dear Darmesh, Please elaborate i think you want it as i am sending i am sending u a attachment. Thanks, Chandrabhan Singh On Wed, Jun 23, 2010 at 12:31 PM, Dharmesh Shah wrote: > > > > > Dear group > > Please help in attached excel file. > > Regards > Dharmesh Shah > > > > -- > > ---

Re: $$Excel-Macros$$ pls help - Vertical to Horizontal

You might also look up 'loan amortization' in online templates in Microsoft Office. The formulas are all built in so you can study them. On Thu, Feb 25, 2010 at 9:59 PM, ankur wrote: > hi umesh > > for learning vba , u can download books from our file section > > Have A Nice Time & Enjoy Life >

Re: $$Excel-Macros$$ pls help - Vertical to Horizontal

hi umesh for learning vba , u can download books from our file section Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Feb 16, 2010 at 4:45 PM, C.G.Kumar wrote: > Please find attached solution. > > > > > > Regar

RE: $$Excel-Macros$$ pls help - Vertical to Horizontal

...@gmail.com] Sent: Friday, February 12, 2010 11:58 AM To: excel-macros@googlegroups.com Cc: matkarum...@gmail.com Subject: Re: $$Excel-Macros$$ pls help - Vertical to Horizontal Dear Umesh, Attached is the solution file Please verify and let me know if any further help is required. The below macro has