Chris Yap said Hi Catalin, thanks for your tips, this works for Project number infront with blank for this type Document 898 LS(T)800/2890DOC, i...
Hi Catalin, thanks for your tips, this works for Project number infront with blank for this type Document 898 LS(T)800/2890DOC, it will not wor...
Hi Treacy, in my real data source is not so "structured" meaning, the project number can appear anywhere in a verbatim, so there is no way to spli...
place a space before and after the text, however only one found don't know why ?
Hi Mynda, what they meant by "wrapping the string text in single spaces (b4 and after). Did the same with the list of lookup values...................
thanks Mynda and Andrey I will try it out in my actual queries and hopefully can improve performance Thank you very much Cheers !
Hi Mynda So thankful about your help, this is brilliant way to achieve what I want. Cheers !!
Hi Catalin, thanks for your List.RemoveMatchingItems code, I think manage to got the solution I want, the rest will be just some trimming and com...
Hi Catalin Sir, thanks for your M code, however when I inserted in the applied steps it gives me error perhaps you can explain to me the entir...
Hi Joey because they are more than 1 hour 59 minutes, copy and paste the following formula, those that exceed 119 will be 2 points =IF(AND((C8...
Hi Corrie Attached is the Power Query solution First you need to group by Employee No and Date, for Aggregation, one for Min and one for Max