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

Search results

  1. V

    Extracting multiple sedctions of data from a batch of XML files

    Thanks to all for your replies - apologies for not acknowledging sooner - no internet during evenings (at the moment). I'll work through all your suggestions and (hopefully) come up with a solution. Being able to process all this information contained within these XML files helps are surveyors...
  2. V

    Extracting multiple sedctions of data from a batch of XML files

    XML uploaded as text...
  3. V

    Extracting multiple sedctions of data from a batch of XML files

    XML File - The data contained in between the tags I want are highlighted in blue. As you will note, the Address details I need are contained within the <SAP: Property> tag not the <SAP: Contact-Address> which is a few lines above. Many thanks in advance Cheers V13RNE <?xml version="1.0"...
  4. V

    Extracting multiple sedctions of data from a batch of XML files

    Smallman As requested - been populated with 23 XML files. Many thanks
  5. V

    Extracting multiple sedctions of data from a batch of XML files

    Good morning everyone, I'm trying to extract certain elements of data from a batch of XML files into a single worksheet. At present I'm extracting 10 elements from the XML data and I've 10 loops. The problem I'm encountering is that in any XML file there could me several instances of the same...
  6. V

    Average score, grouped and sorted into lots of 10s from unsorted data.. [SOLVED]

    Hui Narayan's solution &#62;=12 works out with a margin of 6.7% i.e. 12.8 across the test data. I'm happy with that! Thanks everyone for their comments and help.
  7. V

    Average score, grouped and sorted into lots of 10s from unsorted data.. [SOLVED]

    Narayan Wow! Thank you so much for doing this - I've messed around with it and it's just the job... Great stuff!! Thanks once again V13RNE
  8. V

    Average score, grouped and sorted into lots of 10s from unsorted data.. [SOLVED]

    Thanks to you all slightly by definition i would interpret as no more than 14, 15 at tops. The nearer to 12 the better for the initial sets of iterations. The selection - as in Sajan's post - for each batch of 10 is completely random. V13RNE
  9. V

    Average score, grouped and sorted into lots of 10s from unsorted data.. [SOLVED]

    Hi Narayan Thanks so much! I appreciate your help V13RNE
  10. V

    Average score, grouped and sorted into lots of 10s from unsorted data.. [SOLVED]

    Hi Narayan Yes, I knew it was going to involve a macro - I've no problems with macros; can get an idea of the logic from the code (I ain't a programmer though!!) hope you can help? Thanks once again V13RNE
  11. V

    Average score, grouped and sorted into lots of 10s from unsorted data.. [SOLVED]

    Hi Narayan Thanks for your reply. In answer to your questions: 1. Can you explain the meaning of the following ? I need to compile (and pick out) batches The solution is to first select any 10 scores from the data that have an average of not less than 12; and move these results to a...
  12. V

    Average score, grouped and sorted into lots of 10s from unsorted data.. [SOLVED]

    Hi I have two columns of data. column A is a "reference number", column B is the "score". I need to compile (and pick out) batches of 10 "scores" with their "reference numbers" across the data set that have an average score of 12 (can be slightly more but not &#60;12) A B Ref Nr Score...
  13. V

    Hello .. Introduce yourself

    Hi, I'm Ed from Newcastle... and I'm also a newbie at Chandoo. I enjoy working with Excel and am always striving to find new ways to improve performance and productivity!
Back
Top