About Jackie Meddows-Taylor

This author has not yet filled in any details.
So far Jackie Meddows-Taylor has created 318 blog entries.

Excel Office Scripts for Effortless Data Movement

by Melina Louzada Excel Office Scripts for Effortless Data Movement Welcome to the world of streamlined efficiency with Excel Office Scripts! In this blog, we dive into the transformative power of automating your Excel workflows, specifically focusing on a scenario many of us encounter: managing and organizing current and completed records in an Excel file. [...]

Power Query Challenge – A Unique Problem

by Wyn Hopkins The Challenge... In this month's challenge, you need to combine any non duplicate items into a single cell for each client ID#. e.g. Client ID1 has 2 rows. All entries need to be combined to return 1 row for Client ID 1 so for example the two Phone Numbers: Phone 1 and [...]

Power Query Challenge – Best in Class

by Wyn Hopkins The Challenge... School’s almost out for summer (well in Australia anyway)… how has everyone done in their exams? Who had the highest average score for each day? How can we tell?   We need to sprinkle on some Power Query Magic dust! *Don't forget to make your solution flexible so that if more [...]

Power Query Challenge – Ticket List

by Wyn Hopkins The Challenge... Our Solution... Convert Range of Values to a List - Power Query Challenge youtu.be Your Solutions... Some of the solutions we received can be viewed here along with the original challenge: Power Query Challenge Tickets to Rows        

Power Query Challenge – Merge Duplicates Alert

by Wyn Hopkins Creating a Merge Duplicates Alert This challenge is how to warn the end user that duplicates exist The Challenge... Take the challenge with our free download     And if you would like us to have a look at your solution e-mail it to info@accessanalytic.com.au

Power Query Stop Start Challenge

by Wyn Hopkins The Challenge: Hours from Start and End Assume Start Time and Stop Time are always whole hours Solution must handle new rows of data being added to the source with new staff names Remove any records marked as "exclude" in the Status column (handle upper case / lower case typos) Our approach... [...]

Power Query Survey Response Challenge

by Wyn Hopkins The Challenge: Survey Response Remove any current AND FUTURE columns that begin with Sys, but allow for other future additional (non Sys) columns to be automatically included Replace all but 1 space between the names in the first column Add a TRUE / FALSE flag for the 3 response options in 3 [...]

Power Query Challenge – Columns to Rows

by Wyn Hopkins Challenge: Change columns to a single row Inspired by a real-life scenario where nicely structure data needed to be "Pivoted", but in a specific way, and as always with Power Query it needs to work when new data is added. The challenge is to: present each person as a single row with [...]

Power Query Dates and Time Challenge

by Wyn Hopkins This month's challenge is about dates and times There's a surprising issue hidden in here too! The goals are as follows: extract the time without the seconds extract the year (watch out for the trap) extract the number of days between the last Friday of the Year and the last day of [...]

Power on with this Power Query Challenge

by Wyn Hopkins Flexible Consolidation of Tables These 2 tables exist on their own tabs in this file, goal is to combine them in a flexible way to produce the output required :   Must replace nulls with 0s Must be able to handle a completely new table for a new Region being added Must [...]

Build Wordle using Dynamic Array Functions

by Wyn Hopkins Learning Dynamic Array formulas in Excel by building Wordle This video shows the use of Dynamic Array formulas # references, XLOOKUP, SEQUENCE, MID, TODAY and some conditional formatting. Click on the file below to play along!     Download a copy of the file we used below: