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

    Vlookup Book

    I was about to ask the same. I have worked out the answers but am just wondering if I am doing it the most efficient way.
  2. S

    [Solved] Data Validation - Floats

    How can I define data validation for numbers that are floats. They drop down only specifies whole number or decimal? My numbers are numbers with 2 decimal places and I just as want to ensure they fall between a valid range however my data returns as invalid which is correct because my values...
  3. S

    Managing XML - Creating XSD's and db management

    I will be tracking a state sporting bodies xml they post a pre event and post event XML file for each event. I think XML maps in Excel may allow me to ensure my XML file imports are accurate each time, rather than creating an XSD for it first. I was initially going to use MYSQL because of the...
  4. S

    Managing XML - Creating XSD's and db management

    I am really looking how to master consistently and reliably manage insert, store and retrieve data. A lot of data I am getting is in XML format. Is there a way in Excel to create an XSD from an XML file so that I can import the file honouring and utilising its tabular structure? It would...
  5. S

    Hello .. Introduce yourself

    Hi all Sayth from Australia. Really come to love excel over the last couple of years. Power query is just awesome and the 2016 is very cool indeed. Looking to learn how to manage data from external sources and push from excel into storage.
Back
Top