Forum

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

Hi Simeon, Please provide a sample file when you post a question so we don't have to recreate your data. You can do this with a combination of I...

Hi Adam If your Year is in A1 and the Day of Year in B1 you can use this =DATEVALUE(A1&"/1/1")+B1-1 Regards Phil

Hi Mattias, Please share your PBIX file so we don't have to recreate everything. Regards Phil

Hi Jose, Why are you using VBA for this? Just use a formula in Column J? If you are using Power Query to import the data every month, use that ...

Hi Scott, Please provide some sample data files and an example of how you want the results to look. Regards Phil

Hi, Please supply some sample data and an example of the result you want, otherwise anything we provide will need to be changed again to suit your ...