Re: $$Excel-Macros$$ Excel Formula - Help needed

2018-05-26 Thread Rabindra Thapa
​hope this attached fulfill your requirement.​ *Regards,* *For quick responds click here for Message * On Sun, May 13, 2018 at 6:16 AM, KAUSHIK SAVLA wrote: > Hi All, > > Attached is the excel file which I am referring for help. > >

Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula

2018-04-28 Thread Rabindra Thapa
#N/A Should be remove from column G *Regards,* *For quick responds click here for Message * On Sat, Apr 28, 2018 at 11:46 AM, amar takale wrote: > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ IF and Index, Match formula

2018-03-31 Thread Rabindra Thapa
if you not need extra column just add all fromula in one cell *Regards,* *For quick responds click here for Message <vhr.ad...@arabianfal.com>* On Sat, Mar 31, 2018 at 3:51 PM, Will Sob <will00...@gmail.com> wrote: > Ok thanks > > > On Sat, 31 Mar 2018, 13:50 Rabi

Re: $$Excel-Macros$$ IF and Index, Match formula

2018-03-31 Thread Rabindra Thapa
ommas; I only want numbers that are pairs or triple only to > have a comma > > On Sat, Mar 31, 2018 at 12:47 PM, Rabindra Thapa <rabinthapa2...@gmail.com > > wrote: > >> fyi >> >> *Regards,* >> >> >> >> *For quick responds click he

Re: $$Excel-Macros$$ IF and Index, Match formula

2018-03-31 Thread Rabindra Thapa
formula that puts a comma in between > like row Row S39 to look like 6,14,23 and row 41 319 to 3,19 > > On Sat, Mar 31, 2018 at 9:53 AM, Rabindra Thapa <rabinthapa2...@gmail.com> > wrote: > >> explain more. may i help you in this task ! >> >> *Regards,* >&

Re: $$Excel-Macros$$ IF and Index, Match formula

2018-03-31 Thread Rabindra Thapa
explain more. may i help you in this task ! *Regards,* *For quick responds click here for Message * On Thu, Mar 29, 2018 at 7:07 PM, Will Sob wrote: > I need the help with formula to retrieve the data highlighted in yellow > from the List of

Re: $$Excel-Macros$$ Re: Filling in blank cells with names

2018-03-20 Thread Rabindra Thapa
remove stop code. *Regards,* *For quick responds click here for Message * On Mon, Mar 12, 2018 at 10:59 PM, Johnny wrote: > Hi David, thanks for responding! When I run this macro, it actually does > fill the column down until it hits the second

Re: $$Excel-Macros$$ Need Help in IF formula

2018-02-14 Thread Rabindra Thapa
*Regards,* *For quick responds click here for Message * On Mon, Feb 12, 2018 at 9:31 AM, Ruchin Gupta wrote: > I have a table where data changes continously (stock market data). I want > to apply IF formula. please understand with given

Re: $$Excel-Macros$$ Copy Paste to next sheet

2018-02-10 Thread Rabindra Thapa
*Regards,* *For quick responds click here for Message * On Thu, Feb 1, 2018 at 10:34 AM, KATHIRVELAN N wrote: > Dear Experts, > > Please some one help me to copy paste the row from "Data Entry" Sheet to "All > Data" sheet. > > Copy to Next

Re: $$Excel-Macros$$ Need formula for 2 criterias

2018-02-03 Thread Rabindra Thapa
*Regards,* *For quick responds click here for Message * On Sat, Feb 3, 2018 at 2:13 PM, Kenil Gala wrote: > Hi > Pls Find the file attached. > > I have written my Query in the excel sheet. > > Please help me find the solution for this query > >

Re: $$Excel-Macros$$ Formula for Month wise calculation

2017-09-29 Thread Rabindra Thapa
Dear Mr. Paul, Thanks :) *Regards,* *For quick responds click here for Message * On Fri, Sep 29, 2017 at 3:18 PM, Paul Schreiner wrote: > This is pretty "convoluted" logic. > I tried several approaches that soon became extremely complex (as

Re: $$Excel-Macros$$ Help Req.

2017-09-21 Thread Rabindra Thapa
help if formula will implement at sheet 2 > > > > *From:* excel-macros@googlegroups.com [mailto:excel-macros@ > googlegroups.com] *On Behalf Of *Rabindra Thapa > *Sent:* 20 September 2017 03:46 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help Req. &

Re: $$Excel-Macros$$ Help Req.

2017-09-20 Thread Rabindra Thapa
Last Date =INDEX(Sheet1!$C:$C,MATCH($A2,Sheet1!$A$2:$A$11270,0)+(COUNTIF(Sheet1!$A:$A,$A2))) Second Last Date =INDEX(Sheet1!$C:$C,MATCH($A2,Sheet1!$A$2:$A$11270,0)+(COUNTIF(Sheet1!$A:$A,$A2))-1) if need for quantity wise, have to use vba *Regards,* *For quick responds click here for Message

Re: $$Excel-Macros$$ Help Req.

2017-09-17 Thread Rabindra Thapa
=RIGHT(B3,2) *Regards,* *For quick responds click here for Message * On Sat, Sep 16, 2017 at 7:17 PM, Neeraj Gmail wrote: > Dear experts, > > > > Kindly find the sheet I want to put last two entries against Indus ID, can > we solve with

Re: $$Excel-Macros$$ Help to create data table

2016-06-10 Thread Rabindra Thapa
? On Fri, Jun 10, 2016 at 12:06 AM, Rabindra Thapa <rabinthapa2...@gmail.com> wrote: > Dear Excel guru, > > Can you give a idea how to create date enter sheet as per attach file.. > > i.e when i entry data on sheet 1 and entry press button, that data > automatically go

$$Excel-Macros$$ Help to create data table

2016-06-09 Thread Rabindra Thapa
Dear Excel guru, Can you give a idea how to create date enter sheet as per attach file.. i.e when i entry data on sheet 1 and entry press button, that data automatically go to sheet 2 . kindly see the attach file. Regards, Rabin -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Re: needed formula to convert hejri date to gregorian date

2016-05-09 Thread Rabindra Thapa
.mrexcel.com/forum/excel-questions/827201-gregorian-hijri-date-conversion.html > > > On Sun, May 8, 2016 at 7:54 PM, Rabindra Thapa <rabinthapa2...@gmail.com> > wrote: > >> FYI... >> >> On Sun, May 8, 2016 at 7:45 PM, Rabindra Thapa <rabinthapa2...@gmail.com>

$$Excel-Macros$$ Re: needed formula to convert hejri date to gregorian date

2016-05-08 Thread Rabindra Thapa
FYI... On Sun, May 8, 2016 at 7:45 PM, Rabindra Thapa <rabinthapa2...@gmail.com> wrote: > Dear Experts, > > Please help me toconvert hejri date to gregorian date as per attach file. > > > > -- > > Regards, > r.thapa > -- Regards, Rabindra Thapa www.fa

$$Excel-Macros$$ needed formula to convert hejri date to gregorian date

2016-05-08 Thread Rabindra Thapa
Dear Experts, Please help me toconvert hejri date to gregorian date as per attach file. -- Regards, r.thapa -- 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

RE: $$Excel-Macros$$ How to use validation on repeated word/Number

2012-04-28 Thread Rabindra Thapa
Thanks NOORAIN ANSARI, Rajan Verma CoRe for solved my query. Best Regards, Rabindra cid:image002.gif@01CC7D01.9571E350 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rabindra Thapa Sent: Friday, April 27, 2012 2:35 AM To: excel-macros

$$Excel-Macros$$ How to use validation on repeated word/Number

2012-04-26 Thread Rabindra Thapa
Dear All, I am making large data sheet of company name list. My concern is when data entry time if same company name repeat, excel will show me the notification that whether want to cancel or Keep for same company name on list. Please see the attach file for more detail. Best

$$Excel-Macros$$ Please help on Excel.

2011-03-08 Thread Rabindra Thapa
Dear all, I have one attach file where I am keeping the serial pipe number but the problem is I am getting the same pipe number many times and it's hard to search whether provide pipe number are reported or not. Can u have any formula/validation i.e. when I type the reported pipe number

RE: $$Excel-Macros$$ Dear Group Help Me Regarding Conditional Formatting

2010-06-06 Thread Rabindra Thapa
Find the attach sheet...hope it ok for you. Rabindra Thapa Main:    +974 4 768 111 Direct:   +974 4 768 233 Fax:  +974 4 11 4595 GSM:    +974 5 61 1915 Doha, Qatar We can't Spell S_ccess without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-11 Thread Rabindra Thapa
friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Dear all, its really interesting file to listen music. Thanks to Mr. Harmeet. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling

$$Excel-Macros$$ Re: Required help on subtotal function.

2009-07-18 Thread Rabindra Thapa
and J3 to StrSubTotal(B6:B12) and so on. Hope this helps. Akhilesh Kumar Karna On Thu, Jul 16, 2009 at 7:58 PM, Rabindra Thapa rabinthapa2...@gmail.com wrote: I required when i filter, the filtered row should be display on other column. On Thu, Jul 16, 2009 at 1:19 PM, Rabindra Thapa

$$Excel-Macros$$ Re: Required help on subtotal function.

2009-07-16 Thread Rabindra Thapa
Thank for your kind information. Have a good day. On Wed, Jul 15, 2009 at 4:51 PM, Naveen Sharma nsharma110...@gmail.comwrote: Hi Rabindara, Solution is attached. Please have a look. Naveen Sharma On 7/15/09, Rabindra Thapa rabinthapa2...@gmail.com wrote: Hello Guys, can somebody

$$Excel-Macros$$ Re: Required help on subtotal function.

2009-07-16 Thread Rabindra Thapa
I required when i filter, the filtered row should be display on other column. On Thu, Jul 16, 2009 at 1:19 PM, Rabindra Thapa rabinthapa2...@gmail.comwrote: Thank for your kind information. Have a good day. On Wed, Jul 15, 2009 at 4:51 PM, Naveen Sharma nsharma110...@gmail.comwrote

$$Excel-Macros$$ Required help on subtotal function.

2009-07-15 Thread Rabindra Thapa
Hello Guys, can somebody help me on attach file. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling

$$Excel-Macros$$ Re: foget password

2009-04-03 Thread Rabindra Thapa
thanks, On Mon, Jan 19, 2009 at 8:23 AM, shay shay shahinarafi...@gmail.com wrote: please mail ur file. On Sat, Jan 17, 2009 at 8:08 PM, Rabindra Thapa rabinthapa2...@gmail.comwrote: i protected by password on my working files but after long time when i try to open it , i can't please

$$Excel-Macros$$ How to use VBA

2009-03-03 Thread Rabindra Thapa
hey guys let me know about VBA. Awaiting for it -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling

$$Excel-Macros$$ foget password

2009-01-18 Thread Rabindra Thapa
i protected by password on my working files but after long time when i try to open it , i can't please advise me how to open my files. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group,