thank u so much...it's working completely.
*Thanks & Regards,Sunil Kumar Yadav*
On Mon, Sep 1, 2014 at 6:48 PM, Vaibhav Joshi wrote:
> Check this..
>
> Cheers!!
>
>
> On Mon, Sep 1, 2014 at 6:36 PM, Sunil Kumar Yadav
> wrote:
>
>> Hello Friends
1:="=*GPRS*", Operator:=xlAnd
Range("M1").Select
ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=13,
Criteria1:="5", Operator:=xlFilterValues
Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
Range("N1:N102000
filter GPRS in column D after that software not found 5
in Column H then macro fill correct in all number against like 2,6,7,8...i
want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it.
*Thanks & Regards,Sunil Kumar Yadav*
On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi w
Hi,
Anybody revert on this please!!!
*Thanks & Regards,Sunil Kumar Yadav*
On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav
wrote:
> Sorry sir, but i think u r not understand what i want, may be in this my
> mistake...i tell you again!
>
>
> please find the enclos
ds,Sunil Kumar Yadav*
On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi wrote:
> It means if you find GPRS & 5 then only you want to paste "Correct" am i
> right?
>
>
> On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav
> wrote:
>
>> Sorry sir, but i think u r n
yeah :-), it is absolutely working as per my requirement.
Thank you so much! :-)
*Thanks & Regards,Sunil Kumar Yadav*
On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi wrote:
> Ok, i goofed up in last stat..
>
> Check this now..
>
>
> On Thu, Sep 4, 2014 at 1:51 PM, Suni
Yes, Vaibhav Bhai is rock in VBA, his coding explanation is very sample for
understanding.
*Thanks & Regards,Sunil Kumar Yadav*
On Thu, Sep 4, 2014 at 5:23 PM, Ashish Kumar
wrote:
> Vaibhav Bhai,
>
> Superb solutions according to the requirement.
>
>
> Regards
> As
really amazing!!!
*Thanks & Regards,Sunil Kumar Yadav*
On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi wrote:
> Hi,
>
> No posts since morning thought of sharing amazing excel formulas by Bill
> Jelen aka Mr. Excel.
>
> Cheers!!
> +
> *I did not do this for you.
Hi kanwaljit
Can u explain me how to work your formula, max right i understand but minus
why using twice!
Pls explain it i know little more array function.
On Oct 9, 2014 10:36 PM, "Kanwaljit Singh Dhunna"
wrote:
> Have a Look !
>
> I hope you are aware of how to enter an Array Formula !
>
> On
Dear All,
I have two query for automatically update value on one fixed date, have
created formula but need dynamic formula.
Formula:
IF(TODAY()<=42750,0,IF(AND(TODAY()>=42751,TODAY()<=42781),1.5,IF(AND(TODAY()>=42782,TODAY()<=42809),3,IF(AND(TODAY()>=42810,TODAY()<=42840),4.5,IF(AND(TODAY()>=4284
doubling the number and removing the
> decimal portion
> (extract just the integer portion)
> then divide it by 2:
> =INT(A23*2)/2
>
> this works for your samples.
>
> hope this helps.
>
>
>
> *Paul*
> ---------
>
>
>
>
as ever you can.” - John Wesley*
-
On Saturday, March 4, 2017 12:10 AM, Sunil Kumar Yadav <
sk.yadav7...@gmail.com> wrote:
Dear Paul,
Thank you so much for your support but I don't have need formula
calculation start from today. It should be start from my provi
Dear Paul,
I have need your help for this query. Please guide me.
--
*Sky*
"Good, Better, Best!
*Always listen to your heart, because there lives your parents.*
--
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 th
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Sun
Dear Team,
I want to pick rental pro-rata/monthly as per purchasing date.
Pro-rata - If purchasing date after 1st then rental will be calculated
days-wise(count)
monthly - If purchasing date 1st then rental will be paid full.
--
*Sky*
"Good, Better, Best!
*Always listen to your heart, because
Dear Paul,
I want to formula in one column not month-wise separately.
Please guide me!
On Fri, Mar 17, 2017 at 12:44 PM, Sunil Kumar Yadav
wrote:
> Dear Team,
>
> I want to pick rental pro-rata/monthly as per purchasing date.
>
> Pro-rata - If purchasing date after 1st then
> On Fri, 3/17/17, derrickandrew994 via MS EXCEL AND VBA
> MACROS
> wrote:
>
>Subject: Re: $$Excel-Macros$$ How to pick rental on
> pro-rata/monthly basis as per date
>To: excel-macros@googlegroups.com
> Date: Friday, Ma
Dear Members,
I have one file for Transpose query but now i need this formula in
reversal(opposite) condition...Data in sheet2 format and need to change in
sheet1 format.
Please guide me!
--
*Sky*
"Good, Better, Best!
*Always listen to your heart, because there lives your parents.*
--
Are you
cause you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit
ails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
T
:07 PM, Sunil Kumar Yadav
wrote:
> Hello Ashish,
>
> below formula is working same then why have you used MOD in your formula,
> please little explain!
>
> INT(B3-A3)&IF(INT(B3-A3)=1," day, "," days, ")&HOUR(B3-A3)&" hours,
> "&M
]
--
Thanks
*Sunil Kumar Yadav*
On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> Below code is not work to check duplicate value, please know me problem in
> code.
>
> For q = 5 To 1000
> If Worksheets("BankData").Cells(q, 4).Value =
&
Ok Sorry next time i will keep in my mind.
On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi wrote:
> Dear Ashish Bhalara
>
> What exactly you are doing, can you pl explain..
>
> On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara
> wrote:
>
>> Dear experts,
>>
>> Below code is not work to check duplica
]
--
Thanks
*Sunil Kumar Yadav*
--
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. Poor thread titles, like Please
Hi Myself Sunil Yadav from Delhi. I'm a Sr. MIS Executive in Telecom Sector
and recently learned VBA. Excel is my passion i want to learn more and more
things about excel and thanks to Vaibhav Sir and Mr. Ashish who guide me
everytime when i ask any query!
--
Thanks & Regards
Sunil Kumar
Dear Experts,
I want to know, what can i use choose formula in this file for get the date
1 2 3 etc.
--
Thanks & Regards
Sunil Kumar Yadav
--
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 @
h
Good sir :-) and Thank you
Sunil
On Mon, Feb 9, 2015 at 3:40 PM, Vaibhav Joshi wrote:
> Hi
>
> Use this array formula instead=:
>
> =INDIRECT("'Attn. Sheet.xlsx'!"&TEXT(DATE($B$1,Month,1),"MMM"))
>
> check att..
>
>
> Cheers!
;Attn.
> Sheet.xlsx'!Jun,'Attn. Sheet.xlsx'!Jul,'Attn. Sheet.xlsx'!Aug,'Attn.
> Sheet.xlsx'!Sep,'Attn. Sheet.xlsx'!Oct,'Attn. Sheet.xlsx'!Nov,'Attn.
> Sheet.xlsx'!Dec)
>
> Cheers!!
>
> On Mon, Feb 9, 2015 at 7:14 P
Dear
Team,
PFA file and check my query.
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
--
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/discusse
Hello,
Please solve this query!!!
--
Thanks & Regards
*Sunil Kumar Yadav*
* Sr. Executive - *MIS (Billing Deptt.)
Skype ID: sunil.yadav7186
On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Yadav
wrote:
> Dear
> Team,
>
> PFA file and check my query.
>
>
> --
> Tha
Awesome Sir :-) and thanks
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Wed, Mar 25, 2015 at 2:13 PM, Vaibhav Joshi wrote:
> check formula in col E, If there are more than 2 case of overlap then 1st
> will be shown as ok & second will be as error.
>
>
Great Sir
Thanks,
Sunil Kr. Yadav
Sent from my ASUS
On 31-Mar-2015 1:36 pm, "Vaibhav Joshi" wrote:
> Hi Bob,
>
> Check attachment,
>
> Copy formula from G2 & Select A2 to D12 ( or larger range) & goto
> conditional formatting, select manage rules & select new rule, after that
> select use formu
Dear Team,
i have read this type query on many sites but not understand properly,
please write the code in my file for my data!!!
Example file enclosed
Please help!!!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An
,
Sunil Kr. Yadav
Sent from my ASUS
On 25-Apr-2015 12:17 pm, "Vaibhav Joshi" wrote:
> hi
>
> What do you mean by "when sometime no record of LF found then other data
> past on state sheet with error"??
>
> You mean no additional data found ?
>
> On Fri
hi...pls any revert
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav
wrote:
> My means sometimes LF invoice no. not exist in data that time my filter
> query got error bcoz filtered value blank i want to query
Thank u so much
it's working as per my requirement :-)
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja
wrote:
> check this out code given
>
>
> Regards,
> Mandeep Baluja
>
> On Monday, April 27
Dear Mandeep,
I need to some modification in this, when no record of LF exist in this
data then your query showing error and stop it but I want to go on next
step(copy other data) without error or stop
Please also check my coding!!!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skyp
hanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Mon, Apr 27, 2015 at 5:41 PM, Mandeep Baluja
wrote:
> change activesheet to Sheets("sheet1")
>
>
> On Monday, April 27, 2015 at 5:41:00 PM UTC+5:30, Mandeep Baluja wrote:
>>
>> Sub Getvalues()
>
Thank you so muchnow it's working absolutely!!!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Tue, Apr 28, 2015 at 2:52 PM, Mandeep Baluja
wrote:
> Sub Getvalues()
>
> Dim r As Range
> lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
>
PFA
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N wrote:
> Dear team,
>
> Need a help on storing the date in the required format in macro.
>
> I can able to do but i showing the current date not the actual date.
Welcome!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Fri, Jul 10, 2015 at 12:14 PM, Ganesh N wrote:
> Thanks bro
>
> Regards,
> GN
>
> On Thu, Jul 9, 2015 at 1:45 PM, Sunil Kumar Yadav
> wrote:
>
>> PFA
>>
>> --
>>
, Please guide me
any coding for this so that i can run my ID on Mozilla.
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
--
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 @
h
Dear Vaibhav Sir
Please look into this matter!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Sat, Jul 11, 2015 at 12:45 PM, Sunil Kumar Yadav
wrote:
> Hello Team,
>
> i have created gmail login query only for example but now i want to run
> this is
Dear Siraj,
Coding is absolutely fine need to just defined variables...Please check Dim
line!
and add "on error resume next" anywhere in coding for Error handling.
Dear Mandeep Sir,
i m also learner...Excellent Job sir!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yad
Hi Soumyendu,
PDF
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Sat, Jul 11, 2015 at 8:48 AM, Soumyendu Paul
wrote:
> Dear All,
>
> My query for attached file When we select data from drop down A cursor to
> move A6;when we select B from drop down curs
Hi Team,
Please revert on this!!!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Sun, Jul 19, 2015 at 11:51 AM, Sunil Kumar Yadav
wrote:
> Hi Experts
>
> I need your little help...please check my file i want to call my sub
> processors for three stages..
Thanks,
Sunil Kr. Yadav
Sent from my ASUS
On 25-Jul-2015 5:35 pm, "Ashish Kumar" wrote:
> Dear Sunil Kumar Yadav,
>
> Don't violating our group rules. Go thru our group rules once before
> posting your queries.
>
>
> Regards
> Ashish Kumar
>
>
>
Dear Mr. Ashish,
Can u tell me what's wrong in my query?
Thanks,
Sunil Kr. Yadav
Sent from my ASUS
On 25-Jul-2015 5:35 pm, "Ashish Kumar" wrote:
> Dear Sunil Kumar Yadav,
>
> Don't violating our group rules. Go thru our group rules once before
> posting your
Hello,
Please check enclosed file.
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Tue, Jul 28, 2015 at 1:13 AM, raghu wrote:
> Hi All
>
> We have planned some execution of test cases daily. I would like to have
> the test conditions planned till dat
No thank you…I'm also learner!
On Mon, Oct 26, 2015 at 6:10 PM, Gary Dinges
wrote:
> Thank You Sir!
>
> Gary
>
> On Friday, October 23, 2015 at 2:47:17 PM UTC-4, Gary Dinges wrote:
>
>> I will start by saying I did search group looking for answer to my issue,
>> but didn't find, or understand wh
U can use this but formula is very long:
Blank cell will be blank!
IF(B1="","",IF(6<=LEN(B1),B1,IF(LEN(REPT("1",6))<=LEN(B1),0,"AB")&REPT("0",(7-LEN(B1)-2))&B1))
On Thu, Feb 18, 2016 at 6:25 PM, Paul Schreiner
wrote:
> If you REALLY want to shorten your formula:
>
> the =concatenate() function
check it...maybe this is helpful...because i m also learner :-)
On Fri, Feb 19, 2016 at 11:43 AM, Kat wrote:
> Hi guys,
>
> I would like to copy paste entire row from king sheet to queen sheet if
> the cells in range "B2:B" has the value of "update" in king sheet. However,
> I have copy area and
53 matches
Mail list logo