Forum

Hi Cullen, Yes the #"Added Custom3" step does as you describe. Not sure how the Project, Activity and Description columns ended up blank in my f...

Hi Mohammed, Please supply your Excel workbook(s) and examples of the layouts/results you want. Regards Phil

Hi Mike, That website isn't giving the results correctly. It shouldn't be duplicating results like that. Not much we can do to prevent this as al...

Hi Amanda, Please supply a sample workbook with your question, it can be very difficult to debug code without the data it's working on. In this ...

Hi Andy, Macros are another term for the code written using VBA. So macros = VBA. If macros/VBA were the only way to do what you want, then I'm...

Hi Cullen, The result of your IFERROR when there is an error is "" , which is an empty string, and that isn't the same as a blank cell. If you u...

Hi Cullen, Seems that Mynda and I were both working on this and didn't know the other was doing so! At least you get 2 different solutions to your...

Hi Julia, As long as your new dataset has the same structure as the old one then yes. When I say structure I mean the dataset must have the same...

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...