Forum

Yes, sorry about the version information, Paul. It's a bit of a mine field as they keep changing the licensing and rules around what versions have wha...

It's not doable with another approach unless you're willing and able to write VBA to do it, which will still require logic that you don't have the dat...

Hi Lea, I'm not following, sorry. It's difficult because I can't read most of what's in the file attached because it's in Hebrew. Do you think you ...

Hi Nick, I think this is what you need: =IF(OR(ENTRY!$D$2=ENTRY!D5,ENTRY!$D$2=ENTRY!F5,ENTRY!$F$2=ENTRY!D5,ENTRY!$F$2=ENTRY!F5),2,0) Mynda

The way to deal with it is to use actual data in the cells that can be used in logical tests in formulas. e.g. if = "OK" then green, if = "Pending" th...

🙂 of course. I was thinking at the time that the value in that argument is text, as most of them are in GETPIVOTDATA and that it had to be in a spec...

Hi Michal, Welcome to our forum! Not really in a bar chart. You'd be best to use a column and line chart, plotting the variance in $ as columns ...

Hi Mahesh, Welcome to our forum! Thanks for sharing your file. For question 1 on conditional formatting, please see this tutorial on Conditional F...

Hi Lea, Add a column in Power Query that numbers the rows in batches of 29 i.e. the first batch will be numbered 1. The next 29 rows will be 2 and ...

Hi William, Change the DATE formula to something dynamic like this: =GETPIVOTDATA("Status",$O$29,"Status","Analysis","Today",DATE(YEAR(TODAY())...

Hi Nick, Looks like you're on the right track. You need to add the additional data for the team name (Mercedes) which you could do with a lookup in...

Hi Brad, Welcome to our forum! When I opened the file I could see momentarily the duplicate stocks, but as soon as the formula recalculated, I o...

Hi Paul, Great to see you're using Power Query! The error your users are getting is because the query is pointing to a file on your C: drive. Wh...

Hi Moriel, It's usually best to create a dummy file that contains just a sample of your data that illustrates the issue, as this keeps the file siz...

Hi Linda, Thanks for sharing your example file. I think you might be best to generate the running total and day marks in Power Query. See file atta...