Printing Selected Area into Desire Map Scale
QGIS Atlas generation for multiple map extents?
How to identify cells in Column A that contain any of the values in Column B First off, I'm not that advanced of an Excel user. I'm certain Excel can do what I'm about to ask, but I've yet to find a way in any of my attempts or searches.  My question is very similar to  except that A) the answers there didn't work for me, and B) even if it did, it's not quite the correct output I need.   Basically, I have 2 columns. Column A contains URLs (16388 rows). Column B contains URL slugs (202 rows).   I want to search to see if any of the values in column B are contained within any of the values of Column A. If they are, I want to return the value TRUE in column C.   From what I've read, VLOOKUP ought to work for this, but for the life of me I can't get it to work. I also tried in the answers in the link above that use COUNTIF and MATCH, but in both of those cases, all I got were FALSE returns, when I know that there are values in Column B that are contained in a URL in Column A.   Does that make sense?  EDIT: Both answers are providing results (thank you!), but I suspect I may not have asked the question correctly. In both of the answers, I'm getting TRUE results, but it looks like the TRUE is correlating to the slug in Column B rather than the URL in Column A. Let me put it this way:  I'll move the slugs from Column B to C so that B can be used for the TRUE responses. What I want the fomula to do is:   Look at URL in A1 Are any of the values in Column C contained within the URL in A1? If yes, then return TRUE in B1. If FALSE, leave it blank.    So I will be able to see which of the URLs contain the slugs I am searching for. I apologize for not being clearer in my original ask (though I feel like it's only a slight tweak from the answers I've already been given.) food safety regarding re freezing twice cooked chicken I am defrosting a cooked chicken to use in a curry it will be thoroughly heated at a high temperature. If I have too much curry will i be able to freeze it, as the cooked chicken was frozen before? I found there are so much excellent answer to questions about how to product high quality typesetting output. But I wonder how to save ink with LaTeX. What we need to think about to manage cost. page layout or something else? How to make a disk image and restore from it later? I'm a new Linux user. I've reinstalled my Wubi from scratch at least ten times the last few weeks because while getting the system up and running (drivers, , etc.) I've broken something (X, grub, unknowns) and I can't get it back to work. Especially for a newbie like me, it's easier (and much faster) to just reinstall the whole shebang than try to troubleshoot several layers of failed &quot;fixing&quot; attempts. Coming from Windows, I expect that there is some &quot;disk image&quot; utility that I can run to make a snapshot of my Linux install (and of the boot partition!!) before I meddle with stuff. Then, after I've foobar'ed my machine, I would somehow restore my machine back to that working snapshot. What's the Linux equivalent of Windows disk imagers like  or ?  Note: I found a similar question: I have a Python script which takes as input a list of integers, which I need to work with four integers at a time.  Unfortunately, I don't have control of the input, or I'd have it passed in as a list of four-element tuples.  Currently, I'm iterating over it this way: for i in range(0, len(ints), 4):     # dummy op for example code     foo += ints[i] * ints[i + 1] + ints[i + 2] * ints[i + 3]  It looks a lot like &quot;C-think&quot;, though, which makes me suspect there's a more pythonic way of dealing with this situation.  The list is discarded after iterating, so it needn't be preserved.  Perhaps something like this would be better? while ints:     foo += ints[0] * ints[1] + ints[2] * ints[3]     ints[0:4] = []  Still doesn't quite &quot;feel&quot; right, though.  :-/ Related question: I cannot find the Polygon Neighbors tool. I have searched for it as I usually do and I have also browsed the proximity toolset but it is not there. The other Tools, e.g. Buffer and Near are there and work fine. Here is a screenshot: "Firstly" or "first"? Sum of Cosine/Exponential I try to simplify to get rid of sum $$ \sum_{k=0}^{n-1}\cos(2 \pi fk)$$  I discover I shall use euler equation to form:  $$ \sum_{k=0}^{n-1}\frac{1}{2}(e^{2 \pi fki}+e^{-2 \pi fki})$$  but how to sum exponentials? How do I downgrade Firefox v. 57 to v. 56? What is the most straight forward way to downgrade Firefox 57 to Firefox 56?   This is to have more time to wait for working replacements for legacy extensions. Proving that $AB-BA=cI$ for nontrivial $c \in \mathbb{C}$ I have a homework question I can`t solve:  Let $X$ be a normed linear space, $A,B \in B(X)$. Show that there exists no nontrivial $c \in \mathbb{C} $ such that $AB-BA=cI$.  Thanks alot already guys! I seem to have a professor who gives impossible homework problems.  The hint he gave: $A^{n}B-BA^{n}=ncA^{n-1}$, $n \in \mathbb{N}$ Are the review queues planned for the iOS app? Is there an idiom available, that is exactly opposite to "Cake walk" or "Child's play"? Prove $n!>2^n$ for $n\geq4$ using induction. I just want to know if my proof to this question is correct. First, I proved it was true for $n = 4$. $$4!&gt;2^4$$ $$24&gt;16$$ Then, I assumed that it was true for $n=k$. $$k!&gt;2^k$$ Afterwards, I tried to prove it for $n=k+1$. $$(k+1)!&gt;2^{k+1}$$ $$(k+1)k!&gt;(2)(2^k)$$ Since $k!&gt;2^k$, am I allowed to simply do $$(k+1)(2^k)&gt;(2)(2^k)$$ $$(k+1)&gt;2$$ and this is true for all $k\geq3$. Would the last two steps be illegal because I only assumed that $k!&gt;2^k$ is true? Answers no longer sorted by score/votes Who decides which half of the universe should be destroyed? I am trying to retrieve list items using date range based on date column. It implicit both 'Fromdate' and 'Todate'.My CAML query is also querying on two other conditions as well. I am using the below query but it is not retrieving the data.when I remove the date range from query data is retrieved fine. But i want date range as well in my query how would i do this. Little help would work for me.   camlQuery.set_viewXml('&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;And&gt;&lt;And&gt;&lt;Neq&gt;&lt;FieldRef Name="ID" /&gt;&lt;Value Type="Number"&gt;0&lt;/Value&gt;&lt;/Neq&gt;&lt;Eq&gt;&lt;FieldRef Name="_ModerationStatus" /&gt;&lt;Value Type="ModStat"&gt;0&lt;/Value&gt;&lt;/Eq&gt;&lt;Geq&gt;&lt;FieldRef Name="Created" /&gt;&lt;Value Type="DateTime"&gt;' + fromDate + '&lt;/Value&gt;&lt;/Geq&gt;&lt;Leq&gt;&lt;FieldRef Name="Created" /&gt;&lt;Value Type="DateTime"&gt;' + toDate + '&lt;/Value&gt;&lt;/Leq&gt;&lt;/And&gt;&lt;/And&gt;&lt;/Where&gt;&lt;OrderBy&gt;&lt;FieldRef Name="_ModerationStatus" Ascending="True" /&gt;&lt;/OrderBy&gt;&lt;/Query&gt;&lt;/View&gt;'); Homeomorphism between the unit disc and the unit square I know that the function that describes the homeomorphism is: $f(x,y) =       \begin{cases}     \frac{x^{2}+y^{2}}{\max(|x|,|y|)}(x,y) &amp;\quad\text{if } (x,y)\ne  (0,0) \\       \text{} (0,0) &amp;\quad\text{if } (x,y) =  (0,0) \\       \end{cases}$  But it's impossible to me to show that $f(x,y)$ is an homeomorphism. Mostly i can't see the injectivity. Google Chrome Address Bar Font has gone too large, how can we reduce it Running Unity on my desktop (2*20" LCD displays), I initiated a standard daily update on my Ubuntu 14.04 LTS today and Google Chrome updated itself to Version 35.0.1916.114.  The URL address bar input now shows IMO a too larger font size which then proceeds to auto show in green. I prefer the smaller font size and have no need for 'gooey slime green' auto complete font colours. Any advice on how to revert back to smaller, generic Address font styling.  I use both FF and Chrome for numerous tasks, Chrome being my primary browser and I've checked my system Unity 'default' theme (Ambiance! LOL.. yes I'm tired of that also).  Thanks for sharing. Linux network troubleshooting and debugging From time to time Linux and Unix users faced with various network problems. Many of these problems are presented here and at some others troubleshooting forums, but they are very concrete and contains a lot of additional technical information, and sometimes it's rather difficult to understand the main point and the real reason of buggy system behavior.   By asking this question, my intention is to start a community wiki page which allows generalizing our network troubleshooting and debugging experience. I hope the Linux and Unix users could easier recognize and solve("divide and conquer") their network problems using this page.   The parent of this page should be  . But here we should focus on troubleshooting the network problems from user- and kernel-space.  I suppose, if you:    Share the information about using some great network diagnostic tool with concrete usage examples and examples of network bugs, which they help to catch. Share the link to the great network tutorial connected with this subject Tell about a general method or recipe which allows to tackle some class of network problems Share information about your tool-set for network debugging and troubleshooting   it would perfectly fits for this topic.    I'll begin from sharing the link to varios  and . Also  seem to have actual information about our subject. And for diving into linux networking we definetely need to visit . The thing with these tags is, you can always (or almost always) use a specific product/technology/language tag which would render the company-name tag completely redundant (see Appendix C for sloppy non-proof). For example, what relevant information would  tag add to  already tagged with ? What would  tag add to  already tagged with ? Another way of looking at this: how much useful information do you lose if you don't tag a question with a company name? Note: I'm not talking about brand/company/organizations like , , ,  because those names also refer to websites/web services with which you can interact via API or from which you can extract data. Appendix C: The &quot;about&quot; test The relationship between a tag and a question can be expressed as such  This question is about [tag]  In case of ,  This question is about [microsoft]  Fair enough. But in reality people are using these company-name tags like this  This question is about something developed by or related to [microsoft]  But if that's the case, you might as well just go with  This question is about [something developed by or related to microsoft]  where  can be , , ... you get the idea.