Forum

Hello, I don't see any query in your file, so below is the Excel formula I assume you want. =VLOOKUP(MROUND(I8,10),Table_Lookup,2,TRUE) Click re...

Hello Sunny, Unfortunately the TRIM() function in a data validation does not do the actual job on the cell content. If you type in a space as first...

Hello, This blog article gives a good answer on which Excel versions have PQ or not. Br, Anders

Hello Gayla, Well, it's true that the article did not give a specific answer on how to get what you want, but it surely gives some hints to get you...

Hello, There is a blog article written by Mynda that should help you forward. Check this out. Br, Anders

Hello, I agree with Frans and also, do consider take one or several great courses here at MOTH. I think the Excel course could be a good start. ...

Hello Tom, Just took a quick glimpse of your sample file. If you are able to get the hours data in a tabular format + in that data also have the em...

Hi, You can check at Microsoft's web page when a function was introduced. Br, Anders

Hello Santosh, Thanks for your feedback. Glad you found the duplicate entries, it is tricky sometimes. Br, Anders

Hello Mark, Thanks for the feedback. It is just a pleasure to be able to give some help. Br, Anders

Hello, I can only assume that there are duplicate data in your file, but this is just an assumption. You can always use the Remove duplicates after...

Hello Mark, In Power Query Editor, select the Category column and in Transform menu, click Pivot Column. In the dialogue box, pick Value as the col...

Hello Steve, The INDEX/MATCH formula that Sunny has provided to you works just fine, using the helper column in Codes sheet. The reason to the #N/A...

Hello Maja, It is of course doable using formulas to get this view you want, but it is not recommended as it requires manual work to extend or upda...

Hello, I would use a Pivot Table for such and also have the data in an Excel table so that the Pivot Table is updated dynamically when new data is ...