Forum

Yeah I know what you mean. I guess it was created to overcome the issue where you may need to multiply cells that may or may not contain a numeric va...

No worries Julia. Yes as you discovered a - in a numeric field needs to be changed to something else, like 0

Hi Naomi, OK but I don't know how to implement your description into a solution in Excel. You say that Group ID and Class ID identify the name of ...

Hi Naomi, Can you please explain the logic that decides how the Premium and Eligible Discount columns are populated. Regards Phil

Hi, That's the way the PRODUCT function works and is the reason to use it in this case rather than just multiplying the three cells together, which...

Hi Julia, Check if the values in your [YTD Revenue USD] column are actually numbers. PQ is complaining that it's seeing text in that column. Re...

Hi Saliha, You can use an approximate match VLOOKUP for this - see attached file. regards Phil

Hi Matt, Yes a workbook with actual data is always better so that mistakes aren't made when recreating data from a written description of it. Al...

Hi Matt, If your data is in A1:A5 and you have the words to search for (e.g. big and house) in B1 and B2 then this works =COUNT(SEARCH(B1,$A$1:$...

🙂

Hi Jay, Without sample data it's pretty much impossible to help you - please provide a sample file with: 1. Enough data to properly represent yo...

Hi Rick, There isn't a specific section of the course dealing with JSON. I'm a little unclear as to what you are dealing with. You mention a JS...

Hi Laura, An alternative approach would be to create your query(ies) to the web source and load those results into a table(s) in Excel. Then the...

No worries