Re: $$Excel-Macros$$ Question

On Tue, Oct 18, 2016 at 3:23 PM, सचिन शर्मा wrote: > Dear All, > > Please help to resolve the attached Question > > -- > 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 @ >

$$Excel-Macros$$ Question

Dear All, Please help to resolve the attached Question -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.

$$Excel-Macros$$ QUESTION FOR SOLVER

in the attachment, there is no figure in column F and in column N there is an average if i need the averages as per my requirements then how can I get through solver, please show the steps.. thanks in advance... -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

Thank you for your help On Monday, 11 January 2016 10:11:15 UTC+5, Abhi wrote: > > When you are subtracting, you are excluding the start date. > > > > On Mon, Jan 11, 2016 at 10:30 AM, Izhar > wrote: > >> Please open the attachment see the question. >> Thanks in advance.

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

but if we subtract 4-2 we get 2 and and then add the same two into 2 we get 4 then why in the date if I take a loan from a bank, the banker wont include the first date in view of applying markup rate on my loan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

When you are subtracting, you are excluding the start date. On Mon, Jan 11, 2016 at 10:30 AM, Izhar wrote: > Please open the attachment see the question. > Thanks in advance. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

$$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

Please open the attachment see the question. Thanks in advance. -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Question : Form control of Excel 2007

Ashish Sir, Thank you. This is working. You have solved my big problem. With Regards, *Suyog* On Wednesday, 3 July 2013 20:23:41 UTC+5:30, ashish wrote: try this macro see if it helps Sub add_comboboxes() Dim rng As Range Dim cl As Range Dim shp As Shape For Each shp In

$$Excel-Macros$$ Question : Form control of Excel 2007

Hello All, I've created one form control copy and paste them all the way down the column, hoping that the linked cell will get auto update like normally happens while copy-pasting of any normal formula. Now I've to set all individually set up the cell link for each one. Is there anyway of

Re: $$Excel-Macros$$ Question : Form control of Excel 2007

try this macro see if it helps Sub add_comboboxes() Dim rng As Range Dim cl As Range Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type = msoFormControl Then shp.Delete Next Set rng = Range(b3:b10) For Each cl In rng ActiveSheet.DropDowns.Add(cl.Left,

Re: $$Excel-Macros$$ Question about function

Thanks for the reply. 2013/7/3 Waseem Saifi waseemsa...@gmail.com Dear Van, I have placed a formula in first sheet in K column. it might help you. On Mon, Jul 1, 2013 at 12:47 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column numbered F.

Re: $$Excel-Macros$$ Question about function

Thanks for your help Please thank. 2013/7/1 De Premor d...@premor.net istied using SUMPRODUCT, we can also use SUM with CSE {=SUM(--($C$2:C2=C2)) . (TEXT(B2,dd/mm/)) - D2} Rgds, [dp] On 01/07/2013 7:33, Norman Cliff May wrote: If the countif function is not available to you, the

Re: $$Excel-Macros$$ Question about function

Change the formula in J2 from =F2G2H2I2D2 to =F2G2TEXT(H2,dd/mm/)I2D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column numbered F. Question 2: In column J, How to connect string (F G H I D), without losing

Re: $$Excel-Macros$$ Question about function

Another suggestion would be to put the following formula in cell E2 and copy down. =COUNTIF($C$2:C2,C2). (TEXT(B2,dd/mm/)) - D2 Delete the columns to the right of column E On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the

Re: $$Excel-Macros$$ Question about function

If the countif function is not available to you, the following formula should work in cell E2 and copy down. =SUMPRODUCT(--($C$2:C2=C2)). (TEXT(B2,dd/mm/)) - D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column

Re: $$Excel-Macros$$ Question about function

istied using SUMPRODUCT, we can also use SUM with CSE {=SUM(--($C$2:C2=C2)) . (TEXT(B2,dd/mm/)) - D2} Rgds, [dp] On 01/07/2013 7:33, Norman Cliff May wrote: If the countif function is not available to you, the following formula should work in cell E2 and copy down.

$$Excel-Macros$$ Question on SumProduct Formula

Hi All, I am seeing many examples of SUMPRODUCT formula on this forum and very interested in using this in my assignment. I see that this formula is very short and fast. I am presently using SUMIFS for most of my calculations, where I am creating the SUMIF formula in a cell by concatenating

$$Excel-Macros$$ Question on My Menu !!

Hello All, I'm using Ashish Sir's My Menu ver 1.6 very frequently that increased my working speed in excel. I'm really thankful for same. Please refer attached my question regarding insert option of my menu. Please advice on my question. With Best Regards, Suyog -- Join official facebook

Re: $$Excel-Macros$$ Question chart

Hi Anil, a lot of thanks! for help me, you reduced my workload of a month, in some moment. Thanks Pravesh On 9/7/12, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Pravesh, See i have changed the dropdown working . pls do the color , as i'm busy with other work. On Fri, Sep

Re: $$Excel-Macros$$ Question chart

-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Question chart Why is your request more URGENT than any other request?? When all else fails, read the f___ing instructions 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Question chart

Dear Pravesh, See i have changed the dropdown working . pls do the color , as i'm busy with other work. On Fri, Sep 7, 2012 at 9:48 AM, PRAVESH KUMAR wrote: HI Team, please help me to solve this queston it's very urgent. solve asap. -- Thanks Regards Pravesh Kumar -- Join

$$Excel-Macros$$ question for noorani

how can we get excel 4 functions?any resource? Date: Tue, 29 May 2012 15:31:25 +0530 Subject: Re: $$Excel-Macros$$ MACRO From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Sagar, Please find attached study material of Basic Macro and follow excel-macro group on regular

Re: $$Excel-Macros$$ question for noorani

Dear Danial, Best Resource of Excel4 Function is : *http://www.cpearson.com/excel/Call.htm* -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 3:35 PM, danial mansoor danial_...@hotmail.comwrote: how can we get excel 4

Re: $$Excel-Macros$$ question for noorani

The link provided below has a lot to do with the CALL function which is not supported in latest versions of Excel. If you want to learn about XLM functions (Excel4), try this link which has an in-depth explanation of the GET.DOCUMENT and GET.CELL functions

RE: $$Excel-Macros$$ Question in Excel

Try this: From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neil johnson Sent: Jan/Tue/2012 10:05 To: excel-macros Subject: $$Excel-Macros$$ Question in Excel Hi, I make dummy sheet to get to know , where i am facing problem , and I marked

Re: $$Excel-Macros$$ Question in Excel

*To:* excel-macros *Subject:* $$Excel-Macros$$ Question in Excel ** ** Hi, ** ** I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find

$$Excel-Macros$$ Question in Excel

Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Question in Excel

*Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil johnson neil.jh...@googlemail.comwrote: Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your

Re: $$Excel-Macros$$ Question in Excel

Thanks a lots . On Tue, Jan 17, 2012 at 10:41 AM, Maries talk2mar...@gmail.com wrote: *Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil johnson neil.jh...@googlemail.comwrote: Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color

Re: $$Excel-Macros$$ Question in Excel

Dear Kapil, Pls see attached sheet with Index+Small On Tue, Jan 17, 2012 at 11:08 AM, neil johnson neil.jh...@googlemail.comwrote: Thanks a lots . On Tue, Jan 17, 2012 at 10:41 AM, Maries talk2mar...@gmail.com wrote: *Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil

Re: $$Excel-Macros$$ Question in Excel

Thanks Noor Ji, For your quick reply. On Tue, Jan 17, 2012 at 11:38 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kapil, Pls see attached sheet with Index+Small On Tue, Jan 17, 2012 at 11:08 AM, neil johnson neil.jh...@googlemail.comwrote: Thanks a lots . On Tue, Jan 17,

Re: $$Excel-Macros$$ Question

hu On Tue, Aug 9, 2011 at 4:06 AM, dguillett1 dguille...@gmail.com wrote: Homework? -Original Message- From: XLS S Sent: Monday, August 08, 2011 3:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Question Q-1 )    Can I write VBA code to protect

$$Excel-Macros$$ Question

Q-1 )Can I write VBA code to protect or unprotect my VB Project? Q-2) Why does Excel have two macro languages? Q-3) Can I lock cells such that only specific users can modify them? Q-4) When I enter a value, it appears with two decimal places. For example, when I enter 123 it shows

Re: $$Excel-Macros$$ Question

Homework? -Original Message- From: XLS S Sent: Monday, August 08, 2011 3:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Question Q-1 )Can I write VBA code to protect or unprotect my VB Project? Q-2) Why does Excel have two macro languages? Q-3) Can I

RE: $$Excel-Macros$$ Question regarding Sheets

Sent: Friday, July 22, 2011 8:04 PM To: excel-macros Subject: $$Excel-Macros$$ Question regarding Sheets Hi all, I have two sheets . in these sheets i have data in two tabes name BT BT-1 I want to consolidate respectively tab. (BT from sheets 1 and BT (Tabs) from sheet 2 both data should

$$Excel-Macros$$ Question on VBA

Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) However, I can do it if I seperate it as follows: worksheets(sheet1).range(cells(x,1):cells(x,6).copy

RE: $$Excel-Macros$$ Question on VBA

d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Ming Envoyé : mardi 28 juin 2011 14:42 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Question on VBA Hi all, I have written below syntax but got an error but I can't figure out why

Re: $$Excel-Macros$$ Question on VBA

*instead of : you should use , while using cells in range reference* On Tue, Jun 28, 2011 at 6:12 PM, Ming mingtam...@gmail.com wrote: Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy

Re: $$Excel-Macros$$ Question on VBA

[mailto:excel-macros@googlegroups.com] De la part de Ming Envoyé : mardi 28 juin 2011 14:42 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Question on VBA Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy

Re: $$Excel-Macros$$ Question on VBA

Thanks Rakesh, as I would like to get the copy range changed depending on the variable I set in the macro. Actually, the code I wrote is something like below x = worksheetfunction.counta(worksheets(Sheet1).range(a:a)) worksheets(Sheet1).range(cells(3,1),cells(x,1)).copy . . Sorry I am new

$$Excel-Macros$$ Question for you Excel Masters out there...

Greetings, I have a question I am hoping to find the answer of here... I have a spreadsheet that signifies that includes revenue which is represented on my pivot charts as bars represented by a month (a good example but I could come up with others of course). Simple enough right? Well what if I

$$Excel-Macros$$ Question on Pivots

Hi, I have a testing scenario where I have Severity (Critical, High, Medium Low) and I have modules as Insurance, Claims, etc. When I take a pivot, I want to combine all the module information in the body of the pivot showing Severity in Row labels and all the other info under summation of Total

$$Excel-Macros$$ Question about excel

Hello, I have details in summary sheet and i want the details posted to the respective sheet also. Do we have any method to have details posted to the respective sheets. Example in summary tab i have west region details and the entire row of west should also be in West sheet also is there any

Re: $$Excel-Macros$$ Question about list box

Hello, Your answer lies in the properties of list box which are given below. Add a list box (Form control) 1. If the *Developer* tab is not available, display it. [image: Show]Display the *Developer*

$$Excel-Macros$$ Question about list box

Hi Sir, - *I am not understanding that Code : When I use listbox.value it shows index number like 0 in excel sheet. While When I use listbox.list(listindex) display the value correctly. * *What is difference between them. * Thanks and Regards --

Re: $$Excel-Macros$$ Question about excel report

try this formula =MID(CELL(address,Sheet1!A1),FIND(],CELL(address,Sheet1!A1))+1,99) = Sheet1!A1 On Fri, Sep 3, 2010 at 6:08 AM, jjsmd jschwart...@gmail.com wrote: Hi:  I am new to excel and I was wondering hiw I would do the following.  I have an excel worksheet with names of people in a

Fwd: $$Excel-Macros$$ Question asked in Interview...

-- Forwarded message -- From: Ahmed Honest ahmedhon...@gmail.com Date: Sun, Aug 8, 2010 at 12:08 PM Subject: Re: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hai, Our Favourite buddy in this group Mr. Dave has already given attention and replied to your query

Fwd: $$Excel-Macros$$ Question asked in Interview...

048542 -- Forwarded message -- From: Vijay Kr. Aggarwal vjaggarwal2...@gmail.com Date: Sat, Aug 7, 2010 at 9:16 AM Subject: Fwd: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hello Friends, Waiting for reply Regards, Vijay

Re: $$Excel-Macros$$ Question asked in Interview...

-- Forwarded message -- From: Vijay Kr. Aggarwal vjaggarwal2...@gmail.com Date: Sat, Aug 7, 2010 at 9:16 AM Subject: Fwd: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hello Friends, Waiting for reply Regards, Vijay -- Forwarded message

Fwd: $$Excel-Macros$$ Question asked in Interview...

Hello Friends, Waiting for reply Regards, Vijay -- Forwarded message -- From: Vijay Kr. Aggarwal vjaggarwal2...@gmail.com Date: Fri, Aug 6, 2010 at 10:18 AM Subject: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hi, Please check

$$Excel-Macros$$ Question asked in Interview...

Hi, Please check attached file. Kindly provide answers through macro and functions. Regards, Vijay Kumar Aggarwal 048542 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

RE: $$Excel-Macros$$ Question re: cell comments and validated lists

I forgot to say that the drop-down is in C1 Regards - Dave. Date: Sun, 1 Aug 2010 01:36:25 -0700 Subject: $$Excel-Macros$$ Question re: cell comments and validated lists From: simon_mc_webs...@yahoo.co.uk To: excel-macros@googlegroups.com Good Evening Gurus, I have a quick question

Re: $$Excel-Macros$$ Question re: cell comments and validated lists

That's it exactly! Many thanks Dave, Sid. On 1 Aug, 13:32, Dave Bonallack davebonall...@hotmail.com wrote: I forgot to say that the drop-down is in C1 Regards - Dave. Date: Sun, 1 Aug 2010 01:36:25 -0700 Subject: $$Excel-Macros$$ Question re: cell comments and validated lists From

RE: $$Excel-Macros$$ Question re: cell comments and validated lists

You're welcome Dave. Date: Sun, 1 Aug 2010 10:24:21 -0700 Subject: Re: $$Excel-Macros$$ Question re: cell comments and validated lists From: simon_mc_webs...@yahoo.co.uk To: excel-macros@googlegroups.com That's it exactly! Many thanks Dave, Sid. On 1 Aug, 13:32, Dave Bonallack

$$Excel-Macros$$ *Question*: Match/Sumif functions to merge rows in in large datasheet

I am having some trouble figuring out a problem. Anyway, I am working with a large dataset, so it is obviously not efficient to do this by hand, so hopefully someone can help me out. This is how my spreadsheet is set up: Year|Last Name|First Name|$ amount|Cholesterol Level|Height|Weight

Re: $$Excel-Macros$$ *Question*: Match/Sumif functions to merge rows in in large datasheet

. let me know if you need a step-by-step example. Paul From: Skin matthew.bris...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, June 7, 2010 4:47:52 PM Subject: $$Excel-Macros$$ *Question*: Match/Sumif functions to merge rows

$$Excel-Macros$$ Question about Extract Number FROM Alphanumeric String

Hello! This website is a wonderful resource! Thank you so much for it. I have been slowly learning VBA on my own and often read through code to try to learn. My question concerns the sample provided by Shyam on March 30, Extract Number FROM Alphanumeric String. The function works wonderfully,

Re: $$Excel-Macros$$ Question about Index function

, 29 Mar 2010 16:38:39 -0700 Subject: $$Excel-Macros$$ Question about Index function From: tomfabtas...@hotmail.com To: excel-macros@googlegroups.com Hi, I have a formula that works, but I'm not sure how the INDEX function is working: =MATCH(1,INDEX(--(ATM!$C$3:$AJ$3=6),0),0

$$Excel-Macros$$ Question about Index function

Hi, I have a formula that works, but I'm not sure how the INDEX function is working: =MATCH(1,INDEX(--(ATM!$C$3:$AJ$3=6),0),0) The INDEX part of the above searches for a 6 in the range ATM!$C$3:$AJ $3. The -- appears to create an array. Is the -- shorthand for another function ? Regards, Tom

RE: $$Excel-Macros$$ Question about Index function

. The double negative outside the bracket changes these to 1's and 0's, which are then handed to the Match, which is looking for the first occurrence of 1. Regards - Dave, Date: Mon, 29 Mar 2010 16:38:39 -0700 Subject: $$Excel-Macros$$ Question about Index function From: tomfabtas

$$Excel-Macros$$ Question about QueryTable

In VBA is there a way to create a dynamic QueryTable? I have a website to which I need to post different variables. When the webpage returns, I need to import a table into a worksheet then post another parameter and then import those results, etc. Is there a way to do this? --

$$Excel-Macros$$ Question

Hi firends My Question is how to convert numerical in words to in Ms Excel ? -- sudhir --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Question

Hi all friends Please sent me any excel file which is define the macro. i can't understand the macro in excel and i always think that what its use in excel. Thanking U Have nice Day!!! Sudhir Kumar --~--~-~--~~~---~--~~

$$Excel-Macros$$ Question: on Application.GetOpenFilename command

When you used the Application.GetOpenFilename command. Is there a way to make the file opened a active window so that I can store the filename as a string. This is what I am doing so far and it is not working. OpenFile_2 = Application.GetOpenFilename(FileFilter:=Excel Files

$$Excel-Macros$$ Question about validation

Hello, I use validation to select a value from an area to be inserten in the new location. It works fine, but . . . It takes the value from the source cell instead of a reference. So when I change the value in the source cell the new value that I copied from there with the validated list, does

$$Excel-Macros$$ Question about validation

Hello, I use validation to select a value from an area to be inserten in the new location. It works fine, but . . . It takes the value from the source cell instead of a reference. So when I change the value in the source cell the new value that I copied from there with the validated list, does

$$Excel-Macros$$ Question

I am trying to input a loop While/Wend with If statements in between but it's showing me this code as an error: While InputSheet.Cells(iInputRow, 2) Does anyone have a clue why??? Help would be really appreciated!! Thanks a lot! Ana --~--~-~--~~~---~--~~