You need to separate the input data into separate day, month, and year, and then use the DATE function to reassemble them into a single, correctly-formatted UK date. ![]() =XLOOKUP(lookup item, row or column to search in, data to return, )Ī simple one to start - how do I quickly convert US dates with a "." separator, to UK format? ![]() XLOOKUP is a new lookup function in the latest Excel versions, which is a superior replacement for VLOOKUP or INDEX MATCH if you’ve been using those before. No, you would need to add this as a manual column.Ĭould you please give a recap of the XLOOKUP function? Is the consolidation able to reference the names of the tabs Mon, Tue, Wed? ![]() See our other webinars on PQ for more details. Secondly, you could add each dataset to the data model using Power Query (Data => From Sheet), and then create a new query that appends all of these into one. However this is a very manual process and won’t update if the source data is updated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |