$$Excel-Macros$$ Request .

Dear all, One thing I didn't understand in this community whether the people want to increase their knowledge or want help or they are putting/transferring/imposing their whole work to some member. I can certainly understand that the knowledge is Expandable and it grows as you share it .but i

$$Excel-Macros$$ Request

Hi Dear all, Can any one send me setup of MS office 2010. It was download from net by me but it couldn't perform. Please i m waiting for this. -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important li

$$Excel-Macros$$ request

dear members, i had my company logo ,which i want to paste on every page of excel when i take out print. at present i have to paste it again & again on all sheets..is there any method so that excel sheet take that logo as default it will help me a lot ,so that my MIS looks professiona

$$Excel-Macros$$ request

Dear Group, 1 reuested to u pls if u r reverting some one's query then pls save ur attachment in XLS not XLSX, i thing there are some Learner like me who havent excel 2007, if file in XLSX format then we are unable to open Regards Harish Upadhyay --~--~-~--~~~---~--~

Re: $$Excel-Macros$$ Request

I don't think any of us could legally send you a copy of Office 2010. You should contact the company you purchased it from and ask them to help you. On Wed, Mar 3, 2010 at 1:55 AM, sudhir kumar wrote: > Hi Dear all, > > > Can any one send me setup of MS office 2010. > It was download from net

$$Excel-Macros$$ Request for membership

Hi Team, I would like to be part of this excel group. Request you to please add my email id in this group. Thank you and best regards,Sanjay Kapoor -- 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 @ htt

$$Excel-Macros$$ Request for Formula

Dear All, A warm Greetings to all. Please find the attach file to this mail and request you all Guys to provide me the solution and have patients in reading the file throughly. Hoping that there is a Prompt reply and I Thanks each and every individual in advance for all your suggestions. Regards

$$Excel-Macros$$ Request for instruction

Hey, please provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's how to use and instruction -- Regards, Santy C -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Request **Must Read**

Dear All, Request you to please do not change the subject line, if you help some one then just click the reply button.. I know my English is very bad but try to understand thnx group member. -- -

$$Excel-Macros$$ request to forward 39_excelmacros.pdf

Dear all, Plz forward me the book if one of you received from Swapnilsagar i.e 39_excelmacros.pdf Waiting for a prompt reply Thanks in advance -- Ahmed Bawazir --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.

Re: $$Excel-Macros$$ Request for instruction

*hi sant ram plz check links below for sumproduct http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ for array formulas http://www.cpearson.com/excel/ArrayFormulas.aspx for substitute http://www.excelitems.com/2010/05/substitute-function.html *Have A Nice Time & Enjoy Life Regards:

RE: $$Excel-Macros$$ Request for instruction

See the below web site .. http://www.exceluser.com/explore/sumproduct_12.htm From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Tuesday, July 05, 2011 11:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Request for

$$Excel-Macros$$ Request for networkdays formula

-- 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 thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n

$$Excel-Macros$$ Request help on conditional formatting

Hi team, Any one can help me to know how to highlight the name based on other column value (need to highlight name based on the highest or lowest value of other column). Please find sample example has been attached. Thanks & Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

Re: $$Excel-Macros$$ Request for networkdays formula

dear cute, please try it, first change ur formar in mm/dd/ format =NETWORKDAYS(DATEVALUE(MID(B4,FIND("/",B4,1)+1,1)&"/"&LEFT(B4,1)&"/"&RIGHT(B4,4)),TODAY()) On Mon, Aug 27, 2012 at 10:34 PM, Cute Awesome wrote: > > -- > Join official facebook page of this forum @ > https://www.facebook.com

$$Excel-Macros$$ request to separate the no

hi experts, how to separate the number, i mentioned in excel cell please help me *example asdfhfgh9825101236sdfge, 9855255689dffhjrr * i want only number, can any one provide the macro. regards, shivaprasad. -- Regards, Shivaprasad K. +91-9866351016 -- Join official facebook page of

Re: $$Excel-Macros$$ Request help on conditional formatting

Choose E7: E20, Condition 1: Cell Value Is selected, the right pane is used Formula function: = F7: F20> 50 Click the Format button to select the color 2014-02-09 22:45 GMT+07:00 Ganesh N : > Hi team, > > Any one can help me to know how to highlight the name based on other > column value (need

RE: $$Excel-Macros$$ Request help on conditional formatting

=$F7=MAX($F$7:$F$11) try this formula in condition formatting option or pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ganesh N Sent: Sunday, February 09, 2014 9:16 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Request help on

Re: $$Excel-Macros$$ Request help on conditional formatting

gt; > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ganesh N > *Sent:* Sunday, February 09, 2014 9:16 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Request help on conditional formatting > > > > Hi te

RE: $$Excel-Macros$$ Request help on conditional formatting

Subject: Re: $$Excel-Macros$$ Request help on conditional formatting Thanks Ravinder!!! Ravinder may i know why we are using $F7 ? before =Max. Else can you explain how it works ? Thanks & Regards Ganesh N On Mon, Feb 10, 2014 at 10:16 AM, Ravinder wrote: =$F7=MAX($F$7:$F$11)

Re: $$Excel-Macros$$ Request help on conditional formatting

the true condition and color if condition is True. > Actually this is no only F7 once we apply in all range this will change the > F7 to F8, F9, F10 ,F11 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ganesh N >

$$Excel-Macros$$ Request to remove from the group

Hi, Request to stop sending excel macros email on my email anwar.mun...@owb.com as I am unable to access the same. Thanks & Regards, Anwar Munshi Lead Coach OneWest Bank, FSB E-mail I.D. : anwar.mun...@owb.com -- FORUM RULES (986+ memb

$$Excel-Macros$$ Request for Office Stationery Samples files

Hi all Guys, A Humble request from my side is that i need Samples of Office Stationery maintaining format Examples like A4, Legal Papers purchased and how much utilized by which person, In a similar format whole office Stationery how much the staff is utilizing i am supposed to maintain the recor

Re: $$Excel-Macros$$ Request for Directory Audit Macro

Look in the vba help index for DIR From: crazybond Sent: Wednesday, August 17, 2011 3:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Request for Directory Audit Macro Hi Experts, Can a vba code/macro be created/ is available in case one needs to do the audit on the

Re: $$Excel-Macros$$ Request for Directory Audit Macro

http://akoul.blogspot.com/2011/07/print-file-names-in-folder-to-excel-on.html http://akoul.blogspot.com/2011/06/rename-files-in-vba.html On Thu, Aug 18, 2011 at 5:27 AM, XLS S wrote: > Hey Crazybond, > > Please find the attachment ... > > On Thu, Aug 18, 2011 at 2:00 AM, crazybond wro

Re: $$Excel-Macros$$ Request for Directory Audit Macro

cel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Request for Directory Audit Macro > > > > Look in the vba help index for DIR > > > > From: crazybond > > Sent: Wednesday, August 17, 2011 3:30 PM > > To: excel-macros@googlegroups.com > > Subjec

Re: $$Excel-Macros$$ Request for Directory Audit Macro

jan_Verma > wrote: > > Try the attached Workbook, > > > > > > > > From: excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] > > On Behalf Of dguillett1 > > Sent: Thursday, August 18, 2011 2:54 AM > > > > To: excel-macros@goo

Re: $$Excel-Macros$$ request to separate the no

try this udf Function numeric_value(x As String) Dim a As String a = "" For i = 1 To Len(x) If IsNumeric(Mid(x, i, 1)) Then a = a & Mid(x, i, 1) End If Next i numeric_value = a End Function On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad wrote: > hi experts, > > how to separate the number, > i m

Re: $$Excel-Macros$$ request to separate the no

hi ashish koul, please provide the example attachment. regards, shivaprasad. On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote: > try this udf > > Function numeric_value(x As String) > Dim a As String > a = "" > For i = 1 To Len(x) > If IsNumeric(Mid(x, i, 1)) Then > a = a & Mid(x, i, 1) >

Re: $$Excel-Macros$$ request to separate the no

can u share any excel file with input and output u like to have On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad wrote: > hi ashish koul, > > please provide the example attachment. > > > regards, > shivaprasad. > > > On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote: > >> try this udf >> >> Funct

Re: $$Excel-Macros$$ request to separate the no

hi ashish koul, please find the attachment of example. i mentioned formula also but showing 0 value. please provide the macro. regards, shivaprasad. On Fri, Oct 19, 2012 at 9:02 PM, ashish koul wrote: > can u share any excel file with input and output u like to have > > > On Fri, Oct 19, 20

Re: $$Excel-Macros$$ request to separate the no

check the attachment see if it helps On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad wrote: > hi ashish koul, > > please find the attachment of example. > > i mentioned formula also but showing 0 value. > please provide the macro. > > > regards, > shivaprasad. > > On Fri, Oct 19, 2012 at 9:02 PM,

Re: $$Excel-Macros$$ request to separate the no

hi ashsih koul, it is working very thanks , regards, shivaprasad. On Fri, Oct 19, 2012 at 9:16 PM, ashish koul wrote: > check the attachment see if it helps > > > On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad > wrote: > >> hi ashish koul, >> >> please find the attachment of example. >> >

$$Excel-Macros$$ Request Macro for Merge Text file

Dear All, Please find below is my request to create excel macro. I have a list of files in local directory and file list located in A column and need to merge text file based on the B column listed files. A1---B1 C:\1.txt --- C:\Merge\1.txt C:\2.txt --- C:\3.txt --- C:\4.tx

$$Excel-Macros$$ Request Help to make code more efficient.

Hello all fellow fellow Macro friends :) I have a short bit of code that I was wondering if it's possible to make it run more efficiently. When it runs currently it takes up to 1 minute which seems like a long time. Notes: This is designed to remove an entire row if the condition is met. There is

$$Excel-Macros$$ Request for formula:Unique value from same month

Hi All Champs I will Request all anyone suggest me unique value from same month (formula) Regards Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

RE: $$Excel-Macros$$ Request Help to make code more efficient.

ample file? Regards - Dave. > Date: Tue, 6 Apr 2010 08:18:05 -0700 > Subject: $$Excel-Macros$$ Request Help to make code more efficient. > From: jsin...@gmail.com > To: excel-macros@googlegroups.com > > Hello all fellow fellow Macro friends :) > > I have a short bit of

Re: $$Excel-Macros$$ Request Help to make code more efficient.

HI, Try out the following: Sub trial() Dim rng As Range Dim what(9) As String what(1) = "FD" what(2) = "EX" what(3) = "NA" what(4) = "NB" what(5) = "NC" what(6) = "HN" what(7) = "CLD" what(8) = "Location" what(9) = "of" For i = 1 To 9 Do Se

Re: $$Excel-Macros$$ Request Help to make code more efficient.

Thanks you two, I integrated both suggestions into my vba and it processed instantly. Very helpful :) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ Request for :Hide cell formula & Protect that cell

Hi all Champs Can anybody tell me how to protect specific cell & hide that cell formula only.I know how hide it (Format cell-hidden..).No one see that formula & edit that cell only. Regards Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM R

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

=MAX(IF(MONTH($E$7:$E$27)=MONTH(H8),$F$7:$F$27,"")) press + ctlr + shift+ enter On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > Hi All Champs > > I will Request all anyone suggest me unique value from same month (formula) > > Regards > Amar > > > -- > Join official Facebook page of thi

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

Hi Amar, Try this array formula =INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0)) On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > Hi All Champs > > I will Request all anyone suggest me unique value from same month (formula) > > Regards > Amar > > > -- > Join offic

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

Thanks Very much Ashish Sir & Excel user group On Wed, Dec 12, 2012 at 12:00 AM, Ms Excel user wrote: > Hi Amar, > > Try this array formula > =INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0)) > > > > > > On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > >> Hi All Champs >

$$Excel-Macros$$ request to hlp me on the attached file query

Hi, I have a data range in sheet 1 and in sheet 2 i want to view some specific information as attached. Please help me on this. Thanks in advance. Regards, Konark Vyas --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros

$$Excel-Macros$$ Request to help me on the attached file query

> Hi, > > I have a data range in sheet 1 and in sheet 2 i want to view some specific > information as attached. Please help me on this. > > Thanks in advance. > > > > Regards, > > Konark Vyas > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at h

Re: $$Excel-Macros$$ Request for :Hide cell formula & Protect that cell

Hi Protect sheet n keep cell format as locked. Thanks//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: amar takale Sender: excel-macros@googlegroups.com Date: Wed, 28 Nov 2012 12:42:16 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Request

$$Excel-Macros$$ Request for adding my new mail Id to this group

Hi Admin, Hope you are doing good. *Please add my new mail ID usrecruiter9...@gmail.com to this group. My other mail ID khaza3...@gmail.com is already added to this group. So please add my new ID also to this group to be in touch with the latest requirements for all these group members.* T

$$Excel-Macros$$ Request: A macro to check for my winning lotto numbers . . .

I've been seeking a solution to what would appear to be a simple problem. OK, I get my lotto tickets. And usually, on the site I can check the history to see if my lotto numbers have come up. That's fine if you have only one ticket you're checking, but what if you play the same five tickets every

$$Excel-Macros$$ Request for spreadsheets that have charts using treadlines to show increase or decrease in percentag

Hi, I have a new project at work. to create a spreadsheet that shows percentage increases and decreases based on categories. Would like to do a trendline showing the history of this. does anyone have a spreadsheet with data and that type of chart along with the calculations you could send me