In Excel 2016, I have a column with cells that contain comma delimited strings. I am trying to count the number of unique strings in the entire column.   I know how to count the number of unique comma delimited strings within one cell and I know that I could collapse the data in my column into a single cell and do it that way. The problem is that would exceed the character limit of one cell since I have too much data.  Here is an example image which shows what I am trying to do:    The number 8 in B3 is the final result I am looking to get.  I don't know if this is possible to do using an array formula but I have attempted to write down the logic of a vba function to accomplish this. What I have so far is this pseudocode:   Function UniqueK (cells As Range) As Integer     Dim count As Integer     Dim temp_array() As String     Dim final_array() As String     Dim cell As Variant  For cell In cells     temp_array = split(cell,",")     append temp_array to final_array Next cell  remove duplicates in final_array count = number of entries in final_array UniqueK = count End function   This is probably a really slow way of doing it and I was wondering if there was an easier way of accomplishing this task or if there is an existing way of doing it that I could not find. If not, are there ways to remove duplicates in a string array and ways to append a string array to the end of another string array so I can get this function to work?
I would like to count the number of unique selections from a column that contains multiple selections from a drop down list.  For example, column B3 contains,     Monday, Tuesday, Wednesday   The count function returns a value of 1 instead of 3 - is there any way to count the three days distinctly? Thank you!  Multiple selections from a drop down list was made possible using the VBA code from:
Finding the closest Geometry in PostGIS Food in the Star Wars Universe? In the 3rd and 4th editions of D&amp;D, there were explicit rules for determining if a character knew anything about a monster before them.  In 3rd edition, for example, use of the  skill with a general DC of 10 + the monster's HD allowed for determining one fact, plus one fact per 5 points over the check.  Looking at the Intelligence section of the 5e PHB, I don't see any similar notation.  Does 5e provide any guidance as to when a player could use their out-of-game knowledge about a monster, or when the player might be told things their character would probably know in-game? Shortcut to view wireless networks in Windows 7 Does anyone know how to create a shortcut which opens the wireless networks dialog box in Windows 7?  I'm looking for a shortcut that takes me directly to the window which shows you the available wireless networks around you. How can I formalize that the function $$f:\mathcal{P}(A)\to(A\to \{0,1\})$$ is bijective? It seems clear to me but I don't know how to write a proof. Thanks in advance. Filter subscription email is not being delivered (June 2019 - Feb 2020) I have created a custom filter in  and specified that I would like to get email updates:  However, I never got a confirmation mail nor any notifications based on my filter. I tried the &quot;resent confirmation mail&quot; button on the right hand sidebar:  But again nothing happens. The mail address should be fine  I used it for all kinds of notifications from Stack Exchange. For example the rep recalculation email arrived just fine on this address.  I retyped it several times to make sure there really isn't any typo  I double checked that it did not end up in the spam filter  I don't think it is a problem with my particular email provider, users with other mail providers seem to have the same problem, see     This is possibly related to , but this claims to be &quot;status complete&quot;.   EDIT: Although the &quot;status-completed&quot; tag was added, the problem still persists  EDIT 2: As of Feb 2020, it finally works I started reading "The Mathematics of nonlinear Programming - AL peressini" recently.  Theorem : Suppose that $f(x) , f'(x) ,f''(x)$ exist on the closed interval $[a,b]$. If $x^* ,x $ are two different points of $[a,b]$ , then there exists a point $z$ strictly between $x^*$ and $x$ such that   $$f(x)=f(x^*)+f'(x^*)(x-x^*)+\frac{f''(z)}{2}(x-x^*)^2$$  I tried to prove this theorem using The Fundamental theorem of calculus. But I can not stop it at the second derivative . Do I have to use mean value theorem ? or is there a simple proof for this ? Angle notation for complex numbers in polar form Is there any way to recover deleted files which may have since been overwritten? Suppose $\sum a_n$ converges absolutely and $\sum b_n$ converges. Give an example where the Cauchy product does not converge absolutely. Removed Windows 7 and installed Ubuntu Server 12.04, but Windows Boot Manager still appears How can I produce a 'ring (or wheel) chart' like that on page 88 of the PGF manual? I really like the 'ring chart' or 'wheel chart' given as an example on page 88 of the PGF manual. It is like a pie chart, but with a label in the centre. Unfortunately, the manual doesn't give the source for that chart. Does anyone have an example? Thanks. Is there anyway to remove denied permissions from a group for a folder if I dont have access? Trying to identify pre-1970s short story involving multiple humans absorbed into an alien blob I think this story dates from the 1950s, plus or minus a decade - I read it about 30-35 years ago in a (then) fairly old story collection. It involves explorers on a planet falling into a gelatinous object that dissolves most of their bodies except for their brains and nervous systems. About four of them fall in to the same creature, and they discover that by thinking about it they can grow limbs and other body parts. At first they try to fight each other, by growing arms so they can hit each other's brains - and one of them realises that growing a skull would be a good idea - but later they agree to grow legs and move the creature around co-operatively. I would love to identify this story. I have a multiboot system set up. The system has three drives. Multiboot is configured with Windows XP, Windows 7, and Ubuntu - all on the first drive. I had a lot of unpartitioned space left on the drive and was reserving it for adding other OSes and for storing files there in the future.  One day I went ahead and downloaded Partition Wizard and created a logical NTFS partition from within Windows 7, still some unpartitioned space left over. Everything worked fine, until I rebooted the computer a few days later.  Now I'm getting:    error: unknown filesystem.   grub rescue&gt;   First of all I was surprised not to find any kind of help command, by trying:    help, ?, man, --help, -h, bash, cmd, etc.  Now I'm stuck with non-bootable system. I have started researching the issue and finding that people usually recommend to boot to a Live CD and fix the issue from there. Is there a way to fix this issue from within grub rescue without the need for Live CD?  UPDATE  By following the steps from , I was able to boot to initramfs prompt. But not anywhere further than that.  So far from reading the manual on , I was able to see my drives and partitions using ls command. For the first hard drive I see the following: (hd0) (hd0,msdos6) (hd0,msdos5) (hd0,msdos2) (hd0,msdos1)  I now know that (hd0,msdos6) contains Linux on it, since ls (hd0,msdos6)/ lists directories. Others will give "error: unknown filesystem."  UPDATE 2  After the following commands I am now getting to the boot menu and can boot into Windows 7 and Ubuntu, but upon reboot I have to repeat these steps.    ls ls (hd0,msdos6)/ set root=(hd0,msdos6) ls / set prefix=(hd0,msdos6)/boot/grub insmod /boot/grub/linux.mod normal   UPDATE 3  Thanks Shashank Singh, with your instructions I have simplified my steps to the following. I have learned from you that I can replace msdos6 with just a 6 and that I can just do insmod normal instead of insmod /boot/grub/linux.mod. Now I just need to figure out how to save this settings from within grub itself, without booting into any OS.  set root=(hd0,6) set prefix=(hd0,6)/boot/grub insmod normal normal   UPDATE 4  Well, it seems like it is a requirement to boot into Linux. After booting into Ubuntu I have performed the following steps described in the :  sudo update-grub sudo grub-install /dev/sda   This did not resolve the issue. I still get the grub rescue prompt. What do I need to do to permanently fix it?  I have also learned that drive numbers as in hd0 need to be translated to drive letters as in /dev/sda for some commands. hd1 would be sdb, hd2 would be sdc, and so on. Partitions listed in grub as (hd0,msdos6) would be translated to /dev/sda6.  UPDATE 5  I could not figure out why the following did not fix grub:  sudo update-grub sudo grub-install /dev/sda   So I downloaded  based on an answer from  post. That seemed to do the trick after I picked the "Recommended Repair (repairs most frequent problems)" option. $|_{x=1}$ notation? I had the equation: $$\frac{1}{(1+x)(1-x)^2}=\frac{A}{(1-x)^2}+\frac{B}{1-x}+\frac{C}{1+x}$$ $$A=\left.\frac{1}{1+x}\right|_{x=1} = \frac{1}{2} \tag2$$ What does $(2)$ mean? Particularly, the notation $|_{x=1}$ Windows using too much RAM, how to diagnose resource hog I have 16GB of system RAM. On startup with no applications open except the task-manager Windows is using about 3gb of RAM. I looked in the processes tab, but nothing seems to be out of the ordinary. How can I find out why my Windows is using so much RAM.    all processes from all users      Reading from the poolmon it seems that my wireless broadcom driver is using about 0.4GB of of RAM. Even if I remove  it would still be using  2.6GB on start-up, which is still too much.      After reinstalling the wireless driver associated with the memory leak. I have a new screenshot and would like to confirm that it was indeed a memory leak. Repeated ANOVA unbalanced data I did experiment on one group of rats, the group was tested during 8 days, this is the first stage. The same group was also tested again but this time the test phase was 7 days. I tried to do my analysis using ANOVA repeated measures but I had a problem with the days.. I want to know the difference in the 2 tests but the days are not the same number. I don't know how to handle it. If there is any way to do the analysis using repeated measures ANOVA.   I tried to use repeated measure anova within subjects effect. My first factor will be test with 2 levels (test 1 &amp; 2),second factor is day with the level of ?? Here is the problem! if I write 8 there will be extra day in test 2 and the analysis cant carry!! How to find the sum of the series $1+\frac{1}{2}+ \frac{1}{3}+\frac{1}{4}+\dots+\frac{1}{n}$? How to find the sum of the following series? $$1 + \frac{1}{2} + \frac{1}{3} + \frac{1}{4} + \dots + \frac{1}{n}$$ This is a harmonic progression. So, is the following formula correct? $\frac{(number ~of ~terms)^2}{sum~ of~ all ~the~ denominators}$ $\Rightarrow $ if $\frac{1}{A} + \frac{1}{B} +\frac{1}{C}$ are in H.P. Therefore the sum of the series can be written as : $\Rightarrow \frac{(3)^3}{(A+B+C)}$ Is this correct? Please suggest. How to have colors in Milky-way? Many photos of Milky-way show it in nice colors instead of just the black of sky and white of the stars. Is the key to having those colors in the capturing of the image or in the post processing, or both? Or am I just doing it in a wrong time of year when the visible part of Milky-way is simply not showing color?  Here is a sample photo of how Milky-way looks like in Finland in September:    APS-C sensor camera, 18 mm, 30 sec, f/3.5, ISO 3200 - captured in pitch-black darkness of Finnish countryside, far far away from any citylights, at time when moon was still below visible horizon.  What I'd like to achieve is something like the photo in Vivek's answer to   I've just bought a wireless shutter release for longer bulb exposures, and have plans to build a barn-door tracking mount. But is longer exposure the needed trick, or what is?