Re: $$Excel-Macros$$ Transpose macro

2017-05-09 Thread Gowrisankar Arthanari GSA
PFA On Tue, May 9, 2017 at 10:59 AM, Izhar wrote: > some changes are required in the attach macro > SCENARIO > when I run this macro it copies column A, and paste it in five column > starting column D, if i want it must be pasted into 7 column then what > must be changed in the macro > > > Than

Re: $$Excel-Macros$$ automation for advanced filter

2017-05-05 Thread Gowrisankar Arthanari GSA
Pls find the updated sheet. On Fri, May 5, 2017 at 9:31 PM, GENIUS wrote: > Hi gowri > > Thank you very much for your help, but there is a problem when I run it by > pressing F5 key it works perfectly first time but when i run it again by > pressing F8 key it does not show the proper result for

Re: $$Excel-Macros$$ automation for advanced filter

2017-05-04 Thread Gowrisankar Arthanari GSA
PFA On Thu, May 4, 2017 at 7:25 AM, Izhar wrote: > look at sheet1, I want to run the macro but there is a message, can > someone please check what's wrong with the code. 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) !

Re: $$Excel-Macros$$ Solve Query

2017-02-27 Thread Gowrisankar Arthanari GSA
PFA​ On Mon, Feb 27, 2017 at 4:18 PM, Ram ji wrote: > hey anyone solve the query > > -- > 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) U

Re: $$Excel-Macros$$ Net Ageing Formula Support Required

2016-11-24 Thread Gowrisankar Arthanari GSA
ld be 15 Days > Formula Ans is 92402 Days > > Thanks, > Krishnasamy. M > > On Thu, Nov 24, 2016 at 10:32 AM, Gowrisankar Arthanari GSA < > a.go...@gmail.com> wrote: > >> hi, >> >> you can try this function >> >> NETWORKDAYS.INTL(A2,B2,11,

Re: $$Excel-Macros$$ Net Ageing Formula Support Required

2016-11-23 Thread Gowrisankar Arthanari GSA
hi, you can try this function NETWORKDAYS.INTL(A2,B2,11,Holyday!$A$1:$A$13)​ Regards, A Gowrisankar On Thu, Nov 24, 2016 at 7:32 AM, Krishnasamy.M wrote: > Hi All, > > Good Day !!! > > Need Your support to get Net Ageing with below two conditions. > > (i).Excluded Sundays > (ii) Excluded Holi

Re: $$Excel-Macros$$ Excel Table to HTML table

2016-09-12 Thread Gowrisankar Arthanari GSA
yes, its one type of HTML code​ On Mon, Sep 12, 2016 at 4:14 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > i have notepad++ to view the code but,when i open that code it shows only > numbers not the text. > > On Sep 12, 2016 4:09 PM, "Gowrisankar Arthanari G

Re: $$Excel-Macros$$ Excel Table to HTML table

2016-09-12 Thread Gowrisankar Arthanari GSA
2016 2:11 PM, "Devendra Sahay" > wrote: > >> Thanks for the help, will check the HTML code in the tool and share the >> response. >> >> On Sep 12, 2016 1:31 PM, "Gowrisankar Arthanari GSA" >> wrote: >> >> Find the updated one. it

Re: $$Excel-Macros$$ Excel Table to HTML table

2016-09-12 Thread Gowrisankar Arthanari GSA
y. > > > On Mon, Sep 12, 2016 at 12:30 PM, Gowrisankar Arthanari GSA < > a.go...@gmail.com> wrote: > >> PFA​ >> >> On Mon, Sep 12, 2016 at 12:27 PM, Devendra Sahay < >> devendrasahanypt...@gmail.com> wrote: >> >>> Hi Guys, >>> >&

Re: $$Excel-Macros$$ Excel Table to HTML table

2016-09-12 Thread Gowrisankar Arthanari GSA
PFA​ On Mon, Sep 12, 2016 at 12:27 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Guys, > > Is there any other possible way to do this, Please help guys. > > On Sat, Sep 10, 2016 at 1:43 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > >> Hi, >> >> Have tried all th

Re: $$Excel-Macros$$ Age Calculation & Sumifs

2016-07-24 Thread Gowrisankar Arthanari GSA
Pls find the attached sheet with formula​ Regards, A Gowrisankar On Sat, Jul 23, 2016 at 3:55 PM, सचिन शर्मा wrote: > Dear All, > > Please help to resolve the below Questions. > > *Q.1* *Please write the formula in Cell C6 to show tha deiffrence between > mention Dates as " 36 Years 8 Month 20

Re: $$Excel-Macros$$ Formula required

2016-06-22 Thread Gowrisankar Arthanari GSA
​you can try this, 1 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-1),$A$2:$A$21)) 2 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-2),$A$2:$A$21)) 3 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)+1),$A$2:$A$21)) 4 =SUM(IF(RANK($A$2:$A$21,$A$2:$A

Re: $$Excel-Macros$$ Re: Presenting Chart..Need help

2016-06-06 Thread Gowrisankar Arthanari GSA
please find the attachment.​ On Mon, Jun 6, 2016 at 3:15 PM, SG wrote: > Hi Experts, > > Please help. > > On Monday, June 6, 2016 at 1:46:58 PM UTC+5:30, SG wrote: >> >> Hi Experts, >> >> I need your help in presenting the week wise time used in an account. >> What i need is to prepare a chart i

Re: $$Excel-Macros$$ Vlookup Matching Issue

2016-05-23 Thread Gowrisankar Arthanari GSA
Hi, in lookup value, at end " " is available. to clear this use the following formula =CLEAN(SUBSTITUTE(B3,CHAR(160),CHAR(17))) Regards, A Gowrisankar ​ On Sun, May 22, 2016 at 4:21 PM, Bill Q wrote: > Hi, > > PSA. > > Trying to do a simple vlookup. I cleaned up the data by trimming, but > st

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

2016-04-29 Thread Gowrisankar Arthanari GSA
; On Fri, Apr 29, 2016 at 1:22 AM, Gowrisankar Arthanari GSA < > a.go...@gmail.com> wrote: > >> hi, >> >> PFA >> >> Regards, >> A Gowrisankar​ >> >> On Fri, Apr 29, 2016 at 10:20 AM, vikas khen wrote: >> >>> Hi Experts!!! &g

Re: $$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2016-04-29 Thread Gowrisankar Arthanari GSA
​hi, PFA Regards, A Gowrisankar On Fri, Apr 29, 2016 at 12:05 PM, bhavna srivas wrote: > I am facing a problem with a macro. Here we have 4 sheet , say sheet1 > sheet2 sheet3.(data) > sheet(output sheet) ..PLEASE TO REFER TO THE ATTACHED XLS > > Target is a common variable and first column in a

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

2016-04-29 Thread Gowrisankar Arthanari GSA
hi, PFA Regards, A Gowrisankar​ On Fri, Apr 29, 2016 at 10:20 AM, vikas khen wrote: > Hi Experts!!! > > Any Hope regarding on this?? > > Warm Regards, > Vikkhe1 > > On Thu, Apr 28, 2016 at 6:55 PM, vikas khen wrote: > >> Hi Team, >> >> >> >> Please find the attached sheet in which there are t