• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by AlexH

  1. A

    Index / Match headache

    I have a need for a user to select a group and a day (see attached sheet) and for the formula return the groups of letters on the right. For example select Group 1 & Day 2 would return TEAIM AAETN INATE EAINI EITNI MIETA etc When I have a single criteria I would use a lookup (hlookup in this...
  2. A

    Dabbling with dynamic charts

    Thanks Luke, I was just working on a sample data book to make things a bit easier to understand and came about a solution from a colleague. he suggested a logical test to check the date and return a n/a if that date had not passed. Attached (hopefully) is our attempt. The cell references have...
  3. A

    Dabbling with dynamic charts

    I have a small problem with some data and a chart for project management data. It goes a bit like this. I have 2 sets of data. Planned spends (based on people and hours) and actual spends (again people and hours). The planned is for a full year and the actual is updated weekly based on...
  4. A

    Extract data from text downloaded from Web

    Cheers guy's. Thanks for the help, much appreciated Alex
  5. A

    Extract data from text downloaded from Web

    No problem, I think I may have stated on the right way. this is the rough idea so far. A1:A13 used for web query to get data and paste in into column. Refreshed daily Text to column done manually - could be automated with a macro - to extract data from text and place into B1, C1, D1 etc...
  6. A

    Extract data from text downloaded from Web

    I've a question that is out of my league. I would like to extract the data from a text file that is updated daily. Then append the data to a column (or row) to build up a data set over time. The information is held here (http://www.swpc.noaa.gov/ftpdir/latest/wwv.txt) and in the format below...
  7. A

    Summary of actions

    I'm busy 'fiddling' with it. Glad its a lot easier in 2007!
  8. A

    Summary of actions

    Thats brilliant Narayan. Thank you for your help. I'll have to check it out on a machine with 2007 on it the one I'm on today only has 2003 and the formula falls over as is. I'll be needing this in the future as well Thanks again Alex
  9. A

    Summary of actions

    Narayan, Thanks for you help, its always hard to try and explain these things so I really appreciate this 1. The output is what I'm after. 2. A through E have other data which isn't relevant to summary. As an explanantion it is a scoring mechanism to see if a project is ready to be...
  10. A

    Summary of actions

    Yep No problem
  11. A

    Summary of actions

    Hopefully this should help narayan. http://db.tt/WbWJ5mqb There are quite a few questions that are asked, some will have answers and some will be blank. Hope it makes sense Alex
  12. A

    Summary of actions

    I'm using excel 2003 and am building up a 'Readiness check list'. Part of the structure has a column for 'Actions', one for 'Person Responsible' and one for 'Due date'. I would like to summarise the actions (along with other information) on a summary worksheet. Can I summarise this information...
  13. A

    Share your favorite Excel Sites

    Something for those who like to use stock market information. The SMF Add in http://finance.groups.yahoo.com/group/smf_addin/
  14. A

    Stock Screening

    So here's version 1 (http://cid-d92f4fd067efe995.office.live.com/browse.aspx/.Public) I've put a very short instruction sheet on one worksheet Any comments?
  15. A

    Stock Screening

    Thanks again for the advice. The sheet that I am building is starting to take shape. I'm using the SMF add-in to get data from a couple of different sources (MSN and Yahoo) to build up the screener. Itcertainly isn't pretty and probably not very efficient. Once its been built I would really...
Top