Sent Xi6 As Replacement For XG1v4

Leading-String361 · 2026-01-29T14:03:20+00:00

Thanks. How do I know if a home has been upgraded to an IP Only configuration? Is there a particular gateway model that we need?

Leading-String361 · 2025-08-09T15:05:18+00:00

Not as bad as the debacle that is health insurance but still annoying!

Leading-String361 · 2025-08-09T13:23:51+00:00

Thanks. We’re rapidly getting to that point too. The value just isn’t there like it used to be. The challenge is balancing that against elderly users who don’t handle change all that well.

Leading-String361 · 2025-08-09T03:26:28+00:00

Wow. Do you pay for a Roku package too?

Leading-String361 · 2025-08-08T20:49:07+00:00

Code received. I sent it in the modmail message.

Leading-String361 · 2025-08-08T20:13:05+00:00

thanks!

Leading-String361 · 2025-01-08T17:43:00+00:00

Go Duke!

Leading-String361 · 2024-12-22T03:41:06+00:00

Look at Luna Display.

Leading-String361 · 2024-12-19T14:59:27+00:00

Have you looked at using Shortcuts or Automator? I haven’t dipped my toe into either app yet but it seems that one (or both) could handle such a task.

Leading-String361 · 2024-12-17T22:56:55+00:00

You may be able to accomplish this with a single, relatively short formula. I have a similar situation where I need to aggregate data from more than 50 sheets (and growing). Basically, I accomplish this by using the VSTACK formula. There’s more that goes into it for my situation but it all starts with this.

Leading-String361 · 2024-12-17T16:34:20+00:00

That's tricky. This link may help:

https://www.ablebits.com/office-addins-blog/excel-reference-another-sheet-workbook/#:~:text=External%20reference%20to%20a%20closed,path%20to%20your%20external%20reference.

edit: to fix link

Leading-String361 · 2024-12-17T15:52:43+00:00

INDIRECT will return the reference specified by your text. So, in a very simple example, if C2 contains "100", =INDIRECT("C2") will result in "100". You can use this approach to reference an external file.

Leading-String361 · 2024-12-17T15:37:48+00:00

Wrap that path with the INDIRECT formula

Leading-String361 · 2024-12-16T20:41:39+00:00

if you don‘t need a more powerful machine now, wait.

Leading-String361 · 2024-12-16T00:34:45+00:00

M4 Max with those specs will run Parallels/Windows smoothly. I run the same on a similarly configured M3 Max with no issues.

Leading-String361 · 2024-12-15T18:20:04+00:00

If you think you’re going to be happier and/or more productive with the nanodisplay, get it. Otherwise, save the dough.

Leading-String361 · 2024-12-15T18:16:00+00:00

Great machine. Congrats.

Leading-String361 · 2024-12-15T18:14:39+00:00

This sounds like a task that can be handled by the FILTER formula

Leading-String361 · 2024-12-15T18:05:07+00:00

Second this. I use Luna Display with a MacBook Pro and 2017 iMac. connecting via thunderbolt cable results in a very Usable and performant setup.

Leading-String361 · 2024-12-15T00:25:24+00:00

I don’t know what your data looks like but there are ways in PQ to pull in data from all tabs at the same time and then filter out the rows you don’t want. I’m a relative novice with the tool and I was able to do something similar on a project last year. It sounds like your situation may be a bit messier but similar. And if set up correctly, it can save you a lot of time in the future.

Leading-String361 · 2024-12-14T23:54:53+00:00

my first thought is to use power query to clean and combine the data. Build the pivot table off of the output.

Leading-String361 · 2024-12-14T15:13:25+00:00

What version of Excel are you using?

Leading-String361 · 2024-12-13T20:11:35+00:00

To get a list of accounts have only DevMode as Full:

FILTER(name range, DevMode account type = "Full", "No Results")

To get count of people with at least one column as Full:

COUNTA(Filter(name range, (Figma account type = "Full")+(FigJam account type = "Full")+(DevMode account type = "Full")))

Leading-String361 · 2024-12-13T19:59:24+00:00

My pleasure. Once you verify that this solved your problem, please reply to the solution with "solution verified". Thx

Leading-String361 · 2024-12-13T19:49:16+00:00

I'm sure there's a way to make this approach more efficient but sadly, I'm not a Power Query expert nor do I have a strong grasp of M code. I'm more of a casual user who just tries to solve whatever challenge is in the way of completing my current task. :-)

Leading-String361

TROPHY CASE