Excel Formulas Functions

13 thoughts on “Excel Formulas Functions

  1. Kailash Pati Malakar

    Dr.Dinesh Takyar
    Sir,
    I am aged about 63 years but i desire to learn excel VBA , Excel code, it’s nothing but because of your Technique & Video presentation with touching every point greatly inspired me to learn from you.I will be very greatful to you if kindly help me how to fix rupee next to ten in MS Excel

    Reply
        1. Kelli

          men have only a very limited set of ways to be sexy and stay masculine at the same time (despite the patriarchy myth that men are inherently more sexual than wo#;8&mn230e. incongruity at its finest)So, yea, I do think that a lot of sexuality (the ways we express desire, the ways we preform sexual appeal) is learned and influenced by the culture we live in.

          Reply
  2. Firdaus

    Sir,
    I have been learning a lot from your videos (THANK YOU!) and i had a query that i was hoping you would show a tutorial on, or give me a solution for.

    In the attached Excel file (copied below), i want to add code to Send a Reminder 120 days before the document expiration date, to the respective email recipient in column D that he needs to review the respective Master ID in Column A, whose corresponding supplier is in Column E.
    A B C D E
    1 Master ID Document Expiration Date REMARKS Email Test Supplier
    2 MA-00412-Lake-2012 7/19/2014 Send Reminder fbgrape@gmail.com ABC
    3 MA-00409-Lake-2012 12/31/2015 fsbinvest@gmail.com LMN
    4 MA-00415-Lake-2011 12/31/2014 fbgrape@gmail.com LMN
    5 MA-00380-Lake-2012 1/24/2013 Send Reminder fsbinvest@gmail.com PQR

    For example: 120 days before B2, D2 should get an email with following Subject: “A2 for Supplier E2 is up for Review”

    Similarly, D5 should get his specific email saying “A5 for Supplier E5 is up for Review”.

    Sir, can you help me? Looking forward to your response.

    Thank you,
    Firdaus

    Reply
    1. biswajit bose

      i want to learn excel VBA , Excel code, our Technique & Video presentation is very good it’s inspired me to learn from you.I will be very greatful to you if kindly help me how to know.
      biswajit

      Reply ↓

      Reply
  3. krishna

    Sir
    I am really fond of your excel training. Really good work. I am wondering whether you got any video for sharing workbook . I created database in excel with several user forms in excel. I want to share the workbook in common drive for multiple users. When I share it using review tab I am getting error. Please help sir

    Reply
  4. Kazi

    Sir,
    I would like to do the following thing, but don’t know how to do. Hoping your assistance.

    For example: i have PN2014.2001 in a cell, and I have another excel workbook with the same file name. I would like to bring some data from that work book if cell content=file name, I mean it’s PN2014.2001.

    Your assistance is much appreciated.

    Reply
  5. Hareesh Pabbati

    Sir,

    All of your videos are very good and much useful. Actually at preset i am working with preperation of some VBA code for my database for retriving records.

    The Problem :

    Please check the below raw data from a text file in column A :

    fcalias name AMRAU1413_HBA2D99 vsan 21
    pwwn 21:00:00:1b:32:94:2d:99

    fcalias name AMRAU1414_HBA3F28 vsan 21
    pwwn 21:00:00:1b:32:95:3f:28

    fcalias name CHICUGA01MXP_HBA52FE vsan 21
    pwwn 10:00:00:00:c9:40:52:fe

    fcalias name CHIDRXOR01DM_HBAFC27 vsan 21
    pwwn 10:00:00:00:c9:4e:fc:27

    fcalias name CHIICSQ01SS_HBA422A vsan 21
    pwwn 10:00:00:00:c9:53:42:2a
    pwwn 10:00:00:00:c9:53:48:08
    pwwn 10:00:00:00:c9:62:c5:e9
    pwwn 10:00:00:00:c9:62:96:b3

    The expected expected output to be as follows in the other worksheet.

    fcalias name AMRAU1413_HBA2D99 vsan 21 pwwn 21:00:00:1b:32:94:2d:99
    fcalias name AMRAU1414_HBA3F28 vsan 21 pwwn 21:00:00:1b:32:95:3f:28
    fcalias name CHICUGA01MXP_HBA52FE vsan 21 pwwn 10:00:00:00:c9:40:52:fe
    fcalias name CHIDRXOR01DM_HBAFC27 vsan 21 pwwn 10:00:00:00:c9:4e:fc:27

    fcalias name CHIICSQ01SS_HBA422A vsan 21 pwwn 10:00:00:00:c9:53:42:2a
    fcalias name CHIICSQ01SS_HBA422A vsan 21 pwwn 10:00:00:00:c9:53:48:08
    fcalias name CHIICSQ01SS_HBA422A vsan 21 pwwn 10:00:00:00:c9:62:c5:e9
    fcalias name CHIICSQ01SS_HBA422A vsan 21 pwwn 10:00:00:00:c9:62:96:b3

    For the first 4 records i can able to process sucessfully into the other sheet but i got struk with last record because of inconsistant input from a text file and can please help me how we can overcome this problem.

    Thanks and awaiting for your reply.

    Regards,
    Hareesh

    Reply
  6. Tangi

    Sir, I would like a function that returns age group automatically after I have entered age number, for example , column 1 is titled “Age” and column 2 is titled “Agegroup”, so when i enter 14 as age or 20 or 35 in a age culumn, then the other column titled agegroup returns the range or group in which that age falls..

    Reply
  7. Mujeeb Ahmed

    Hi Sir, I have been following you from some of your help from your video’s and making my work easy I thank you for all. Sir I have a question and it is my problem I wanted to make a translation work Thur macro or VBA ?
    I found some formula codes from web site regarding it. I’m not able to find how to work on it..
    Sir I’m posting the code below so can u plz help me by video or mail or replying in here.

    Sir I’m not an expert & well educated person on this it just my passion to work on it & learning to get knowledge..

    Option Explicit

    Private Const strSHORTCODES As String = “,en,af,sq,ar,hy,az,eu,be,bn,bg,ca,zh,hr,cs,da,nl,eo,et,tl,fi,fr,gl,ka,de,el,gu,ht,iw,hi,hu,is,id,ga,it,ja,kn,ko,lo,la,lv ,lt,mk,ms,mt,no,fa,pl,pt-PT,ro,ru,sr,sk,sl,es,sw,sv,ta,te,th,tr,uk,ur,vi,cy,yi”

    Public Enum eLanguage
    auto_detect = 0
    english = 1
    afrikaans = 2
    Albanian = 3
    Arabic = 4
    Armenian = 5
    Azerbaijani = 6
    Basque = 7
    Belarusian = 8
    Bengali = 9
    Bulgarian = 10
    Catalan = 11
    Chinese = 12
    Croatian = 13
    Czech = 14
    Danish = 15
    Dutch = 16
    Esperanto = 17
    Estonian = 18
    Filipino = 19
    Finnish = 20
    French = 21
    Galician = 22
    Georgian = 23
    German = 24
    Greek = 25
    Gujarati = 26
    Haitian_Creole = 27
    Hebrew = 28
    Hindi = 29
    Hungarian = 30
    Icelandic = 31
    Indonesian = 32
    Irish = 33
    Italian = 34
    Japanese = 35
    Kannada = 36
    Korean = 37
    Lao = 38
    Latin = 39
    Latvian = 40
    Lithuanian = 41
    Macedonian = 42
    Malay = 43
    Maltese = 44
    Norwegian = 45
    Persian = 46
    Polish = 47
    Portuguese = 48
    Romanian = 49
    Russian = 50
    Serbian = 51
    Slovak = 52
    Slovenian = 53
    Spanish = 54
    Swahili = 55
    Swedish = 56
    Tamil = 57
    Telugu = 58
    Thai = 59
    Turkish = 60
    Ukrainian = 61
    Urdu = 62
    Vietnamese = 63
    Welsh = 64
    Yiddish = 65
    End Enum

    Public Function Translate(ByVal strText As String, _
    Optional ByVal eFrom As eLanguage = auto_detect, _
    Optional ByVal eTo As eLanguage = english, _
    Optional ByVal blnPhonetic As Boolean = False) As String

    Dim strUrl
    Dim strTransText As String
    Dim strResult As String
    Dim varSplitText As Variant
    Dim lngItem As Long

    If strText = “” Then
    Translate = “”
    Exit Function
    End If

    strText = URLEncode(strText)

    strUrl = “http://translate.google.com/translate_a/t?client=t&text={S}&hl=en&sl={F}&tl={T}&multires=1&pc=0&rom=1&sc=1”

    strUrl = Replace$(strUrl, “{S}”, strText)
    strUrl = Replace$(strUrl, “{F}”, Split(strSHORTCODES, “,”)(eFrom))
    strUrl = Replace$(strUrl, “{T}”, Split(strSHORTCODES, “,”)(eTo))

    With CreateObject(“MSXML2.XMLHTTP”)
    Call .Open(“get”, strUrl, False)
    Call .Send
    strResult = .responseText
    End With

    varSplitText = Split(Split(strResult, “]],”)(0), “[“)
    Dim delimitChar As String
    delimitChar = Chr(34) & “,” ‘Chr(34) is the character for ”
    If Not blnPhonetic Then
    For lngItem = 3 To UBound(varSplitText)
    strTransText = strTransText & Split(varSplitText(lngItem), delimitChar)(0)
    Next
    Else
    For lngItem = 3 To UBound(varSplitText)
    strTransText = strTransText & Split(varSplitText(lngItem), delimitChar)(2)
    Next
    End If
    strResult = Replace(strTransText, “”””, “”)

    Translate = strResult
    End Function

    This is it..

    I’m looking forward for your help..

    Thank you
    Regards
    Mujeeb Ahmed.

    Reply
    1. Mujeeb

      Hi dear Sir,
      I’m still waiting for your help with this above posted information about translator..
      Looking forward to hearing from you.
      Thank you.
      Regards
      Mujeeb Ahmed.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *