Forum

If your data doesn't have missing date/station combinations, and is sorted as in your sample, then I think something like this would work: =IF($J2="...

You could also use some code like this to do the replacements: Sub replaceHlinks() Dim oldDate As String oldDate = InputBox("Enter old dat...

Not really. You're doing the same work twice there by converting to hours and then dividing by 24, which gets you back to decimal days. All you need i...

Ah. You might want to have a look at Lz's article here about using the API:

If you open it in desktop Excel from OneDrive, under the File - Info section, you should see a Copy Link button at the top. Click that, then you need ...

Cross-posted:/p>

I don't really know why you have a table with blank rows in it, but you can use: For i = 4 To sh.Range("A" & Application.Rows.Count).End(xlU...

Cross-posted here:

You can't refer to table ranges like that. You need to use something like: FindName = WorksheetFunction.XLookup(FullName, Application.Range("tblPhon...

If you need to do it as a calculated column, you will need to figure out how to remove some of the filters to get rid of the circular dependency - e.g...

You could add a couple of calculated columns: LatestLimit: =if(MyTable[LatestTransaction]="Yes",MyTable[Limit],BLANK()) LatestLimitBand: =LOOKUP...

That would also work as you can then just merge that column in too, and check it in the next step.

I'd just add that as a separate step afterwards since it only applies to Manual.

A simple merge query would be an easy solution.

I don't believe you can create one measure for that. The totals row has no context of what row fields are involved in the rest of the pivot table.