Multiple Search Formula in Excel
Excel multiple FIND formula
Is there a keyboard shortcut to "unselect" in Windows Explorer? If I've got a file (or files) selected in Windows Explorer, the only way I've found to "unselect" them is click with the mouse on some empty space.  I thought Esc would do this, but it doesn't. Also changing focus with Tab or Shift + Tab doesn't work; the file(s) are still selected even if focus goes to the address bar for instance.  Does anyone know of a keyboard shortcut to do this? I don't always answer myself, but when I do, I fail to ask a good question Sometimes I'll encounter problems while coding, or sometimes out of simple interest for a question, I'll google for an answer, and most of the time I find that answer is here on stackoverflow.com.   If I can't find an answer, or if it's not enough to satisfy my curiosity, sometimes I expend my own effort to solve those questions. And after I've solved it, I'm happy to make my contribution to the community, and I post them as the Q&amp;A style posts. For example:     It seems relatively easier to ask a question if I didn't already have a solution, and I can put what I have so far in the question body, such as:     The problem to me is, if I have my own solution to my own question, then most of what I have so far becomes part of the solution. It's likely I have failed in making my contribution by asking a question to which I have an answer, for example:     So I'm wondering if there are some guidelines or good practices for Q&amp;A style posts?   How do I do it better? Determine the Galois group of $\mathbb{Q}(\sqrt{a+b\sqrt{d}})$ Suppose $L=\mathbb{Q}(\sqrt{a+b\sqrt{d}})$,($d$ and $a+b\sqrt{d}$ are square free algebraic integers) when is $L/\mathbb{Q}$ a normal extension? When does $Aut(L/\mathbb{Q})=\mathbb{Z}/4\mathbb{Z}$ or $Aut(L/\mathbb{Q})=\mathbb{Z}/2\mathbb{Z}\times \mathbb{Z}/2\mathbb{Z}$? mysqli::query(): Couldn't fetch mysqli Database schema documentation for the public data dump and SEDE I understand that the expressions on both sides of an equal sign are the same entity, and I know that when you modify one side, the other must be changed because it is referring to the same thing. What I do not understand is why making a new equation (adding or taking away from an expression) allows one to know what an unknown represents. What about equations lets us do this? Logical Volume, Physical Volume and Volume Groups Is it appropriate to remove excessive commenting from code? I am referring to this question on SO , where there is a massive amount of commenting within the code (the question has since been edited to correct this).  Is it allowed to remove these for the sake for readability (the comments just specify some lesson details, method comments etc)? If we multiply 2 number and take the mod with prime this is equivalent to first taking mod with the prime of individual number and then multiplying the result and again taking mod.  $$ ab\bmod p = ((a\bmod p)(b\bmod p))\bmod p$$  does there exist any proof for this?  Does it work for composite moduli too? Then I can use the Chinese remainder Theorem to calculate the result does there any other way apart from Chinese remainder Theorem to solve the problem? I have installed a package using snap and I need to modify one of the files but when I try to change its ownership or permissions, I always get the following message:  sudo chmod +x ./my_file.js chmod: changing permissions of '/snap/my_app/my_file.js': Read-only file system   How can I modify files that are installed via snap? Intro  I'm working on a lightweight package that allows you to put any content (typically LaTeX code) in an environment, then use that content multiple times, each time scanned separately, so you can use it both as verbatim output and interpreted as LaTeX.  Its main purpose is to typeset LaTeX code and its 'result' side-by-side; useful for documenting TeX packages without having to copy/paste code. But it has other purposes as well.  After experimenting with \scantokens until I gave up in tears, I arrived at the filecontents environment, which almost solved my problem singlehandedly!  The Problem  The problem is, when reintroducing filecontented code through \input, LaTeX adds an implicit newline at the end, which translates to whitespace that I can't seem to get rid of.  I've seen many semi-related questions floating around, with answers employing techniques like:   reading a file line-by-line, using \everyeof in some clever way, playing with \endlinechar or using packages such as catchfile   but none of them provides a clear answer to the following question:  The Question  How can I \input a file without getting the implicit newline?  Minimal Working Example  \documentclass[margin=1mm]{standalone}  \usepackage{filecontents}  \begin{filecontents*}{tmp.tex}     \LaTeX{}\end{filecontents*}  \begin{document}     \fbox{\input{tmp.tex}} \end{document}     Note the extra whitespace to the right of the box.  Note also that I'm definitely not adding any explicit whitespace. Even a manually produced file (so, not using filecontents) with no newlines at all exhibits the same problem. How can I find my Bug-report that I submitted from the Desktop on launchpad?  I have found a partial solution to my own question:  The program that sends the Bug-reports from the desktop is called apport. It doesn't requires a launchpad account. The service whoopsie submits the Bug-Report directly to the server daisy.ubuntu.com (I'm not sure if those bugs actually appear on launchpad publicly.)  But I found my Bug-Report on my Harddisk in /var/crash/ .  From there I can copy and paste parts of the file to my opened bug on launchpad. Thanks for your tips.  Original question:  I had a severe bug, and I found someone with the same problem in launchpad. After I found a temporary fix I was able to submit the bug with the ubuntu-bug-reporter.  How can I find this ubuntu-bug-reporter generated bug-report in launchpad? I would like to combine those two bug-reports (mark as duplicate). Because the generated one has all the debug information and the other one has the description of this bug. I need to upgrade my existing Ubuntu system, and I also want to install Ubuntu on a new laptop.  I would like to have an installation CD or DVD to do both of these.  Where exactly I can order or request an Ubuntu installation CD/DVD/USB? Is there a simple and clear way to explain the difference between past simple and present perfect? I read (or do I say "have read"?) many rules for when to use the present perfect. I found them complex and hard to understand (or do I say "have found"?). I am finding it hard to apply these rules in real sentences.  Is there a simple and clear way to explain the difference between past simple and present perfect? If there is a simple explanation, please tell it! If there is no simple explanation, please tell why it is so complicated. Maybe if I knew why there is no simple explanation, that would help me understand what work I need to do in order to learn the difference. Prove $(a+b)^\frac{1}{n} \le a^\frac{1}{n} + b^\frac{1}{n}$ Prove: $$ (a+b)^\frac{1}{n} \le a^\frac{1}{n} + b^\frac{1}{n}, \qquad \forall n \in \mathbb{N} $$ I have have tried using the triangle inequlity $ |a + b| \le |a| + |b| $,  without any success. Where are the NetworkManager logs? A previous poster on the regular forums (  ) said /var/log/daemon.log, but I don't seem to have such a file. Do I need to enable logging? When are "because", "since","for" and "as" interchangeable? I am not a native speaker. On a previous question of mine, I thanked for an answer by saying:     So the phrase is not an idiom, since it is applied in its literal sense.   I consciously chose since over because, because — well, I like that usage of since, even though I know that some (native speakers) don't like it. Nonetheless, that choice got me thinking for a while, and it occurred to me that I even could have used more alternatives, namely as or for, without changing the meaning.   So, on a general note, here are the alternatives:        Statement A (is true), because statement B (is true).   Statement A (is true), since statement B (is true).   Statement A (is true), as statement B (is true).   Statement A (is true), for statement B (is true).      Are these completely interchangeable? Or interchangeable in certain situations? Or can you point out any (not-so-)subtle differences between any of them? Are there even more synonyms? I asked  that turned out to have multiple correct answers. How do I pick between them to determine which to accept?  All of the answers were different. They were not the same answer given multiple times. The vertices of an equilateral triangle are shrinking towards each other How to connect nodes to node group inputs and outputs in python?