I have a workbook that contains about a dozen sheets. One sheet is called "Summary", and most of the data in it is either a reference to another sheet ( ='Pre-Survey'!C10 ) or a label ( =ShipName ). My client wants me to email him just the Summary page as a one sheet Excel workbook. If I use 'Move o...

To get the count in N1 put: =COUNTIF($A:$A,"*" & M1 & "*") then you can use this formula to find the value with the most: =INDEX(M:M,MATCH(MAX(N:N),N:N,0)) In one formula, with your prefixes still in M1:M3, use this array formula: =INDEX($M$1:$M$3,MATCH(MAX(COUNTIF($A$1:$A$4,"*"&$M$1:$M$3&"*")),COUN...

I'm trialing Github desktop for our designers, so they can easily work within a repository that devs do as well. Github desktop seemed OK, but I just made 2 commits via the cmd line rather than the interface, and the app seems to have no idea that those commits are now available to be pushed to remo...

I have been getting that System Notification (Windows Background.wav) ding noise more often then usual and I have been unable to determine what is causing the sound to play. Is there a way to use event view or something to get a log of when and what caused Windows Background.wav to play? Windows bac...

Situation: on linux (Mint): new exte al WD usb disk (after plug-in autodetected, accesible via /media/user, also visible via df cmd) formated to the ext4 (I know, my stupid step :( - but I had a reason for this step) from this moment the disk can not see from df cmd, only from the graphical (compute...

I'm trying to do a formula that within a range makes a list based on info on a specific array. What I need is an array that aufills this list based on the following conditions: 1)It has to be the first time the value appears 2)The value can't be " " 3)The value can't be repeated in the autofilling l...

I'm trying to install Qubes 3.1 on a Lenovo G50-30 from a usb drive. After selecting the option to boot, the system shows a loading bar and the Qubes logo, a few seconds later i get this message: dracut-initqueue[520]: Wa ing: Could not boot dracut-initqueue[520]: Wa ing: /dev/root does not exist I'...

I have just set up the Netgear C6300 Cable Modem Router and re set up all my inte al IP's so my main PC will always be 192.168.0.2 and my server (ubuntu server) will always be 192.168.0.10 I have forwarded ports 80 (HTTP), 3306 (SQL), and 22 (SSH) directed at inte al IP 192.168.0.10 (ubuntu server) ...

I'm writing an application that is doing some monitoring to the web pages titles. I've noticed that when you play audio from a tab, chrome adds the 'Sound Activity Icon' to all other tabs (even if they don't play sound). The icon isn't noticeable on the browser, but I definitely see this issue with ...

Background info Between 2003 & 2013 I had the habit of saving important emails out of my email account to my local hard drive as *.eml files. (I no longer do this, relying on the vast backup capabilities now freely available with many email accounts.) In the last 18 months I've been working from Arc...

Is it possible to change GUI language in Devart dbForge for MySQL? Wish to change from Russian to English?

put on hold as unclear what you're asking by Xavierjazz, Jou eyman Geek♦ 37 mins ago Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying...

I opened .exe file with other programme and now I cant restore bcogz of it all apps like net protector ,vlc media player cant open how to fix the problem please help me

I have an Acer Power S260 which I am trying to boot from a USB flash drive to install a Linux variant. There are options in the BIOS for booting from USB-FDD, USB-ZIP, and USB-CDROM, but not from USB-HDD or USB. I've tried all of the possibilities without success. I've also looked for an option to s...

I want to do a tilde (~) on my virtual machine Ubuntu Server (14.04.4) but I couldn't do it from now. I have OSX as OS (QWERTZ keyboard). How is it possible to do it ? I already look at some topic and this one : How can I type tilde (~) in the Ubuntu terminal with a Norwegian keyboard? but no one of...

I looked at this diagram and I am wondering me that the increasing of the CPU performance seems to stop although the transistor count is still increasing. I mean what are the profts of the increasing transistor count after 2005? All other specs stoped to increase. Let's block ads! (Why?)

I'm trying to play a high definition video with vlc but it's really laggy and sometimes in between, the screen becomes almost 70% green. I'm able to play the same file with no problems using ffmpeg with the ffplay command so I think my hardware can handle it. Is there any way I can tweak my vlc sett...

If I configure a network with 10.0.0.0/16 it's range is from 10.0.0.1 to 10.0.255.254, so a host with an IP like 10.0.0.2/16 is ok. But if I configure another network with IP alias (like IP address add 10.0.0.0/24 brd + dev eth0) and another host is configured with an ip like 10.0.0.2/24. Will this ...

perl code to find dimension (width and height) of multiple images that located in image folder and set that dimension in image tag in html pages according their image name. i am try using this code ,if any one having solution then help me. #!/usr/bin/perl use strict; #use wa ings; use Image::Size; u...

tar complains about not finding a directory that exists, and to which I have permissions. I have seen a number of similar questions, but all of them had to do wih the option f not being just before the output file. Not the case here. gauthier@ionian:~ $ ls -l | grep cpdata drwxrwxr-x 2 gauthier gaut...