Forum

If you're using the data model, you can specify the number format for measures and it will apply whenever the measure is added to your pivot.

For a situation like this, it's probably simplest to just suppress the errors using something like: On Error Resume Next With ActiveSheet.ChartO...

Maybe something like this: let Source = Excel.Workbook(File.Contents("C:path to your file herePRE.xlsx"), null, true), PRE_Sheet = Source{[Ite...

0.2 rather than 0.02 I think. 😉

You can work out the offset between the cell's Column property and the Listobject.Range.Column, which will tell you the listcolumn number. From there ...

You can't format part of a formula result, so the formulas in column L on the Active projects tab would have to be converted to values - is that going...

In f4: =INDEX(Lists!$C$4:$D$18,MATCH($B4,Lists!$B$4:$B$18,0),MATCH($C4,Lists!$C$3:$D$3,0)) and copy down. In G4: =INDEX(Lists!$E$4:$F$18,MATC...

You're welcome. 🙂

Just add an index column starting at 1.

You could also use something like: =SUM(COUNTIFS(B:B,{"Dog","Donkey"},C:C,"Black"))

You'll need something like this: Option Explicit Sub MakeFolders() Dim Folder As Range Dim FolderPath As String FolderPath = Range("MakeFolde...

The basic code could be something like this: Dim counter as long for counter = 1 to 4 Dim RunningTotal as Double RunningTotal = Runni...

To get the last number, you could also use: =LOOKUP(1E+100,C3:E3)

This looks a lot like an assignment? Also, you're supposed to mention if you cross-post:

You're welcome. 🙂