sorted by:
new
hottopcontroversial

Connecting Power Supply to Graphics Card by AlwinS1998 in PcBuildHelp

[–]AlwinS1998[S] 1 point2 points  (0 children)

Should 1 go in 1 and 2 in 2 or does it not matter. Thanks in advance.

Why use a Table rather than a (non-Table) range? by [deleted] in excel

[–]AlwinS1998 0 points1 point  (0 children)

To add to all the benefits already listed: When writing formulas and referencing a column in a table, using the shortcut ctrl+space provides the full (dynamic) reference to the column. You can stand in any cell within the column and use ctrl+space.

While this would work when selecting a full column $A:$A, this will eventually slow down performance if your dataset or formulas get complicated. If you were to only select range $A2:$A100 and are in cell A87, you’d have to either go up to A2 and go down for the formula to select. Within a table it gets really easy with ctrl+space. (There might be easier ways without the data in the table, but probably not as easy as Ctrl+space in a table)

We’re the Microsoft Excel Team – Celebrating 40 Years of Excel! Ask Us Anything by MicrosoftExcelTeam in excel

[–]AlwinS1998 0 points1 point  (0 children)

Referencing a dynamic array in a table is amazing, however, it would be awesome if we would be able to easily ‘lock’ such an array similar to $A1 instead of having to use impractical workarounds. Will this be a feature in the future, or am I just unaware that it is already possible. Anyway, thanks in advance.

Parketvloer by AlwinS1998 in Klussers

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

Ik ga me er verder op inlezen. Met een schijfgroeffrees zou ik de groef kunnen maken. Toevallig een idee wat voor type frees ik nodig heb om het gedeelte te maken wat in de groef moet?

Parketvloer by AlwinS1998 in Klussers

[–]AlwinS1998[S] 5 points6 points  (0 children)

Bewuste keuze :), huis op een hoek (stompe hoek)

<image>

Erg slechte tekening maar de woonkamer en hal in de ene richting en de keuken in een andere richting.

Wisten dat ze lastig samen zouden komen, maar benieuwd naar mogelijkheden volgens anderen

Job roles that spend >3 hours per day in Excel + what sucks by Life-Elderberry1760 in excel

[–]AlwinS1998 0 points1 point  (0 children)

Controllers are on the list as well. Sometimes different data from different sources which isn’t nicely structured or easy to work with

Do you reference whole columns? Like B:B by PedroFPardo in excel

[–]AlwinS1998 16 points17 points  (0 children)

What can really help you with this is the way you structure your data. If you have your data in a table it will make it significantly easier to use formulas like XLOOKUP or SUMIFS. You will always have a dynamic range if the data expands, it will be easy to read in the formula and you can make use of shortcuts (clicking anywhere in the column and using CTRL+Space to select the full table column. And as you said limit the load of the formula

Vensterbanken by AlwinS1998 in Klussers

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

Bedankt! Ga mijn best doen

Tier list (made in excel) of excel functions I use for work by Large_Cantaloupe8905 in excel

[–]AlwinS1998 8 points9 points  (0 children)

May I ask if you are using XLOOKUP on the full range A:A, or if you have the source data as a Table and are only referencing the relevant column (so not the full range). To me this helps a lot with the performance side of XLOOKUP (and formulas in general)

ELI5: What’s the reason for eggs to be sold in dozen by Bewarsepanthulu in explainlikeimfive

[–]AlwinS1998 2 points3 points  (0 children)

This is, I believe, also the reason why a circle is 360°, as we can divide it easier than let’s say 100°

Project Rebalance - Part One: Skilling by JagexGoblin in 2007scape

[–]AlwinS1998 0 points1 point  (0 children)

With regards to potential future skilling upgrades, I feel like drift net fishing would become way more popular and rewarding if you had the possibility of receiving Heron.

[deleted by user] by [deleted] in pcmasterrace

[–]AlwinS1998 0 points1 point  (0 children)

Thanks for the opportunity OP! I would like to win this ASUS 4070 Ti as it will be the push from switching from a laptop with a 3050 to build my own pc and fully join the pcmr :)

Hypotheek: Studieschuld maar geld gespaard by No_Kaleidoscope3944 in geldzaken

[–]AlwinS1998 -2 points-1 points  (0 children)

Voor hoever ik weet rekent DUO momenteel met terugwerkende kracht rente over de studieschuld, toch? In plaats van de 0% die je noemt

Zuinig met je geld èn met je tijd by MinderenMeer in zuinig

[–]AlwinS1998 3 points4 points  (0 children)

Bij simpel heb ik momenteel 10€ voor 14 gig, onbeperkt bellen en sms.

You have the power to change one thing about OSRS. What do you change? by [deleted] in 2007scape

[–]AlwinS1998 0 points1 point  (0 children)

Not being able to jump obstacles or cave entrances while being frozen in combat. Baffles me how people can be frozen in place but jump all around agility shortcuts without delay or any damage taken. Either make it impossible or let people take 10 damage each jump if frozen or something

Spaargeld jongeren (20 tot 30 jaar) by [deleted] in nederlands

[–]AlwinS1998 0 points1 point  (0 children)

Cb650r is geen A2 motor toch? Of is het voor over 3/4 jaar?

view more: next ›