+ Reply to Thread
Results 1 to 12 of 12
  1. #1
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,478

    oh well you've got to try enough hits and you're rich

    in a recent post
    http://www.helpmeexcel.com/
    well i'm off to start my own web site
    i think
    "did you know that if you want to add 2 numbers together
    use in a cell =1+1"
    (i'll include a jpg of a cell to really illustrate the point as an added bonus)
    is a good staring point ,but i'm open to input.
    add a few advertisments then thats it !enough hits and i'l retire early(ish)
    Mojito connoisseur and a dabbler in Cisco
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    5,213

    Re: oh well you've got to try enough hits and you're rich

    It's far better than my non-existant Excel Help site. Wait, there's errors on that site. Maybe not. :/

  3. #3
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,379

    Re: oh well you've got to try enough hits and you're rich

    Ricardo told me off for telling OP that he/she should have the link in their signature rather than in their post ... he considered it a breach of the new Rule 13 re: competitors... really ?! A sad indictment on us all if that is indeed the case.

    I've lost count of how many blogs I've seen of this ilk... if you're going to blog at least make it top end - ie covering the freakish and unusual.
    But as Paul says something's better than nothing so credit where credit's due.

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,478

    Re: oh well you've got to try enough hits and you're rich

    i'm only taking the mick,btw is that a blog?,how do you do one? in the words of a certain Manuel "i know nothing"
    Mojito connoisseur and a dabbler in Cisco
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Forum Moderator romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Alibi
    MS-Off Ver
    All
    Posts
    8,262

    Re: oh well you've got to try enough hits and you're rich

    I love the REVERSE_FIND function on there. Not only does it return the position of the end of the find string rather than the start - why?? - but it also fails to use InStrRev for some reason (and I don't believe 97 compatibility is it!)
    So long, and thanks for all the fish.

  6. #6
    Forum Moderator NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003, 2007, 2010
    Posts
    31,163

    Re: oh well you've got to try enough hits and you're rich

    Quote Originally Posted by romperstomper View Post
    I love the REVERSE_FIND function on there. Not only does it return the position of the end of the find string rather than the start - why?? - but it also fails to use InStrRev for some reason (and I don't believe 97 compatibility is it!)
    Even at that, I don't know how they get 18... I count 17... unless there is a space up front.. (in that case, the so called excel expert needs to learn about not putting extra spaces in the text)...
    Microsoft MVP - Excel

    Where there is a will there are many ways. Pick One!


    Please read the Forum Rules

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

    Preferred Charities: Lupus Canada and Sick Kids Foundation.
    Feel Free to Donate if you want to, for the assistance you received today.

  7. #7
    Forum Guru Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264

    Re: oh well you've got to try enough hits and you're rich

    I enjoyed the Conditional Formatting formula - must remember that one as just using Search() would make the formula waaaayyyyy too short and unimpressive.
    Richard Schollar
    Microsoft MVP - Excel

  8. #8
    Forum Moderator NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003, 2007, 2010
    Posts
    31,163

    Re: oh well you've got to try enough hits and you're rich

    I didn't even go that far down the website to see that...

    that is indeed a douser...
    Microsoft MVP - Excel

    Where there is a will there are many ways. Pick One!


    Please read the Forum Rules

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

    Preferred Charities: Lupus Canada and Sick Kids Foundation.
    Feel Free to Donate if you want to, for the assistance you received today.

  9. #9
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,379

    Re: oh well you've got to try enough hits and you're rich

    I'm thinking we should all dedicate an hour to post feedback...

  10. #10
    Forum Guru
    Join Date
    01-03-2006
    Location
    Basingstoke, England
    MS-Off Ver
    2007 (work & home)
    Posts
    2,240

    Re: oh well you've got to try enough hits and you're rich

    ohhh man!

    It's not just the content - even the grammar is lacking a little something...
    (Please excuse my hypocrisy as I butcher some punctuation! )

    ...Or perhaps grammar is the area where they are trying for the "freakish and unusual" - unfortunately for the pandas amongst us (who don't "eat, shoot & leave"), sentences like some on that site, are starting to be more common, than they are unusual.
    Last edited by broro183; 03-04-2010 at 08:11 PM.
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

  11. #11
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: oh well you've got to try enough hits and you're rich

    found this in a post, I think it must be the site owner

    for more excel doubts. visit www.helpmeexcel.com
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

  12. #12
    Forum Moderator pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2010
    Posts
    5,141

    Re: oh well you've got to try enough hits and you're rich

    I think I need a web site
    regards pike

    If the solution helped please donate
    here to the RSPCA

    Sites worth visiting;

    J&R Solutions - royUK

    AJP Excel Information - Andy Pope

    Spreadsheet Toolbox

    JBeaucaires Excel Files

    VBA for smarties - snb

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.2.0