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