Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

You can use the below formula =INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),2) =INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),3) Attached is the excel file for your reference. Regards, Vijayendra 2012/2/4 chandra sekaran > Hi Sanjib > simple Vlookup forumula to solve your Query > > Regards > chandru >

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

Hi Sanjib simple Vlookup forumula to solve your Query Regards chandru chennai On Fri, Feb 3, 2012 at 4:28 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Thank you for your help > > ragards, > > sanjib > > > On Fri, Feb 3, 2012 at 4:02 PM, The Viper wrote: > >> please find

Re: $$Excel-Macros$$ plz, check the attachment it clearly tells u what I need in actually.

Hi Muneer, Can u Explain some more about query... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Sat, Feb 4, 2012 at 10:59 AM, Mohammed Muneer wrote: > ** > > > > > > Regards, > Muneer, > CC... > > -- > FORUM RULES (986+ membe

$$Excel-Macros$$ plz, check the attachment it clearly tells u what I need in actually.

Regards, Muneer, CC... -- 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 Need Advice will not get quick attention or may not be answered. 2) D

Re: $$Excel-Macros$$ formula in rate column

hi check the attachment On Sat, Feb 4, 2012 at 12:02 AM, raghu gr wrote: > Hi experts, > > I have a invoice file and summary file, i want the formula in rate column, > which has to pick from rate sheet. > please help me in this regard > > Attached sample file > > Thank you > > with regards >

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats... Noorain & Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

Hi Sanjib, Look Attached... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Experts, > > Please See the attachment and Help me regar

$$Excel-Macros$$

Dear Sir, I am using Bathtext function in excel sheet, by this I want to write the value (1,234), in words (One Thousand Two hundred & Thirty four). But it is showing in the Thailandi text. Pls, suggest how to apply this function properly. Regards, Muneer, CC... -- FORUM R

Re: $$Excel-Macros$$ Urgent Help

Hi Noorain, Thanks a lot of... On 2/3/12, NOORAIN ANSARI wrote: > Dear Pravesh, > > See attached sheet.. > > =SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18)) > > On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko > wrote: > >> This should work >> >> =INDEX($D$5:$D$18

RE: $$Excel-Macros$$ paste special problem

Hi Danial, If you are not done with your task, you may want to consider this variation on Don's approach. It's not thoroughly tested, but some of the changes should improve reliability. The principle differences: (1) Processes Areas (distinct ranges) containing formulas in each worksheet

$$Excel-Macros$$ Re: Copy of excel files to 1 excel file -need vba code

> >> Dear Group >>> >>> >>> >>> >> one folder of excel files copy to 1 excel file -plz need help > >>> >>> *Thanks&Regards* >>> >>> ** >>> >>> ***Veerendra.Vanam* >>> >>> *TOC TEAM* >>> ***Bhagyanagar Electrical & Contractors** >>> H.No-5-9-286/65,Plot No-65 >>> Rajiv Gandhi Nagar,Near Andhra

Re: $$Excel-Macros$$ Need help

Dear Sriram, Look attached...as required... On Thu, Feb 2, 2012 at 6:38 PM, sriram ji wrote: > Dear Excel Guru, > > Kindly provide the solution for the attached file. > > Thanks & Regards, > Sriram G > Chennai > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use conci

Re: $$Excel-Macros$$ paste special problem

Show me. Don Guillett SalesAid Software dguille...@gmail.com From: danial mansoor Sent: Friday, February 03, 2012 3:07 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ paste special problem thanx,your work fine with with little changes.

RE: $$Excel-Macros$$ paste special problem

thanx,your work fine with with little changes. From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ paste special problem Date: Fri, 3 Feb 2012 14:33:36 -0600 Run mine Don Guillett SalesAid Software dguille...@gmail.com From: danial manso

Re: $$Excel-Macros$$ paste special problem

Run mine Don Guillett SalesAid Software dguille...@gmail.com From: danial mansoor Sent: Friday, February 03, 2012 2:09 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ paste special problem in this i have t select each sheet is there a way i run macro and every sheet get up

RE: $$Excel-Macros$$ paste special problem

in this i have t select each sheet is there a way i run macro and every sheet get updated with values and no formula shown?bt plz consider huge file Date: Fri, 3 Feb 2012 23:47:03 +0530 Subject: Re: $$Excel-Macros$$ paste special problem From: vijayajith...@gmail.com To: excel-macros@googlegro

Re: $$Excel-Macros$$ Urgent Help

OK. Here is another way AFTER sorting the source table INDEX(E:E,MATCH(I6,D:D)) Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Friday, February 03, 2012 12:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help This should work =

$$Excel-Macros$$ formula in rate column

Hi experts, I have a invoice file and summary file, i want the formula in rate column, which has to pick from rate sheet. please help me in this regard Attached sample file Thank you with regards Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ paste special problem

Hi mansoor, sub tex() selection.value = selection.value end sub On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor wrote: > i have a big file with many sheets i want to convert formula in values,if > i do individually it will take lotes of time can any one tell me the macro > which will work? > >

Re: $$Excel-Macros$$ Urgent Help

Dear Pravesh, See attached sheet.. =SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18)) On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote: > This should work > > =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4))) >

Re: $$Excel-Macros$$ Urgent Help

I second Don. please keep in mind that the volunteers here 'lend' their time to the forum to help. So it would be best to give that extra bit of information in a clear and concise manner, so that it is easy for the volunteers. Sam On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote: > T

Re: $$Excel-Macros$$ Urgent Help

This should work =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4))) Regards, Sam Mathai Chacko On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR wrote: > Hi, > > > please help ASAP. > > please find attached sheet. > > > Thanks > >

Re: $$Excel-Macros$$ Urgent Help

It is nice to ask in the body of the email what you want. Always, tell us what you want and give examples. And, speaking for myself, the word URGENT only tends to make me NOT want to help, at least for free Don Guillett SalesAid Software dguille...@gmail.com -Original Message- Fr

$$Excel-Macros$$ Urgent Help

Hi, please help ASAP. please find attached sheet. Thanks Pravesh Kumar -- 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 Need Advice will not get q

Re: $$Excel-Macros$$ help

Thanks noorain; On Fri, Feb 3, 2012 at 11:00 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > Please try through this UDF.. > > Function Extract_number(rng As String) > For i = 1 To Len(rng) > If Mid(rng, i, 1) = "(" Then > Extract_number = Extract_number & " " & Mid(rng, i + 1, 3) > Extract_numbe

Re: $$Excel-Macros$$ help

Hi Noorain, Please find the attached sheet. Thanks On Fri, Feb 3, 2012 at 10:30 PM, vijayajith VA wrote: > Hi Noorain ansari, > > Data will be floo see r eree s seer(A23),seruo serereserrser seeess > kke(A89 ) =I need ans answer as A23,A89 > > but if i use your formula i am getting A23 only .i

Re: $$Excel-Macros$$ help

Hi Noorain ansari, Data will be floo see r eree s seer(A23),seruo serereserrser seeess kke(A89 ) =I need ans answer as A23,A89 but if i use your formula i am getting A23 only .i need both A23,A89 On Thu, Dec 29, 2011 at 11:33 AM, NOORAIN ANSARI wrote: > Dear Vijay, > > You can also try...

Re: $$Excel-Macros$$ To excel macro team

Dear Pascal, Check below link.. http://www.discussexcel.com/contact-me On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro wrote: > Hi, > I'm not receiving mail summary from group posting anymore. Is there any > reasons? > Regards, > Pascal > > -- > FORUM RULES (986+ members already BANNED for violati

Re: $$Excel-Macros$$ paste special problem

Probably the most efficient to do only those with formulas option explicit Sub dovalues() dim ws as worksheet For Each ws In ActiveWorkbook.Sheets With ws.Cells.SpecialCells(xlCellTypeFormulas) .value = .Value End With Next ws End Sub Don Guillett SalesAid Software dguille...@gmail.com From: d

$$Excel-Macros$$ paste special problem

i have a big file with many sheets i want to convert formula in values,if i do individually it will take lotes of time can any one tell me the macro which will work? Note:macro should work fine in huge file i have a macro which is working fine with small file but not in huge file urgent help w

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

Sorry for the late reply, Rajan could you explain your code for pivot table? where can i find / download the BU list.xlsx? 2012/1/23 rekha siri > Rajan i could able to find out the root cause. > > i deleted sub delete module below and call delete function line > now its working fine > > Thanks,

Re: $$Excel-Macros$$ Pivot Table from two separate sheets

If you are using excel 2007+ then install this add-in On Fri, Feb 3, 2012 at 6:18 PM, B Sharma wrote: > Hello Friends. > I have two sheets For E.g. > 1. Opening Balances and purchases of goods > 2. Consumption of goods > > Both the sheets will contain many colours like. > purchase da

Re: $$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

That's what I'm looking for, thanks Kris and Don! -- 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 Need Advice will not get quick attention or may not b

Re: $$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

Or Sub selectedsheetsnames() dim sh as worksheet For Each sh In ActiveWorkbook.Windows(1).SelectedSheets MsgBox sh.Name Next sh End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Kris Sent: Friday, February 03, 2012 3:50 AM To: excel-macros@googlegroups.com Subject: $$Excel-M

Re: $$Excel-Macros$$ Match in Rows

Look in the help index for MATCH Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: qcan Sent: Thursday, February 02, 2012 11:00 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Match in Rows Hi, Not sure how to do this. Looking for a formula (pref

Re: $$Excel-Macros$$ Pivot Table from two separate sheets

Hi, can u send a sample data sheet On Fri, Feb 3, 2012 at 6:18 PM, B Sharma wrote: > Hello Friends. > I have two sheets For E.g. > 1. Opening Balances and purchases of goods > 2. Consumption of goods > > Both the sheets will contain many colours like. > purchase date,consumption date

$$Excel-Macros$$ Pivot Table from two separate sheets

Hello Friends. I have two sheets For E.g. 1. Opening Balances and purchases of goods 2. Consumption of goods Both the sheets will contain many colours like. purchase date,consumption date, inv. no. party name., item, qty. , values, etc. Now I need to create a Pivot table, in which

Re: $$Excel-Macros$$ Formula need

Thanks Noorin, On Fri, Feb 3, 2012 at 3:21 PM, NOORAIN ANSARI wrote: > Dear Chandra, > > Please use.. > > =VLOOKUP(C3,$C$9:$H$13,MATCH($C$1,$C$7:$H$7,0),0) > or > =SUMPRODUCT((PROD=C3)*($D$7:$H$7=C1)*($D$9:$H$13)) > or > =INDEX($D$9:$H$13,MATCH(C3,PROD,0),MATCH(C1,$D$7:$H$7,0)) > > See attached

Re: $$Excel-Macros$$ Re: Copy of excel files to 1 excel file with excel file name -Solve Problem

> > >> >> >>> Dear Group >>> >>> One folder of some excel file is there ,every excel file has Time >>> >>> i nedd total folder excel file data copy 1 excel file but In start A >>> column i need Excel name how is it possible >>> plz find attachment of folder of excel files & Req data

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

please find the attached On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Experts, > > Please See the attachment and Help me regarding VLOOKUP FUNCTION > > Thanking you in Advance > > Sanjib > > > > > > > > > > -- > - > > -- > FORUM RULES (986+ m

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Brother (I always called Noorain by this), Heartiest congratulation to you.you are not only an expert in excel...There are few nice people in this world..YOU ARE ONE OF THEM. I am really happy for your achievement.keep it up. Congratulation once again. -- *Kalyan Chattopadhy

Re: $$Excel-Macros$$ Values before "_"

Hi =LEFT(A2,FIND("_",A2&"_")-1) Kris -- 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 Need Advice will not get quick attention or may not be answe

$$Excel-Macros$$ Re: Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

Hi, Arrange your table like this. Mark Grade Ramarks 1 e Poor 41 d Average 51 c Good 61 b Very Good 71 a Excelient -- 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

Re: $$Excel-Macros$$ Formula need

Dear Chandra, Please use.. =VLOOKUP(C3,$C$9:$H$13,MATCH($C$1,$C$7:$H$7,0),0) or =SUMPRODUCT((PROD=C3)*($D$7:$H$7=C1)*($D$9:$H$13)) or =INDEX($D$9:$H$13,MATCH(C3,PROD,0),MATCH(C1,$D$7:$H$7,0)) See attached Sheet. On Fri, Feb 3, 2012 at 3:13 PM, chandra sekaran wrote: > Hi Noorin > > Excell She

$$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

Hi Sub kTest() Dim i As Long, c As Long, ShtAs String With ActiveWindow c = .SelectedSheets.Count If c Then For i = 1 To c Sht = Sht & vbLf & .SelectedSheets(i).Name Next MsgBox "The following Sheet(s) ar

Re: $$Excel-Macros$$ Formula need

Hi Noorin Excell Sheet attached Chandru On Fri, Feb 3, 2012 at 3:02 PM, NOORAIN ANSARI wrote: > Dear Chandra, > > Please share sample sheet > > On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran > wrote: > >> Dear all, >> >> Sheet 1 having below data Month wise product details sheet 2

Re: $$Excel-Macros$$ Formula need

Dear Chandra, Please share sample sheet On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran wrote: > Dear all, > > Sheet 1 having below data Month wise product details sheet 2 if i > select Jan -12 then Product A selection qty will come 100what is > the formula any one help me >

$$Excel-Macros$$ Formula need

Dear all, Sheet 1 having below data Month wise product details sheet 2 if i select Jan -12 then Product A selection qty will come 100what is the formula any one help me Jan-12 Feb-12 Mar-12 Apr-12 May-12 * * * * * * PRODUCT A 100 * *

Re: $$Excel-Macros$$ sheet reference from cell

Thanks for your kind support and solutions. flower to you all,, made by me -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ sheet reference from cell

Dear Hemal, I think Krish solution is perfect for your query.. On Fri, Feb 3, 2012 at 2:29 PM, NOORAIN ANSARI wrote: > Dear Hemal, > > Please try it.. > > > =VLOOKUP(MAX(INDIRECT("'"&A1&"'!$D$2:$D$11")),INDIRECT("'"&A1&"'!$D$1:$G$11"),4,0) > > See attached sheet.. > > On Fri, Feb 3, 2012 at 1:3

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Thank you very much to all of you. On Fri, Feb 3, 2012 at 2:01 PM, Ankit Agrawal wrote: > HI Ayush, > > I think, Mr. Noorain has already achieved this. I do not sure about the > month but indeed, he has achieved it > > On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > >> Hello Everyone, >> >

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

HI Ayush, I think, Mr. Noorain has already achieved this. I do not sure about the month but indeed, he has achieved it On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175