Last seen: Jun 25, 2026
@campbell83 I just added two columns to your table so that I didn't have to do it in PQ. See if you can follow the steps in PQ which aren't more com...
@j8150outlook-com So you have the content of multiple PDF's in one table? Then you could add a column with some code that checks if the content of ...
@rickdhiman Have you worked with PQ before? If not, a 'step-by-step' may not be very helpful. But, in the example I gave, I connected PQ to the a ta...
@rickdhiman I doubt that your Excel version supports the TEXTSPLIT function, but if you can get your hands on a more modern version this should wor...
@j8150outlook-com Glad I could help. The code is actually in the workbook I uploaded earlier. you find it in the PQ editor. But just in case: this i...
@j8150outlook-com Would the solution in the attached workbook work for you? It assumes that the information with the plot, crop and area is always...
@josovu Not particularly proud of it but the formulas I added in the attached workbook (below yours) seem to work as intended. With a bit more time ...
@cipow OK! That clarifies the matter. The example in that video shows how you should structure a table that contains the data validation (DV) options....
@kellyferg That file isn't very helpful I'm afraid. Reading your question again I note that you are exporting from accounting software. Surely, an acc...
@bee I created a small scale model in Power Pivot and believe it illustrates yuor problem and how you can resolve it.
@bee Thanks for the file. But please create the pivot table how you would like it and add the slicers you need. Make some relevant selections in th...
@cipow If you can't upload a file (though it should work), please share a link that gives access to the file on OneDrive or similar. And please le...
@bee So you want to calculate FTE's based on whatever period you select? One month, a quarter, Feb to Maj or whatever? Not sure. Can you share an a...
@bee Did you try a Calculated Field as shown in the picture below?
@stephanrs Just a few observations. Kindly ignore them if you don't find them useful. 1) DATEDIF is not an official Excel function. It exists to ...