Recent Questions

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: +----...

I have a machine that has been damaged by some careless couriers, and want to replace the damage parts efficiently. I have limited opportunities to test components in other computers, so I'm trying to find out what is broken in other ways. I have two main issues: Graphical artifacts. These take the form of small grid-aligned squares which usually appear and then flicker form position to position. If the display driver doesn't crash, they often settle down to a final position, and sometimes the ...

In Windows 10 I already set up that both should be recorded But only my sound is recorded Here is a sample https://www.youtube.com/watch?v=Q-M1XbkQARo Sometimes only my sound shows up. Sometimes only the game sound shows up. ...

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! بخوانید...

When playing the currently playing song is not at the the top and the playlist is scrolled down to show some of the previously played songs. I'd rather see the upcoming songs than any of the previously played songs. How do I get it to show the currently playing song at the top of the currently viewed playlist at all times during playback. A representation of how I'd like the playlist to behave. Let's block ads! بخوانید...

I'm using Archlinux with my Xonar DSX.My problem happens when I want to use my headphones, I just open Pulseaudio, in the Configuration tab I select the profile for analog output and so far so good. My headphones are working perfectly. But if I want to change the volume, using Pulseaudio nothing seems to change, except for when I set volume to 0% (in this case it mutes the headphones). Using alsamixer from terminal I noticed that there are many volume columns (Master Front, Master Rear, Master C...

Recently started working as the tech support for a small company. Recently I leaed that they've all been experiencing graphical glitches with Microsoft Office that I think might be a symptom of larger issues. Has anyone ever seen a graphical error like this before and if so how was it resolved? Here's a video of the glitch: https://goo.gl/photos/E2oynsAXfNJMTaau9 It's affected both Office 2010 and 2013, other programs are affected at the same time, its not reproducible as far as I've been able t...

I am interested to find a possibility to change the color of the progress bar in Windows 10 (Anniversary). I've tried this solution but there are some limitations, in the taskbar, the progress color is still green. How can I change the color of the progress bar? Let's block ads! بخوانید...

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? ...

Sometimes my mouse accidentally moves too low, and gets over the taskbar while I am trying to scroll, which results in the active window being replaced by the next one, i.e. the next window pops up and covers my focal one. Note, that I'm not talking about scrolling among icons in a crowded taskbar that only show a fraction of windows (as can be seen in this image), neither about this issue, but about the fact that when I move my mouse wheel while being over the taskbar the next window will pop u...

windows 10 x64 pro, Asus z170p, BIOS version old. AMD graphics card. As you all are facing, I am facing the beta graphics driver-secure boot problem after windows 10 anniversary update, seems like microsoft hates non-WHQL drivers and I can't properly install beta drivers in windows 10 anymore. So I need to disable secure boot. But I can not disable secure boot from BIOS, the option is grayed out in BIOS. I even tried Windows->Settings Menu-> Update->Advance Startup->Troubleshoot->...

Currently I was making some graphs and manipulating some data. It looks pretty good so far. Problem is : I left my work computer at work, and need to have some graphs tommorow. The work computers generally all have Excel 2007. I was having some problems earlier today making the graph on my work computer and got home and dabbled around and finally got my desired graph. Now I'm not sure whether or not this is because Excel 2016 optimizes some things better, or I just formatted my data much better....