INDEX This function picks a value from a range of data by looking down a specified number of rows and then across a specified number of columns. यह फंक्शन एक डाटा के दिए गए range से नीचे की ओर से number of rows और फिर दिए गए columns से डाटा उठाता है. Syntax There are various forms of syntax for this function. इस फंक्शन के लिए अनेक प्रकार का syntax है. Syntax 1 =INDEX(RangeToLookIn, Coordinate) […]
Read moreTo make a Function in Excel VBA Macro to Extract First Name Excel VBA में एक फंक्शन बनाना है, जो First Name या word को किसी सेल से निकाले. When we make a macro then we type Sub then macro name like copydata, example given below. जब हम Macro बनातें हैं, तो हम Sub से स्टार्ट करते हैं, फिर मैक्रो का नाम देते हैं. उदाहरण के लिए Sub copydata() End Sub But when we make any function in excel vba then […]
Read moreI have to extract first name from a cell in excel. हमें एक्सेल में एक cell से first नाम निकलना है. Here we have only one logic that from start to end, what is the position of first space in cell, we have deduct 1 in that position, then from left side we will pick number character with help of left function to extract first name. यहाँ हमें […]
Read moreEDATE With the use of Excel EDATE function, we add or subtract month, with a date. We use EDATE function to calculate Maturity Dates, Expiration Dates, Due Dates, Project Start Date, Project End Date. If we use month value as positive, then it will go future date, if we use month value as negative then it will go past date, if we use month value 0 then it will show same date. Here only month & year will be […]
Read moreIFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula. जब हम Excel में formula लगाते हैं तो कभी कभी error आता है, तो हम चाहते हैं कि अगर error आये तो उसके बदले, वो value आये जो हम mention करे , नहीं तो जो formula calculate कर रहा है, वो आये. When we type formula in […]
Read moreMaking Watch In Excel Vba From below vba code & video you can learn how to make watch in excel vba use on ontime VBA Function. Click Here to Download File Sub makingwatch() Dim cancel As Boolean If Range(“k1”).Value = True Then Exit Sub Else snd = Second(Now) minute1 = Minute(Now) hour_a = Hour(Now) Sheet1.Shapes.Range(Array(“snd_2”)).Rotation = 6 * snd Sheet1.Shapes.Range(Array(“minute_1”)).Rotation = […]
Read more