+ Reply to Thread
Results 1 to 12 of 12

Workbook(s) With ALL Native Worksheet Function Samples

  1. #1
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Workbook(s) With ALL Native Worksheet Function Samples

    I would be very interested in seeing a workbook(or set of) that shows examples of ALL native worksheet functions.

    It should include descriptions(proper example, what it does, what it is used for & how to use it).

    Is anything like this available?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    Maybe this will help:

    http://www.techonthenet.com/excel/formulas/

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    Or here

    http://www.excelfunctions.net/

    or here

    http://office.microsoft.com/en-us/ex...010079186.aspx

    This is the Excel Function Dictionary which is pretty much what you asked for (an Excel file containing most functions):

    http://www.xlfdic.com/
    Last edited by Cutter; 03-31-2012 at 06:23 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    Thank you all for your contributions. These reference resources are great.

  5. #5
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    @Dennis7849, didn't you PM me asking can you offer to give solutions to members for a charge?, if that's you (and i'll check my pm's) why on earth would you be asking for something that, as a person who would give paid solutions, would or should already know?

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    @Dennis7849: What's the "Best of El Mirage Award 2011"? And why have you got a picture with 2012 on it? Is that like smoke and mirrors?

    I didn't notice any mention of Office/Excel on your site ...

  7. #7
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    I'm assuming he means best of El Mirage in Arizona (best of financial advisors), must be a local award. As for the "..awarded the 2011..." and it showing 2012, photoshop maybe :D

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    @Dennis7849:
    I would be very interested in seeing a workbook(or set of) that shows examples of ALL native worksheet functions.

    It should include descriptions(proper example, what it does, what it is used for & how to use it).

    Are you planning on selling it ... or just the expertise that you will attribute to it?

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    Hi Simon

    It would be Dennis & he has been warned not to offer his services.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  10. #10
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    It's just an excercise trying to bring his website ranking up, it was launched around 8 months ago, is ranked more than 10 millionth place and boasts some stuff on their homepage which is just tosh!

  11. #11
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    As is the code he offers, I doubt whether anyone would get value for money with the Excel code examples he has posted so far.

  12. #12
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Workbook(s) With ALL Native Worksheet Function Samples

    With forums and the amount of help out there on the interwebs, why would anyone pay for such things?
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1