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. > > Background: Daily basis there are some transactions getting

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 > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this foru

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 * On Sat, Mar 31, 2018 at 3:51 PM, Will Sob wrote: > Ok thanks > > > On Sat, 31 Mar 2018, 13:50 Rabindra Thapa, > wrote: > >> Formula is ok for y

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

2018-03-31 Thread Rabindra Thapa
to > have a comma > > On Sat, Mar 31, 2018 at 12:47 PM, Rabindra Thapa > wrote: > >> fyi >> >> *Regards,* >> >> >> >> *For quick responds click here for Message * >> >> On Sat, Mar 31, 2018 at 12:33 PM, Will Sob wrote: >>

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

2018-03-31 Thread Rabindra Thapa
look like 6,14,23 and row 41 319 to 3,19 > > On Sat, Mar 31, 2018 at 9:53 AM, Rabindra Thapa > wrote: > >> explain more. may i help you in this task ! >> >> *Regards,* >> >> >> >> *For quick responds click here for Message * >> >> On

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 data (E10:J52) and for this data to appear on Colu

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 non-blank then stops. > But it did fill in the

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 example. > > A1 = 10 > B1 = 20 > C1 = 5 > D1 = where i w

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 Next Rows in "All Data" sheet. > > -- > Are you =EXP(

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 > > Thanks > Kenil > > -- > Are you =EXP(E:RT) or =N

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 if this > isn't?) > > The approach is this: > Estab

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

2017-09-21 Thread Rabindra Thapa
xcel-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. > > > > > > Last Date > > =INDEX(Sheet1!$C:$C,MA

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-16 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 an excel formula > > > > > > -- > Are you =EXP(E:RT) or

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 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 to sheet 2 . > > ki

$$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 wa

$$Excel-Macros$$ convert Hijri date to Grogorian date.

2016-05-09 Thread Rabindra Thapa
Dear Experts, Could you pls suggest me how can i convert Hijri date to Grogorian dates by using VBA code or formula in attach file. -- Regards, Rabindra Thapa www.facebook.com/TraveltheNepal. -- 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$$ Re: needed formula to convert hejri date to gregorian date

2016-05-09 Thread Rabindra Thapa
stions/827201-gregorian-hijri-date-conversion.html > > > On Sun, May 8, 2016 at 7:54 PM, Rabindra Thapa > wrote: > >> FYI... >> >> On Sun, May 8, 2016 at 7:45 PM, Rabindra Thapa >> wrote: >> >>> Dear Experts, >

$$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 wrote: > Dear Experts, > > Please help me toconvert hejri date to gregorian date as per attach file. > > > > -- > > Regards, > r.thapa > -- Regards, Rabindra Thapa www.facebook.com/TraveltheNepal. -

$$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

$$Excel-Macros$$ How to calculate total hour by using formula

2016-04-30 Thread Rabindra Thapa
Dear Excel Guru, I need help for calculate total hour by using formula.. Date Employee name In Time OUT Time Total Time 1/3/2016 Rabin 9:00:00 19:00:00 ??? Regards, Rabindra 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

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: e

$$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 its

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 (¨`•.•

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

2010-02-12 Thread Rabindra Thapa
---- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.c

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

2010-02-11 Thread Rabindra Thapa
<><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the gro

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

2009-07-18 Thread Rabindra Thapa
t; Change subtotal-formula in the cells J1 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 > wrote: > >> I required when i filter, the filtered row should be display on oth

$$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 wrote: > Thank for your kind information. > > Have a good day. > > On Wed, Jul 15, 2009 at 4:51 PM, Naveen Sharma > wrote: > >> Hi R

$$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 wrote: > Hi Rabindara, > > Solution is attached. Please have a look. > > Naveen Sharma > > > > On 7/15/09, Rabindra Thapa wrote: >> >> Hello Guys, &g

$$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$$ Excel display left to write

2009-05-16 Thread Rabindra Thapa
Hello guys, My Excel 2007 colum and row display left to write(Arabic). Could you suggest me how to creat the standard one(Right to left) Awaiting for Reply -- 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 wrote: > please mail ur file. > > On Sat, Jan 17, 2009 at 8:08 PM, Rabindra Thapa > wrote: > >> i protected by password on my working files but after long time when i >> try to open it , i can't pleas

$$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$$ Help-Excel files formula

2009-02-03 Thread Rabindra Thapa
Please help me on attach files. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`·.·´¨)¸.·´ `·.¸.·«*:·. .·:* *:·. *«*:·. .·:* *:·. --~--~-~--~~~---~--~~ Visit the blog to download Excel

$$Excel-Macros$$ Re: foget password

2009-01-20 Thread Rabindra Thapa
On Mon, Jan 19, 2009 at 7:23 AM, shay shay wrote: > please mail ur file. > > On Sat, Jan 17, 2009 at 8:08 PM, Rabindra Thapa > wrote: > >> i protected by password on my working files but after long time when i >> try to open it , i can't pleas

$$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, s