+ Reply to Thread
Results 1 to 22 of 22

1000 and 10

  1. #1
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    1000 and 10

    It has taken 10 years but I have eventually got to my 1000th post.


    click on the * Add Reputation if this was useful or entertaining.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: 1000 and 10

    I guess, congratulations?
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: 1000 and 10

    Thank you.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: 1000 and 10

    Congrats on your 1st 1K
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    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,093

    Re: 1000 and 10

    That mean it's going to be 320 years before you match Ford?
    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


  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: 1000 and 10

    @ Tevor - 32?

    or are you counting on my posts continuing to climb?

  7. #7
    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,093

    Re: 1000 and 10

    No, 10 years for 1000; you have 32,000+. So, 32,000 / 1000 x 10. Good example for a spreadsheet, maybe?

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: 1000 and 10

    OK, I was having a brain pharght LOL

  9. #9
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: 1000 and 10

    I remember when Ford joined and then saw the rate of his answers I imagined he has a factory of elves all answering in his name.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: 1000 and 10

    haha when I 1st joined, I couldnt believe how many q's I could help with

  11. #11
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: 1000 and 10

    and still do!!!
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  12. #12
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: 1000 and 10

    That would be pronounced FARFFT! Ford
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  13. #13
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: 1000 and 10

    Quote Originally Posted by tony h View Post
    I remember when Ford joined ...
    So he was new member asking for help !!!

    I could not imagine what Ford asked that time.
    Quang PT

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: 1000 and 10

    Back then guys (like I have said before) I thought I was good at excel - until the REALLY good guys on here showed me what good looked like

  15. #15
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: 1000 and 10

    Quote Originally Posted by bebo021999 View Post
    So he was new member asking for help !!!

    I could not imagine what Ford asked that time.
    This one looks that is first Ford's question!!


    Edit:

    By the way. This looks that is my first post here. Take a look to see who are the repliers!
    Last edited by Fotis1991; 12-15-2015 at 03:53 AM. Reason: Edit
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  16. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: 1000 and 10

    wow, very interesting, both of those threads

  17. #17
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: 1000 and 10

    Quote Originally Posted by FDibbins View Post
    haha when I 1st joined, I couldnt believe how many q's I could help with
    Huh, when I joined I was the one asking the questions. I tried to find one my first questions ,but the database does not want to play ball. It was "How do you count non blank cells in range("A1:A20")?" At the time, I could only use Sum and VLookup, LOL. VBA, what was that? Lucky I had Romperstomper teach VBA and he is a very good teacher.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  18. #18
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: 1000 and 10

    Quote Originally Posted by Fotis1991 View Post
    This one looks that is first Ford's question!!


    Edit:

    By the way. This looks that is my first post here. Take a look to see who are the repliers!
    Fotis, find my first question, I could not do it.

    Cheers dave

  19. #19
    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,093

    Re: 1000 and 10

    http://www.excelforum.com/excel-gene...ml#post2088570

    I have been a lurker for a while, but this is my first post .
    I have not a hope of explaining this without a pic, so I hope this helps.

    In the attachment at the bottom of the page I want to count the symbols in the blue selected area when they are apear into the cells in the red selected area. The catch is that I want to treat the each of the "RED", "BLUE", "GREEN" as a single colum so to speak and have a value "1" or "0" apear in the back circled area.

    Eg, For MrB there is nothing in the "RED" column (B7:D7) so that gives a value of zero in cell cell "P7". In the "BLUE" column (E7:G7) there is a circle which will give a value of "1" in cell "Q7". In the "GREEN" column (H7:I7) there is a double circle and a square symbol and that will return a value of "1".



    I hope this makes sense. I have tried to do this with counta, but that will also count cells when a space bar is used and that makes it difficult to make sure that I am getting the right info. I also tried VLOOKUP and COUTIF but this is beyond my level. I hope someone can help.Cherrs.

    Regards, TMS

  20. #20
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: 1000 and 10

    Ha,Ha, I did the worst thing you could do, posted a pic instead of a file!!!!

  21. #21
    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,093

    Re: 1000 and 10

    Nah, not the worst thing

  22. #22
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: 1000 and 10

    Quote Originally Posted by TMS View Post
    Nah, not the worst thing
    LOL.

    I should also mention that JBeaucaire helped me with understanding a lot of VBA as well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 09-20-2011, 07:39 AM
  2. If a1 = 500 than 10, if it =1000 than 20 etc.
    By romettekitty in forum Excel General
    Replies: 4
    Last Post: 06-10-2009, 03:04 PM
  3. 1000+$K$5/1000 -what does $ indicate in formula
    By Coolbhims in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 07:55 AM
  4. [SOLVED] I am trying to figure out how to add per 1000
    By Govind in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 07:05 AM
  5. I am trying to figure out how to add per 1000
    By Govind in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 06:05 AM
  6. I am trying to figure out how to add per 1000
    By DG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] I am trying to figure out how to add per 1000
    By DG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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