Sumproduct within Arrayformula This is my formula in cell D2:  =SUMPRODUCT(B:B=B2;F:F&gt;F2)+1  The values in column are all of the same length, and are continually updated by contributions from google forms. Therefore a condition based on length makes no sense.  How can I make an Arrayformula of this, so that the B2's and F2's change with the row numbers? The function "indirect" isn't possible in an Arrayformula.
Using SUMPRODUCT with ARRAYFORMULA I have the following random data in sheet one  A  orange D  yellow C  yellow B  orange B  orange C  blue A  yellow D  blue C  orange C  blue   In sheet two I use the following query function:  A1=UNIQUE(QUERY(Sheet1!A1:B10,"select A, B order by A asc")) C1=sumproduct(Sheet1!A:A=A1,Sheet1!B:B=B1) C2=sumproduct(Sheet1!A:A=A2,Sheet1!B:B=B2) C3=sumproduct(Sheet1!A:A=A3,Sheet1!B:B=B3) . . .   Which returns the following:  A   orange 1 A   yellow 1 B   orange 2 C   yellow 1 C   blue   2 C   orange 1 D   yellow 1 D   blue   1   Instead of using sum product in each row, I want arrayformula to expand automatically.  When I use E1=ArrayFormula(sumproduct(A1:A10=C1:C,B1:B10=D1:D)) I get     Error: Array arguments to EQ are of different size.   Please help me out.
What exactly is a hat?  I have seen a lot of people arguing the significance of hats and the limited edition hats. I know the hats are sort of linked to the Winterbash stuff, but what exactly is a hat, what does it do, how do I get one?  Is there a full list of hats? Is it okay to have 100% CPU usage constantly? I often do 3D rendering in the background which consumes 100% of the CPU (I lower the priority of the process so that it does not hinder any tasks I am working on).  My concern/question is whether it is okay to run a computer/laptop with a 100% CPU load constantly.  Could this reduce the lifespan of the system? Mount ext4 partition with >4KiB block size I'm attempting to mount a partition from a NAS and the block size is 65536 bytes, this is above my distribution's precompiled kernel memory paging size of 4KiB, so I cannot mount it normally.  Which kernel compilation parameters would I need to change to get a memory paging size large enough?  Would it be possible under the x86-64 architecture?  EDIT: There doesn't seem to be an option for it in make xconfig unless I'm just missing it.  From page_types.h under arch\x86\include\asm  /* PAGE_SHIFT determines the page size */ #define PAGE_SHIFT  12 #define PAGE_SIZE   (_AC(1,UL) &lt;&lt; PAGE_SHIFT) #define PAGE_MASK   (~(PAGE_SIZE-1))`   It doesn't look to be configurable.  I could change this number directly to 16 and it would probably make pretty explosions and destroy Tokyo.  I shall probably try it later this evening. Explanation of method for showing that $\frac{0}{0}$ is undefined apt: how to be sure that a specific package gets installed/updated from specific repository and not from the default one? For $G$ group and $H$ subgroup of finite index, prove that $N \subset H$ normal subgroup of $G$ of finite index exists For an isolated system, can the entropy decrease or increase? In any sizable system, the number of equilibrium states are much, much greater then the number of non-equilibrium states. Since each accessible micro state is equally probably, it is overwhelmingly likely that we will find the system in an equilibrium state.   However, for a closed system, one that does not interact with any external system, the number of micro states is fixed. Therefore the entropy is fixed.  At any given time, the system will be in one of its micro states. Even if the system is in a micro state that does not look like equilibrium from a macroscopic point of view, its entropy will remain the same, since entropy is a property of all the micro states, not just a given micro state.   So, are the number of accessible micro states (and hence entropy) of an isolated system constant? lualatex MWE not working How to convert string to boolean php table of contents no word separation Is it possible to have in the toc no word separation but have a word separation in the chaptername:  For example:   Contents  1. max Mustermann   Chapter  Max Muster- mann I am used to see timestamp everywhere by it's color. The recent timestamps are a little bit reddish everywhere. E.g. in Meta Stack Overflow:  Last edit:        Last seen:        But in Meta Stack Exchange they have same color everywhere even for recent time:  Last edit:        Last seen:         Please make it something like this: It is often stated that the Lagrangian formalism and the Hamiltonian formalism are equivalent.   We often hear people talk about eigenvalues of Hamiltonians but I have never ever heard a word about eigenvalues of Lagrangians.   Why is this so? Is it not useful? is it not possible to do it? Determining ethnicity according to ancestry? Allow adding bounties from the iOS & Android app (I was surprised I couldn't find this in an existing question, so here goes)    I'd like to add a bounty to a question, but I'm too lazy to go get my computer or a web browser. I like the SE app, and want to use it to do everything. I can't find the button to add a bounty to a question.  Please add this button, I really want to be able to add bounties to questions from the app. Let $A=\begin{pmatrix}0&amp;5\\ 7&amp;4\end{pmatrix}$.      1) Write $A$ as a product of $4$ elementary matrices.      2) Write $A^{-1}$ as a product of $4$ elementary matrices.   My work. I have managed to find $A^{-1}$, which came out to be this:  \begin{pmatrix}-\frac{4}{35}&amp;\frac{1}{7}\\ \frac{1}{5}&amp;0\end{pmatrix}  However, I am struggling to figure out how I would split each of these matrices into $4$ elementary matrices. Any help? How make f[{x,y}] evaluate as f[x,y]? Is there a way to find out if I need a transit visa for Canada? I'm passing through Canada, on my way to somewhere else. I'm staying only a short time.   Is there a website, or some other way of find out out if I need a visa? Highlight text in code listing while also keeping syntax highlighting I’m using the listings package for code listings. Now I try to highlight some part of the code using \hl from the soul package.  Here’s an example of a resulting query where the injected part of a SQL injection should be highlighted:  \begin{lstlisting}[escapechar=@,language=SQL] SELECT name, password FROM users WHERE name='@\hl{' UNION SELECT "10", 1 \#}@'; \end{lstlisting}   But inside the highlighted part the SQL syntax highlighting is not applied.  So I tried to use \lstlinline for the code part inside \hl as well but it didn’t work:  \begin{lstlisting}[escapechar=@,language=SQL] SELECT name, password FROM users WHERE name='@\hl{\lstinline[language=SQL]$' UNION SELECT "10", 1 #$}@'; \end{lstlisting}   Although this \lstinline part works outside the lstlisting block, it doesn’t work inside it. The error I get for that particular line is:     Extra }, or forgotten \endgroup.   Maybe I’m just missing just some special syntax to get this working. Or is it not possible at all to get proper syntax highlighting for the \hl-highlighted part as well? "Give a hand" vs "Help" Currently, I'm working in an international company with many non-native speakers (so am I) but with pretty good level of English, I suppose.  I have noticed that my colleagues usually use phrase "give a hand" when asking for  help or even talking about it and seems to be avoiding the strong word "help".  It looks a bit confusing to me especially after I made people laugh when I said  "I will help you" in one of our conversations, don't remember exact context though...  So could you please describe the difference between them? And is there something wrong or hidden meaning with help-based phrase? Top Answers in network profile shows incorrect score post of mine has a score of 13, but the  shows that it has 14:  This seems to be a recur of  bug; @Catija's  says it's been fixed.  Can we fix that (again)?