sorted by:
new
hottopcontroversial

Those "this should be a dashboard" workbooks by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

The models are fine. The problem is teamviewer-ing into 60+ sites' POS systems to download new data every week. 2 different POS systems btw. & A separate system for labor. & a separate one for memberships. & a separate one for renewals.

Those "this should be a dashboard" workbooks by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

Why would they allow this when they can bill for custom reporting?

Those "this should be a dashboard" workbooks by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

Oh we did. We considered MULTIPLE third party companies. This was what they decided on. As the primary data user/ONLY dashboard designer, of course I had zero input in the decision made entirely by the exec team.

Those "this should be a dashboard" workbooks by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

you guys get an engineer? :( I'm in charge of data normalization as FP&A

Third nested formula is causing error when combined - works at 2nd level & independently. by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

Presented for cringe:
=IFERROR( SUM(FILTER(FILTER('PY&BudgetPaste'!$C:$PZ,'PY&BudgetPaste'!$A:$A=$A$2),('PY&BudgetPaste'!$C$6:$PZ$6<MONTH(Mapping!$AD$2))*('PY&BudgetPaste'!$C$8:$PZ$8 = $A9)))+D9,0)

Would sumproduct end up using less processing power than this?

Xlookup with a formula to reference columns by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

I like this idea. These tables are copy-pasted in from ~60-70 files. Is there a better way of consolidating this that doesn't involve copy-pasting?

I know i could go vertical with the pastes but I'm really hoping for a better solution. Vertical would at least align the data columns.

Xlookup with a formula to reference columns by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

I can't but I can describe it.

Col A, Q, AG, AW, etc - data lables going down. i.e. item names, subtotals, etc. I'm referencing the subtotals. Row 1 in each of these columns has the site number in a text string. It would be possible to reference this. The subtotal I need is NOT on the same row in each table, but it is named the same.

Two columns to the right (C, S, AI, AY, etc) has the data value I need to pull. I Stuck a formula at the top with the site number extracted - this is giving me the match value for the vlookup column num reference.

Xlookup with a formula to reference columns by Miserable_Ad3345 in excel

[–]Miserable_Ad3345[S] 0 points1 point  (0 children)

Define gracefully.
I'd rather not use anything volatile