Excel 2016 formula to include only unique values
How to count number of distinct values in a range?
How to return multiple objects from a Java method? I want to return two objects from a Java method and was wondering what could be a good way of doing so?  The possible ways I can think of are: return a HashMap (since the two Objects are related) or return an ArrayList of Object objects.  To be more precise, the two objects I want to return are (a) List of objects and (b) comma separated names of the same.  I want to return these two Objects from one method because I dont want to iterate through the list of objects to get the comma separated names (which I can do in the same loop in this method).  Somehow, returning a HashMap does not look a very elegant way of doing so. Are there any options of bash with which it is invoked? I  that the default shell that I use when I start Terminal (with Ctrl+Alt+T) is /bin/bash.   And running the built-in command  on  as:   type -p bash   returns the result as:  /bin/bash   Suggesting the same executable is run when I do Ctrl+Alt+T or say bash.  This shell is the same as an invocation of the command  with some of its options passed to it right? If yes, what are these options?   As an example, perhaps the -i option gets passed so as to make the bash shell interactive?   PS: Maybe  is related too, but I cannot seem to piece together all the pieces here. How to change radius/weight of curve bezier? try scaling, change radius, but its dont work Why is the determinant of a symplectic matrix 1? Suppose $A \in M_{2n}(\mathbb{R})$. and$$J=\begin{pmatrix} 0 &amp; E_n\\   -E_n&amp;0  \end{pmatrix}$$ where $E_n$ represents identity matrix. if $A$ satisfies $$AJA^T=J.$$ How to figure out $$\det(A)=1~?$$ My approach: I have tried to separate $A$ into four submartix:$$A=\begin{pmatrix}A_1&amp;A_2 \\A_3&amp;A_4 \end{pmatrix}$$ and I must add a assumption that $A_1$ is invertible. by elementary transfromation:$$\begin{pmatrix}A_1&amp;A_2 \\ A_3&amp;A_4\end{pmatrix}\rightarrow \begin{pmatrix}A_1&amp;A_2 \\ 0&amp;A_4-A_3A_1^{-1}A_2\end{pmatrix}$$ we have: $$\det(A)=\det(A_1)\det(A_4-A_3A_1^{-1}A_2).$$ From$$\begin{pmatrix}A_1&amp;A_2 \\ A_3&amp;A_4\end{pmatrix}\begin{pmatrix}0&amp;E_n \\ -E_n&amp;0\end{pmatrix}\begin{pmatrix}A_1&amp;A_2 \\ A_3&amp;A_4\end{pmatrix}^T=\begin{pmatrix}0&amp;E_n \\ -E_n&amp;0\end{pmatrix}.$$ we get two equalities:$$A_1A_2^T=A_2A_1^T$$ and $$A_1A_4^T-A_2A_3^T=E_n.$$ then $$\det(A)=\det(A_1(A_4-A_3A_1^{-1}A_2)^T)=\det(A_1A_4^T-A_1A_2^T(A_1^T)^{-1}A_3^T)=\det(A_1A_4^T-A_2A_1^T(A_1^T)^{-1}A_3^T)=\det(E_n)=1,$$ but I have no idea to deal with this problem when $A_1$ is not invertible. Since I started learning  and  last year, I've read a huge number of articles which insist that design patterns (especially in Java) are workarounds for the missing features in imperative languages. One article I found :     Most people I've met have read     by the Gang of   Four (GoF). Any self respecting programmer   will tell you that the book is   language agnostic and the patterns   apply to software engineering in   general, regardless of which language   you use. This is a noble claim.   Unfortunately it is far removed from   the truth.      Functional languages are extremely   expressive. In a functional language   one does not need design patterns   because the language is likely so high   level, you end up programming in   concepts that eliminate design   patterns all together.   The main features of functional programming (FP) include functions as first-class values, currying, immutable values, etc. It doesn't seem obvious to me that OO design patterns are approximating any of those features.  Additionally, in functional languages which support OOP (such as F# and OCaml), it seems obvious to me that programmers using these languages would use the same design patterns found available to every other OOP language. In fact, right now I use F# and OCaml every day, and there are no striking differences between the patterns I use in these languages vs. the patterns I use when I write in Java.  Is there any truth to the claim that functional programming eliminates the need for OOP design patterns? If so, could you post or link to an example of a typical OOP design pattern and its functional equivalent? Equivalent Definitions of the Operator Norm Tracking down where disk space has gone on Linux? wrong numbering for subcaption in scrbook When using the scrbook document class in combination with the subcaption  package, the numbering of subfigures seems broken. Consider:  \documentclass{scrbook} \usepackage{xcolor} \usepackage{caption} \usepackage{subcaption} \captionsetup{%   format=hang,%   font=small,%   labelfont={sf,bf},%   aboveskip=0.2\normalbaselineskip,%   position=top } \pagestyle{empty}  \begin{document} \begin{figure}   \caption{Black}   \label{fig1}   \centering \rule{2cm}{2cm} \end{figure}  \begin{figure}   \caption{More figures}   \label{fig2}   \centering   \begin{subfigure}{.3\textwidth}     \centering     \caption{Blue}     \label{fig2a}     \color{red}\rule{2cm}{2cm}   \end{subfigure}   \begin{subfigure}{.3\textwidth}     \centering     \caption{Green}     \label{fig2b}     \color{green}\rule{2cm}{2cm}   \end{subfigure}   \begin{subfigure}{.3\textwidth}     \centering     \caption{Blue}     \label{fig2c}     \color{blue}\rule{2cm}{2cm}   \end{subfigure} \end{figure}  Figure \ref{fig1} shows a black box. Figure \ref{fig2} shows colored boxes, where Figure \ref{fig2a} shows a red box, Figure \ref{fig2b} shows a green box, and Figure \ref{fig2c} shows a blue box. \end{document}   This results in the following display:    Clearly, the figure numbering in the text references is off by one for the subfigures. Instead, if I change the document class to article, it looks fine:     Why does this happen, and how can I prevent it? Regular Expressions: Is there an AND operator? Obviously, you can use the | (pipe?) to represent OR, but is there a way to represent AND as well?  Specifically, I'd like to match paragraphs of text that contain ALL of a certain phrase, but in no particular order. Evaluate $\lim\limits_{n\to\infty}\frac{\sum_{k=1}^n k^m}{n^{m+1}}$ Can we switch terminals at Heathrow (LHR) for shopping only? We will be flying into and out of Terminal 5 at Heathrow. Now, my wife has taken fancy to a certain duty-free store located at Terminal 3. Assuming we factor in enough time before boarding our outbound flight from Terminal 5, are we allowed to enter Heathrow from Terminal 3, shop and then shuttle over to Terminal 5? I have two user profile fields "Last Name" and "First Name". I also have a user list views. I want to expose "Name" as filter which can search for both Last Name and First Name. How can I do single filter of combination of those two fields? Can I create it from views UI?  One possible way is to create another profile field "Name" which will be hidden in the form. On user save, I would combine the two field values into the "Name" field and then expose it as filter in the views. But this solution is hard coding and it needs to write hooks. I'm trying to use biblatex and when I compile my document I get an error like the following:  Windows  data source C:\Users\&lt;username&gt;\AppData\Local\Temp\par-5061756c\ cache-890efc00b3ca6b775c7d44a325c1349fb2a3a3bd\inc\lib/Biber/LaTeX/recode_data.xml not found in .   Mac  data source /var/folders/v2/rld0ls7d2935gkvqv5hfr1x00000gn/T/par-616c616e/ cache-cdd483146f82a9655ce063f848d5139480fbf872/inc/lib/Biber/LaTeX/recode_data.xml not found in .   Linux  data source /tmp/par-6963617269756d/cache-f37ab610b7d79b2720a8ee3732849c6821705520 /inc/lib/Biber/LaTeX/recode_data.xml not found in . Memory allocation for member functions in C++ For a graph $G$, let $W$ be the (random) vertex occupied at the ﬁrst time the random walk has visited every vertex. That is, $W$ is the last new vertex to be visited by the random walk. Prove the following remarkable fact:      For the   random walk on an $n$-cycle, $W$ is uniformly distributed over all vertices different   from the starting vertex. Roll back from OS X Mavericks ( or any newer OS) to Mountain Lion I installed the developer preview of OS X Mavericks, &amp; too many things broke. I can't stay on it &amp; need to roll back to Mountain Lion. Any ways of doing that? Please help!  I originally installed Mountain Lion &amp; Mavericks through the Mac App Store. Can houseplants actually improve air quality? How to illuminate the darkness inside glass objects in Cycles? My model has a clear plastic (or glass) dome with objects inside.  The objects appear dark.  I've tried the glass shader with color 100% RGB, with very small IOR, and using just a refraction shader.    I know Cycles has problems with caustics, but I just want broad illumination to fall clean through the glass.  The light-to-column path can ignore refraction, but is blocked or tremendously attenuated. The camera-column path needs refraction, and seems to work fine anyway.  This demo image offers all optical paths of interest:   light upon object, seen directly light upon object, seen through glass (looks okay) light through glass onto object, seen directly. This is the shadow on the lit side of the column just below the glass tubing.  I expect full illumination, but there is shadow.  There is some light, but it's diffuse light from the floor. light through glass onto object, seen through glass. This     I did at one point try non-progressive rendering, and find extremely coarse light where there shouldn't be shadow, but this is not a practical way to make nice images. I've even tried cranking up certain sampling settings to many thousands, but still get bad noise though less, at the cost of long render times. I  would like to finish my creations sometime before "Star Trek, the Generation After the Next" becomes real life, if you know what I mean.  The next image is an example. I think Transmission in Sampling was 5000, but not sure.    I'm using Cycles in Blender 2.67 on a quad core Linux machine, 16GB RAM. Machine limits have never been a problem for 3D rendering.  Possibly, I screwed up some setting when I made my startup file, and just need to fix it. OTOH maybe this is just a limitation of path tracing, or of the way Cycles does it. If that's the case, what to real-world Blender artists do when they need to produce images on a budget and schedule?  What is the practical real-world fix? Is it fair to buy a return ticket I know I will never use just because it's cheaper? I have a Win 7/11.10 dual boot system with Grub 2 as the default bootloader. However, I want to make Windows bootloader the default bootloader (grub 'dos' like interface scrares the hell out of my sister) so when I start the PC I will have the following boot options: 1. Windows 7 2. Ubuntu  NB: A process to reverse this operation so Grub can be the default bootloader again will also be appreciated