Consulting

Results 1 to 4 of 4

Thread: The "BEST" formula function in Excel:

  1. #1
    VBAX Mentor asingh's Avatar
    Joined
    Jul 2005
    Posts
    307
    Location

    The "BEST" formula function in Excel:

    Hi,

    Wanted to start a thread to get views on Native Excel funtions....want to know...what people think..

    1. The Best Excel Formula Function..? -- and why..?
    2. Most used Formula Function..?
    3. Formula Function you could not live without...?

    Examples would be : vlookup, sumif, countif...etc....No UDF's please.....!

    I know the answers would be debatable/and vary as per user..but lets see....????

    regards,

    asingh

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,233
    Location
    Best.

    IMO has to be somthing simple like SUMIF/COUNTIF, because it is efficient, it has a conditional facility, the conditional facility is quite flexible (not enough, but we never get Nirvana), and with the use of helper cells, it can cater for myriads of situations.

    Most Used.

    Must be IF or SUM mustn't it, just by the very nature of their simplicity, immediacy basic quality?

    Can't Live Without.

    I think that would be VLOOKUP in my case, it is very convenient to hold data in a table format, and lookup various columns as required.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Master
    Joined
    Jun 2007
    Location
    East Sussex
    Posts
    1,110
    Location
    It depends on so many things, like what line of work you are in and what version of Excel you have. For me:
    1. Best: I'd agree with SUMIF for 2003 and prior; SUMIFS or IFERROR for 2007.
    2. Most used has to be SUM, or + by people converted from other spreadsheet programs.
    3. Couldn't live without: SUMPRODUCT, INDEX and MATCH.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    VBAX Regular
    Joined
    Aug 2007
    Location
    Hungary Budapest
    Posts
    53
    Location
    it is really depend what we would like to do...
    i use a office2k pro and i could'nt live w/o my func:
    [VBA]
    function workweek(mdate as date) as interger
    workweek=format(mdate,"ww")
    end function
    [/VBA]
    L@ja

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •