$$Excel-Macros$$ Pls Help

Is it possible to convert any number in text. For Example if i entered 500 then by any folmula can excel can give output of five thousend. -- Ankit Varshney 9210639227 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.bl

$$Excel-Macros$$ Pls Help..

Hi..Experts, I need your help.I am unable to attach my file. Pls tell me where I can attach file. Thnx Karan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ Pls Help...

*Hi.. Experts & Excel guru I need ur help.. pls help me.. Thnx Karan * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : ht

$$Excel-Macros$$ pls help

hiii, kindly let me know what are the benifits of ADVANCE FILER in Excel 2003. wating for reply... Thanks in advance... Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

$$Excel-Macros$$ pls help

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 -- -- Some important links for excel use

Fwd: $$Excel-Macros$$ PLS HELP

Dear group Please help in attached excel file. Regards Dharmesh Shah -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Link

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

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

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

$$Excel-Macros$$ Pls help me..

Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from another table by formula. I tried with vlookup i didnt get answer. Pls help me. Regards, Ram. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials a

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

*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

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

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

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

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

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

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

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

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

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 that column c and column d should turn yellow and red respectively after 20 and 30 days considering Column A Date as

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

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 and automatically all the sheets name should displayed in a box from that i have to select one sheet and import that in

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

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 (Productcode)and(Type) Type field is only two value (TRUE or FALSE) and (DP) and (RSP). i have inserted and new field in A file

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

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 other column credits received from supplier. But every time supplier will not provide credits for all the return goods and will hold for queries with other department

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

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

attached solution. > > > > > > Regards, > > > > C.G.Kumar > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Umesh Matkar > *Sent:* 12/February/2010 10:01 AM > > *To:* excel-macros@googlegroups.com > *Cc:*

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

gt; >> >> >> Regards, >> >> >> >> C.G.Kumar >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-mac...@googlegroups.com] *On Behalf Of *Umesh Matkar >> *Sent:* 12/February/2010 10:01 AM >> >> *To:* e

$$Excel-Macros$$ Pls Help- Div by Zero error

While calculating the IRR this error occurs. Could anyone help   Anup Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos --~--~-~--~~~---~--~~ -

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

Guys pls help!!! On Mar 13, 1:30 pm, Ankit wrote: > Guys need help in editing links of a worksheet with more than 100 > links like this - > > Now excel file is in March'11 folder with below link- > > D:\F&F\Feb 11 - Circle\AA\GA - AA_F&F_FEB_2010-11.xlsx > D:\F&F\Feb 11 - Circle\AB\GA - AB_F&F_FE

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

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

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

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 for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, N

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

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

@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!!! 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 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 me solve my query.

Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Kenil Gala > *Sent:* Friday, August 03, 2012 1:09 AM > *To:* excel macros > *Subject:* $$Excel-Macros$$ pls help me solve my query. > > hi folks, > i am having a query in getting external data

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.

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.

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

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

Dear All, Pls help in matching the data of two different ledgers to reconcile figures from respective books and identify missing amounts since several amounts would be same figures which i couldn't match in Vlookup. awaiting your positive reply. Thanks, Regards. -- Are you =EXP(E:RT) or =NOT(

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

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.. Private Sub CommandButton1_Click() Dim sh As Worksheet Dim rng As Range Dim i As Integer Set sh = ThisWorkbook.Sheets(1) Set rng = sh.Range("a

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

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

Software dguille...@gmail.com From: Mukesh Kukreja Sent: Friday, April 27, 2012 4:59 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently Hi All, Request you to kindly help me very urgently with macros I want to make a button to t

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

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

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

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 in matching in two different column

aces you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Cute Awesome To: "excel-macros@googlegroups.com" Sent: Friday, November 6, 2015 1:36 PM Subject: $$Excel-Macros$$ pls help i

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

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

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 thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Nee

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

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

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

example attached. i have multiple columns and rows. Please advise a formula to get the data in the attached format. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread tit

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

Hello Experts i need a formula such that if my results falls between the categories listed below, i get the ratings eg if my result in cell A1 is -25.3% then i shd get a rating of BUY, If cell A1 is say 2% then i shd get a HOLD rating. -50% -100% STRONG BUY -20% -49% BUY -19% 19% HOLD 50% 1

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

Please advise a formula to get the data in the attached format. i need a transpose to the data attached. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor th

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

...@gmail.com From: Sara Lee Sent: Friday, September 07, 2012 12:06 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ pls help urgent- need data in the format as required example attached. i have multiple columns and rows. Please advise a formula to get the data in the attached

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

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

m] On > Behalf Of Sara Lee > Sent: 07 September 2012 10:36 > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ pls help urgent- need data in the format as required > > example attached. i have multiple columns and rows. Please advise a formula > to get the data

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

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

Dear All, I'm unable to have exact match in vlookup for example in bank ledger 750 was entered five times where as in HO ledger only 3 times but unable to show it as missing. The same is the case in HO ledger 800 is twice whereas in bank ledge its thrice. Pls help in by suggesting proper way to d

$$Excel-Macros$$ pls help- i need to get the column name in the fields

ca1 ca2 ca3 ca4 12 123 1 23 7 8 9 5 4 6 7 6 i have tthe above exel data with coln names as ca1,ca2,ca3 etc . i need the result like ca1 ca2 ca3 ca4 rank1 rank2 rank 3 12 123 1 23 ca3 ca4 ca1 7 8 9 5 ca4 ca1 ca2 4 6 7 6 ca1 c

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