1,294 reputation
725
bio website
location United States
age 18
visits member for 2 years, 1 month
seen 1 hour ago

18h
comment Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)
You can create a formula on the first sheet that links to a cell on the second sheet. It would look like this: =Sheet2!A1, where Sheet2 is the name of the second sheet and A1 is the cell on the second sheet that contains the data you would like to link.
20h
comment Count Unique Cells Matching Results in Set
@mrwweb Good point. I updated my answer, let me know what you think of this solution.
1d
comment Comparing columns in two different excel sheets and if they match copying third column
Why use the EXACT function instead of, for example, =IF(AND('F1'!A1='F2'!A1,'F1'!B1='F2'!B1),'F2'!F1)? It's shorter and there is no need for a case sensitive match here.
1d
comment vlookup in a cell that contains mid formula
It shouldn't make a difference whether the cell targeted by the VLOOKUP contains a formula or a fixed value. Can you describe what is in columns B and C on the LOCATION LOOKUP TABLE sheet and what is in cell F57?
May
26
comment How to dynamically populate a filter list with “first match” on a row, using excel 2007
What should it return when it finds a match?
May
12
comment Download pictures a second time
Exactly how are you trying to download the pictures? What software are you using?
May
8
comment Averageing numbers in a column while ignoring rows with headers
You might be right. We'll let Jack83 tell us which one he meant.
May
8
comment Averageing numbers in a column while ignoring rows with headers
I may be wrong, but I think the question is asking how to average cells based on whether a separate column is empty, based on the title which says "while ignoring rows with headers".
May
7
comment Empty “notify” file being created on external hard drive
@Hans No, I was not able to figure it out. I tried Process Monitor but I wasn't able to capture the program that created the file. Are you having the same problem?
May
4
comment Jump Lists not showing for Office programs in Windows 7
@magicandre1981 Yes. SP1 and all of the latest updates are installed for Office 2013.
May
1
comment Showing Hidden Files as Hidden in Windows from Linux Samba Share of NTFS Drive
Thank you for your help. The hide files option works well enough for me because most of the hidden files I want to hide all have the same name, so I will accept your answer.
May
1
comment Powerline - potential causes for speed loss
"200Mbps" refers to Megabits, not Megabytes. When you say you are receiving 60MB download, do you mean Megabytes (MB) or Megabits (Mb)?
Apr
30
comment Showing Hidden Files as Hidden in Windows from Linux Samba Share of NTFS Drive
When I run chmod a-x <filename> on a file on the NTFS drive, the permissions do not change, they are still -rwxrwxrwx. As such the files are still hidden when map hidden = yes is included in the configuration.
Apr
29
comment Showing Hidden Files as Hidden in Windows from Linux Samba Share of NTFS Drive
The .jpg pictures on my drive are showing as having -rwxrwxrwx permissions. I don't know much about Linux permissions though. Does this confirm your theory?
Apr
29
comment Showing Hidden Files as Hidden in Windows from Linux Samba Share of NTFS Drive
I added map hidden = yes to the configuration, and every file is hidden now, even ones without the hidden attribute. Using hide files seems to be working though. If nobody suggests a better alternative I will accept your answer.
Apr
27
comment How to get score from text cells without complicated code in excel?
@techie007 Why use a VBA solution when Excel formulas can work just as well?
Apr
26
comment Google products and services not loading at all
Can you describe your network setup? Is this a home Internet conncetion? Are you behind a router? Is there a firewall in your computer or router?
Apr
26
comment Windows doesn't launch the application and all installed programs had .lnk extension
What is the output of entering the command assoc .exe?
Apr
24
comment Can I calculate a date using a date plus 53 days, minus any Sundays
@Shevek Then you would have to use a different formula. I just addressed the original question.
Apr
24
comment Can I calculate a date using a date plus 53 days, minus any Sundays
Do you mean ROUNDDOWN(53/7,0) instead of ROUNDDOWN(E7/7,0)?