Last seen: Jul 8, 2026
It's not the prettiest solution but after splitting, checking and merging columns I was able to create the list of Dates and Time. Please see attached...
In general you would do something like this: =IF(A1>=0, "Positive", "Negative") In words, this says: If the value in A1 is greater than or eq...
Could you please upload a file with some sample data that resembles your real situation? It's so much easier to help with some real data to work with.
Noticed that as well. The size of the formula bar depends on the last used setting. Don't know if there's anything you can do about that. It's just on...
Hi Tom, One line in the formula bar takes as much characters as your screen/window size allows. When it reaches the end is automatically wraps to t...
Couldn't think of a LAMBDA solution but came up with a not very pretty, but working, formula that uses many of the dynamic array functions that Excel ...
Ask for a simple solution and you'll get one 🙂 I merged (Left Outer join) the Laptop table with the Retired table and expand. All rows with a ser...
Didn't notice your question until now. Perhaps the attached file helps you on your way, though I notice that your start and end times are not consiste...
Perhaps you can upload the file that includes the April table and the query that doesn't give you the desired result.Then it will be easier to see whe...
The serial number (as described in Mynda's video) for a duration of 2:30 is larger than that of a time of 2:20. Deducting the first from the last resu...
Perhaps the attached file can help you on your way. Though, I would recommend to not have one sheet with daily figures and a weekly total every 8th co...
Not sure I understand what you mean, but your txt file contains just text. PQ doesn't know these are records and you need to define the logic of it yo...
Try this formula as the rule for conditional formatting. =ISNUMBER(MATCH(B2,lookup2,0)) I believe it does what you need.
Perhaps the attached PQ solution helps you on your way.