tag:blogger.com,1999:blog-4953008377950396317.post4441308120403103421..comments2024-03-28T18:39:59.184-07:00Comments on SearchReSearch: Wednesday Search Challenge (May 9, 2011): Which companies are more than 100 years old?Dan Russellhttp://www.blogger.com/profile/13603209997260423532noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4953008377950396317.post-49784343333018500272011-05-16T09:21:24.966-07:002011-05-16T09:21:24.966-07:00Sorry Fred... I posted your comment above because ...Sorry Fred... I posted your comment above because Blogger wasn't cooperating. Readers note: The preceding comment is from Fred Delventhal (not me!).Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-80300078443883786692011-05-16T09:20:36.469-07:002011-05-16T09:20:36.469-07:00Fred Delventhal has left a new comment on your pos...Fred Delventhal has left a new comment on your post "Wednesday Search Challenge (May 9, 2011): Which c...": <br /><br />Here's how I approached the problem: <br /><br />I first went to Google Squared and tried a few searches [Fortune 500] [Fortune 500 companies] even tried a few from the list [Walmart, Exxon Mobile] and didn't get very far. I did notice I could add a column for "Founded" but it would take a lot to add each of the top 200 companies. <br /><br />It did give me an idea. So I did a Google Search for [Fortune 500] where I went to the Wikipedia article and from the link at the bottom of the article was bale to get to the list for 2011 on the CNN Money site http://money.cnn.com/magazines/fortune/fortune500/2011/full_list/index.html<br /><br />I copied 1-100 on the list and pasted that info into a Google Spreadsheet. Repeated for 101-200.<br /><br />I titled a column "Founded". I then used the GoogleLookUp function to find the founding date for each company. Copied the formula down the sheet and then sorted the sheet by that column. Walt Disney threw it off but I left it so you could see the result. <br /><br />https://spreadsheets.google.com/ccc?key=0An_tqHC_7q2EdExtTko5OGVJek1oeGJqMjhoZkYzNHc&hl=en<br /><br />I'm also not sure with 200 instances of GoogleLookUp how accurate it would be but for a basic list and nothing too formal I would go with it. <br /><br />Interested in other ways to answer this question. :-)Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-10886049664249995762011-05-12T11:21:48.376-07:002011-05-12T11:21:48.376-07:00Here's how I approached the problem:
I first...Here's how I approached the problem: <br /><br />I first went to Google Squared and tried a few searches [Fortune 500] [Fortune 500 companies] even tried a few from the list [Walmart, Exxon Mobile] and didn't get very far. I did notice I could add a column for "Founded" but it would take a lot to add each of the top 200 companies. <br /><br />It did give me an idea. So I did a Google Search for [Fortune 500] where I went to the Wikipedia article and from the link at the bottom of the article was bale to get to the list for 2011 on the CNN Money site http://money.cnn.com/magazines/fortune/fortune500/2011/full_list/index.html<br /><br />I copied 1-100 on the list and pasted that info into a Google Spreadsheet. Repeated for 101-200.<br /><br />I titled a column "Founded". I then used the GoogleLookUp function to find the founding date for each company. Copied the formula down the sheet and then sorted the sheet by that column. Walt Disney threw it off but I left it so you could see the result. <br /><br />https://spreadsheets.google.com/ccc?key=0An_tqHC_7q2EdExtTko5OGVJek1oeGJqMjhoZkYzNHc&hl=en<br /><br />I'm also not sure with 200 instances of GoogleLookUp how accurate it would be but for a basic list and nothing too formal I would go with it. <br /><br />Interested in other ways to answer this question. :-)krossbowhttps://www.blogger.com/profile/07877826327758153784noreply@blogger.com