Last seen: Dec 22, 2025
Hi, Something does not look ok: In grid example sheet, you have in B1 the Team name as header, then in round 1 (cell B2) for the first team you ...
ops, sorry, it's a mac... Power Query is not available in that mac version
Why not Get Data>From File> From Folder? Just put all text files in that folder and you will get data from all in a single query.
Hi Felipe, Assuming that you have the data in a table named Table1, you can use the following query: Date Time Value Time2 Value2 ...
Hi Robert, You can replace the line .HTMLBody = RangetoHTML(Rng) with: If MsgBox("Send as attachment?", vbYesNo, "Sending Data") = vbY...
Hi Hai, In your goal table there is no relationship to the first 2 tables, can you clarify? For example, Goal table has this: 500*1, but table 2 ha...
Hi Brian, No excel developer can tell you what microsoft engineers had in mind when they built the system. The science behind can be very complex, ...
Hi Brian, I used to fly gliders, so never reached 10000 hours. Unfortunately, looks like excel will treat as text hours over 10000. I suggest us...
Hi Ron, Assuming that you have your data in Table1, you can add the list you want to search for in a new table-Table3. The query looks like this...
Hi Kristine, For Type, you can simply extract text before delimiter: = Table.TransformColumns(#"Changed Type", {{"Type", each Text.BeforeDelimit...
Hi Trevor, Just a thought: You should write a code (in the 32 bit version, to avoid crashes) to replace all those active x buttons with shapes, ...
Hi Peter, You can Setup a table in an excel sheet, with your parameters, dropdowns. Let's say your table has 2 columns: Parameter Valu...
Hi Christopher, You can play around with one of the search forms I'm using, see the file attached. Type 008 for example in the Search for box.
The last 3 files brings even more confusion. Initially, you had: Date Code Name 4/02/2020 35 Lara 5/02/2020 36 John 6...
You can see in the file attached a solution to keep existing data in Power Query and append data from same file as new rows at each refresh. Each t...