Last seen: Aug 26, 2025
Rather that letting Excel set the colors automatically, choose the colors yourself as 'Solid Fill' when formatting a data series. I've done that in on...
That's by design. As the name suggest the Data View is just a view. Changing the view does not change the data source for the pivot table. Not in Powe...
You may also want to read this: Import and shape data in Excel for Mac (Power Query) - Microsoft Support Although PQ came to the Mac a while ago...
Hi Peter, This is similar to an earlier question you raised. Unique is not the same as Distinct. The TRUE argument in the UNIQUE function will retu...
Consider loading the date for each of the sheets into the Data Model. Relate all of them to each other via a table with unique CLASS id's and create a...
If you intended to attach a file, please try again as it didn't come through. Don't forget to press the 'Start upload' button and wait until it's fini...
Well, that's why I left my test formulas in the sheet. In the attached file I've added your original formula in the B21 and dragged it across and down...
I've played around with your file a bit and came up with two possible CF rules that can be applied to the entire range in one go. The one I personally...
I believe your formula is not picking-up the cheapest suppliers to begin with (marked green in the attached file). A shorter formula without all th...
To build further on Velouria's solution for the daily pricing, I've added some helper formulas to your file (see attached) to facilitate the monthly p...
Difficult to answer if you don't upload a file that demonstrates the problem.
You can't count conditionally formatted colors. In stead, you should use COUNTIF and use the condition for setting the format as the criteria. In you...
My guess is that you have daily exchange rates and you want to create another list that contains all latest rates for each month. I can probably think...
Since you only have three columns to work with, consider to keep it simple and add a custom column with the following code: = Number.From([MR Sco...
Don't know what happened there. The file somehow got corrupted. I recreated a version that should work. I trust you can 'translate' the Excel formulas...