Recent Questions

I run into a problem with my exteal HDD, i used it for backups but when i reinstalled windows (and forgot to remove the HDD) my HDD got whiped. After the whipe suddenly my HDD splitted itself into multiple Disks. Ive tried evrything and googles alot but no succes. I would like to bring it back to one disk, just like it was when i bought it. Can anyone help me out, or give me some tips on how to achieve this? Here is an image of the partitions, if you need any extra details of information let me ...

I am building a new desktop computer. I will be using 128GB of RAM. I know that is a lot, I am not interested in explaining why I need it. My question is how I should plan this out. I have 8 ports for RAM, Should I buy 8 16GB RAM sticks or one 128 GB stick. Other variances of 128 GB are also an option. However, I am basicly wanting to know if its better to spread it all out or consolidate. Thanks! Let's block ads! بخوانید...

I want to get with my ID the matching string, I am trying to accomplish that with a VLOOKUP =VLOOKUP(L2;Tree_Matchingnode!A:B;1;0) The Table that I am doing the Vlookup looks like this: +----------------+------------------+ | Parent_TREE_ID | Parent_TREE_NAME | +----------------+------------------+ | 1 | | | 2 | | | 3 | | +----------------+------------------+ The Matching tabel looks like this: +----...

Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ...

What is the best way to mass search html, epub, and pdf files? Windows explorer doesn't really support this properly. ...

I have an Nvidia 1070 and three monitors. Two are 1080p one is 1440p. I run Windows 10 x64. Say I have google chrome (it happens to other windowed apps) maximized on one of the side 1080p monitors. SOMETIMES when I lock the computer and come back to it later (after the screens have gone to sleep -- my computer never goes into sleep mode though), the window will have shifted from maximized position to 50% to the right and 50% down but still the same size so it's off the screen...It's not always i...

So I have been trying to add refrenced cells but each time I input the sum formula is get 0 as an answer. I did a search online and realised that I'm to use the indirect formula but I just cannot make head or tail of it. At best I am able to retrieve one number but my intention is not retrieval alone but adding the numbers in the refrenced cells. Any help will be greatly appreciated Oops I cannot post pictures at the moment but I hope the description of my headache will be understood from the th...

enter image description herecan anyone pls help. I hv a list with Column A to C, Row unknown depends on condition. Column B contains either "A" "B" "C" I would a VBA code to copy all data from column a - c when Column B is "A" to sheet 1 and to sheet 2 when column B is "B" and so on, I know its using the For i = 1 to .End(xlUp).Offset(0), but then what should I do, I tried but wasn't working at all for me. can any one pls help Let's block ads! بخوانید...

How can I share the same OneDrive for Business folder (same login) across multiple user accounts on a Windows machine? TL;DR One of my clients has a business where several Windows users need access to a shared set of files, which are currently shared on a file server on the network. Currently the Windows machines are connected to a domain run on SBS. But they want to get rid of the local server and move to the cloud, leaving the domain behind for good. They only have a handful of computers and s...

i use ncrack for windows Ncrack syntax,how to run multiple IP's and add threads and waiting time? I use this ordinary syntax with no threads and no waiting time and ncrack rate up to 40 ncrack -vv -d7 -U users.txt -P pass1.txt -iL ips.txt -p rdp Now i try to use few threads and time using this syntax, i add 5 threads and 700 ms,ncrack rate 40,the same that means no effect So my question is:how to add multiple IPs, 5 threads and 700 ms waiting time ncrack -v -d7 -U users.txt -P pass1.txt -iL ...

Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ...

I'm using FastMail & have a reseller account with which I hope to use one day to manage clients' email accounts. Each account will have 1 Inbox & will allow the creation of multiple aliases on their domain, all of which get delivered to the single inbox. FastMail has a rule-based filing system which will route messages addresses to an alias to a specific folder created to hold messages sent to each alias. However it's not possible to duplicate and copy messages sent to multiple aliases t...

I am combining multiple data sources that list employee names differently ("Last, First", "Fist Last", "Last First", etc.) into one workbook and thus one table. I want to avoid spending a lot of time manipulating the imported data. I want to use a formula that will tell me if someone's name is in the row (A) regardless of how the name is displayed. Below is a formula that I was using, however it does not guarantee that the first and last name are matched in the same cell/row. (yellow highlight a...

I am using a spreadsheet that contains constant data; I would like to be able to populate the cells on another spreadsheet with this data when a condition is true. I.e. The target spreadsheet is used to prepare estimates. When the user selects a predefined price quote from the spreadsheet containing the constant data, I would like to move this data to the Estimate Spreadsheet. Any assistance would be greatly appreciated. Jamie Let's block ads! بخوانید...

I have a list of data that I need to rearrange in a specific way in the next sheet. I want to make the data to automatically be inputted to the next sheet as below as the total data is actually a lot and it takes time to do this by transposing and copy pasting to the correct order. Is it possible to make the data be arranged as such automatically by functions/macros? Let's block ads! بخوانید...

Can someone please help me generate a list of people that hit their targets for different days, when they hit both of their targets a '2' will show in either the Y column or Z respective if they are early or late shift. i would like everyone that gets a 2 on their shift to be listed. Here is the Data Here is the outcome I am attempting Let's block ads! بخوانید...

I recently opened ~70+ Excel files all at one time (it was a massive data dump from a database which I was going to be locked out of in about 30 minutes, so I wanted to grab everything I could conceivably need). Unsurprisingly, my Excel crashed from the load. Upon restarting Excel, the Document Recovery pane opened and showed me all of the files. Is there a way to automatically have all the files in the Document Recovery Pane open up? I don't want to have to manually go through and open up 70+ d...

I have a table which contains multiple references per cell separated by a blank space. In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the component which is linked to each reference. Here is an example of my first table: And here is the result I'm trying to achieve: Use VLOOKUP of the reference to get the component name in the first table. I cannot get it to work as the number of references associated to a component is not constant. Let's ...

I am seeking help in working out a couple of excel formulas. I have included a snip of the data that I am working with and the outcome that I am seeking to streamline with the use of formulas. Ignoring column A. I want to copy the values from B & C but there are duplicate values in column B which I want to ignore, unless the value in column C is different for the value in column B. So I want to get the values across from B & C as per columns F & G). Then I want to sum the values fro...

I'm working on a VBA that pulls objects itemized in a spreadsheet in hopes of creating a mail merge that sends each attachment separately to the same email. The email group receives the emails but without the attachment. Can this be done? ...