Koncord Applied Excel Functions

We have uploaded some applied Excel functions. These are some basic functions, but very much useful in day-to-day working. This Excel file include some functions of string parsing, dates, telephone number parsing, and coordinates parsing.

Following is the link:
Koncord Applied Excel Functions


Following is the Terms of Services of Koncord Partners: http://koncordpartners.blogspot.com/2010/06/terms-of-services.html

4 comments:

  1. AnonymousJune 23, 2010 at 1:56 PM

    First part delimited by ",":=LEFT(H2,SEARCH(",",H2,1)-1)
    Second part delimited by ",":column 1:=SEARCH(",",H2,1)
    Column 2:=MID(H2,SEARCH(",",H2,1)+1,SEARCH(",",H2,Col1)-SEARCH(",",H2,1)-1)

    ReplyDelete
  2. KoncordAugust 11, 2010 at 8:59 AM

    Updated to version 1.3.

    ReplyDelete
  3. KoncordDecember 7, 2010 at 4:26 PM

    Following is listed functions:

    COMPARE CELLS
    First argument to compare
    If same return TRUE

    COORDINATES
    Argument of latitude in format of N 44D 02M 01S
    Argument of longitude in format of W 79D 27M 29S

    DISTANCE CALCUATION
    Latitude argument of start point
    34.236581

    LEAP YEAR
    12/29/04
    Is this year a leap year

    LAST DAY OF A MONTH
    Date to be input
    12/29/04
    Last day of last month
    Last day of current month
    Last date of last month
    Last date of current month

    MONTH IN TEXT
    3/1/09
    Last month
    Current month

    MONTH NUMBER IN FISCAL YEAR
    Fiscal year ending March 31
    3/1/09
    Fiscal year ending June 30
    12/29/04
    Fiscal year ending September 30
    12/29/04

    NUMBER FIND
    Argument to be input
    If this cell is of number
    Find number at right end

    NUMBER OF DAYS IN A MONTH
    Date to be input
    1/1/00
    Number of days of last month
    Number of days of current month

    OCCURENCY OF SUBSTRING
    Delimiter: ","
    Delimiter: ";"
    Delimiter: "."
    Delimiter: Space
    Delimiter: "@"
    Delimiter: "-"
    Delimiter: "+"
    Delimiter: "("
    Delimiter: "/"
    Delimiter: "and"

    PHONE NUMBER PARSE - NORTH AMERICA
    Phone number to be input
    (987) 654-3210

    SAME DAY OF
    Today's date
    Today's day
    Same date of last month today
    Same day of last month today

    SEPARATE ACCORDING TO DELIMITER
    Delimiter: ","
    Delimiter: "," Exclusive
    Delimiter: ";"
    Delimiter: "<"
    Delimiter: "@"
    Delimiter: "@" Exclusive
    Delimiter: "."
    Delimiter: "·"
    Delimiter: "+"
    Delimiter: Space

    Last Delimiter: "."
    Last Delimiter: Space

    Last Delimiter: "."
    Last Delimiter: Space
    Last Delimiter: "("

    SUBSTITUTE
    Replace ";" by ","
    Replace ";" by Space
    Replace "_" by Space

    TRIM
    Trim spaces at both ends
    Trim "-" at both end
    Trim "," at right end
    Trim "<" at right end
    Trim ">" at right end
    Trim "@" at right end
    Trim "+" at right end
    Trim "-" at right end

    ReplyDelete
  4. KoncordDecember 7, 2010 at 4:27 PM

    Now includes Kilometre, Nautical Mile, Statue Mile exchange, as well as IQM, standard deviation.

    ReplyDelete