+ Reply to Thread
Results 1 to 25 of 25

january 1 birthdays

  1. #1
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    january 1 birthdays

    what happens in march that causes a flood of birthdays(well a disproportionate amount of this forum seems to have january 1 as listed birthday).is it an excel convention/gathering?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    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 Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: january 1 birthdays

    Martin, I'm VERY busy in late March / early April. What good is a forum without new recruits?

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: january 1 birthdays

    Quote Originally Posted by martindwilson View Post
    what happens in march that causes a flood of birthdays ... to have january 1 as listed birthday).is it an excel convention/gathering?
    I suppose if people CBA putting their burthday in does it default to 1st Jan? Or maybe users-to-be don't read the instrctions properly and think that the DoB field is mandetory and don't want to put their real birthday so put 1st Jan.

    That said, I have 13 (unlucky for some) nieces and nephews, and of those, two have a birthday on 31st Dec (I know it's not quite 1st Jan but it's close enough). And had my procreating relatives ceased their reproducing antics earlier, the figure would not be 2 out of 13, but could have been 2 out of 6.

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: january 1 birthdays

    I'm supposed to be going to a birthday party on the 1st Jan. Heaven knows what condition I'll be in after the night before if previous years are anything to go by!!!
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

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

  5. #5
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: january 1 birthdays

    I have two nephews and seven nieces. Both nephews were born on the same day (10 years apart). The infant brother of one of those nephews (my step-nephew-in-law-once-removed-on-my-wife's-side-of-the-family, I guess, since it's with a different dad not related to the family?) was also born on that same day. Now THAT is well orchestrated.

  6. #6
    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: january 1 birthdays

    Paul, i notice, well at least from work that your reputation icon isn't showing, perhaps it might be better to use this url instead of typesomething.com
    http://www.excelforum.com/images/styles/Skylight/buttons/reputation.gif
    The image will appear as below

    and for the report button:
    http://www.excelforum.com/images/styles/Skylight/buttons/report.gif
    The image will appear as below


    Hope that helps
    Last edited by Simon Lloyd; 11-28-2010 at 07:07 PM.
    Not all forums are the same - seek and you shall find

  7. #7
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: january 1 birthdays

    Thanks, Simon. Is this any better?

  8. #8
    Valued Forum Contributor blane245's Avatar
    Join Date
    02-20-2009
    Location
    Melbourne, FL
    MS-Off Ver
    Excel 2010
    Posts
    649

    Re: january 1 birthdays

    Well, my birthday is exactly 9 months from Jan 1, so I must have been a really good party.
    Bob
    Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.

  9. #9
    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: january 1 birthdays

    Quote Originally Posted by Paul View Post
    Thanks, Simon. Is this any better?
    Much better Paul , just one thing to add though, if the forum changes icons...etc then you will have to go to the whole process of copying them and then uploading again, but if you use the method i posted the icons should change with the forum
    Last edited by Simon Lloyd; 11-29-2010 at 05:19 PM.

  10. #10
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: january 1 birthdays

    Hmmm, I was thinking that a disproportionate amount of individuals born on Jan 1 had high skills in Excel (some sort of spreadsheet zodiac thing) but then realized that just because they are registered users, doesn't mean they're proficient (perhaps the opposite). So we need to measure the proficiency of the Jan 1sters and map that against other days of the year to truly determine your spreadsheet horoscope. () Perhaps I can apply for a grant.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  11. #11
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: january 1 birthdays

    if the forum changes icons...
    True, and I bet those icons change before the forum is restructured. Pint of Guinness anyone?

  12. #12
    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: january 1 birthdays

    Quote Originally Posted by Paul View Post
    True, and I bet those icons change before the forum is restructured. Pint of Guinness anyone?
    I'm with you on the Guinness, if you haven't had the requests you all make filled 100 times over by now then i wouldn't bother keeping my fingers crossed or making any more requests

  13. #13
    Forum Expert romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    12,305

    Re: january 1 birthdays

    Hmm, the MVP Summit used to be in March, didn't it?
    Remember what the dormouse said
    Feed your head

  14. #14
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: january 1 birthdays

    Did you know...

    You need 23 people in the room to have 50% chance that 2 of them have birthday on the same day...

    With 30 people it's 70%...
    So.. If you see 30 people in the room don't hasitate to bet that 2 of them has birthday on the same day

    In a group of 60, people, it is almost certain (99.2%) that two have the same birthday.

    However... It's supposed that people's birthdays are equally distributed over the other 365 days of the year so this 1st January thing could collaps whole thing

    More about Birthday paradox on wiki...

  15. #15
    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: january 1 birthdays

    Quote Originally Posted by romperstomper View Post
    Hmm, the MVP Summit used to be in March, didn't it?
    I was trying to organise an Excel Event and did have a notice up here but the owner freaked and removed it

    Anyway, the Microsoft Excel Users Event hasn't had that much response because its difficult to get the word spread around, if interest doesn't pick up i'll have to cancel it which will be a shame, there was to be 3 or 4 MVP's presenting everything from what we know and love to the latest cutting edge developments.

    But there again i'm not adverse to having a few beers in the honour of those that might have attended

  16. #16
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: january 1 birthdays

    Great, I read that birthday wiki deal, and now know I'm one of the naive folks that thought you'd need more than 23 people to have a 50% chance. I definitely wouldn't have pegged 60 as being the 99.2% chance.

  17. #17
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: january 1 birthdays

    now that we know the chances of having two people having the same birthday, I am curious as to the breakout of birthdays for this forum. Would one of you Mods who have access to that data, plot the frequency on a graph and post it to this thread? I know that I share my birthday with some interesting people.

    107 B.C. - Roman orator, writer, and statesman Marcus Tullius Cicero was
    born in Arpinum, Italy.

    1892 - British writer John Ronald Reuel (J.R.R.) Tolkien, author of The Lord of the Rings trilogy, was born in Bloemfontein, South-Africa.

    1909 - Pianist and comedian Borge Rosenbaum, better known as Victor Borge, was born in Copenhagen, Denmark. He started playing the piano when he was three years old.

    1932 - American actor and Golden Globe winner Dabney Coleman, whose credits include Nine to Five, On Golden Pond, and Tootsie, was born in Austin, Texas.

    1945 - Actress and bestselling author Victoria Principal, whose credits include the television series Dallas, was born in Fukuoka, Japan.

    1956 - Mel Columcille Gerard Gibson, better known as just Mel Gibson and star of Lethal Weapon and Braveheart, was born in Peekskill, New York.

    With whom do you share a birthday?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  18. #18
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: january 1 birthdays

    Quote Originally Posted by alansidman View Post
    now that we know the chances of having two people having the same birthday, I am curious as to the breakout of birthdays for this forum. Would one of you Mods who have access to that data, plot the frequency on a graph and post it to this thread?
    Actually, you don't need mods to do that. You can see them by your own:
    Attached Files Attached Files

  19. #19
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: january 1 birthdays

    In the news:
    A Cambridge scientist has developed a computer program to calculate the most lackluster day since 1900. April 11, 1954 based on what happened on that day and famous people's birthdays.

    http://www.cbsnews.com/8301-501465_1...64-501465.html

  20. #20
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: january 1 birthdays

    Look at the diagonal:

    1-1
    2-2
    3-3
    4-4
    5-5
    ....
    12-12



  21. #21
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: january 1 birthdays

    zbor, how did you collect that data?

  22. #22
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: january 1 birthdays

    My guess is he clicked the "Calendar" button in the header, than then copied the data for each month and arranged it in Excel.

  23. #23
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: january 1 birthdays

    or
    Please Login or Register  to view this content.
    Last edited by snb; 12-03-2010 at 09:49 AM.

  24. #24
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: january 1 birthdays

    Quote Originally Posted by Paul View Post
    My guess is he clicked the "Calendar" button in the header, than then copied the data for each month and arranged it in Excel.
    Yes.. I'm old fashioned man.. I don't use those fancy VBA's

  25. #25
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: january 1 birthdays

    You must be kidding...

+ 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