Last seen: Aug 22, 2025
Hi Pieter, I would merge the Office and GuestRole columns; select them both then right click one of the column headers and click on Merge Columns ...
Hi Simon, You say measure so you are talking about the result of a DAX calculation? There's no way to refer to the measure from inside the PQ ed...
Hi Vasim, If you change tolerances then you need to change the values in the lookup table that looks up the tolerance and the corresponding value (...
Hi Kathi, You can work out how many years until a person reaches 90 with this formula =IF((90-(B3+C3))<0,0,ROUNDUP((90-(B3+C3))/2,0)) ...
Hi Vasim, No need for VBA, you can replace your IF statements with a lookup =VLOOKUP(ABS(I6),$Q$4:$R$9,2,TRUE) See attached file for my solut...
Hi Vasim, Please state what it is that you want as a result. Please provide a workbook with code. An image isn't a huge amount of use if it m...
Hi Ian, Have you got an actual Excel file? That image is small and I can't read it to understand what the issue is or the results you want. You...
Hi Ian, No file is attached. You have to click Start Upload after selecting the file(s). Please supply an example of the result you are after, ...
Hi Susy, You can use .Attachments.Add Range("A1") where A1 contains the full path to the file. This post explains in further detail Create PD...
Hi Sunny, You can get this error when your source file has more columns in it than there were originally when the first import was done and the hel...
Hi David, See attached workbook for the formula. Writing something like this is a bit of a nightmare because Excel's formula editor is pretty rubb...
Hi Saliha, Check out this post, it may be useful for you Count, Sum and Average Colored Cells Regards Phil
Hi Jep, Nothing is attached. After selecting your file(s) you need to click on the upload button to actually upload them to the website regar...
Hi Carla, Please provide a sample file and show an example of the result you are looking for. Regards Phil