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

Nowadays in my classroom I show video tutorials that I made for my students related to CG-apps, Excel, etc. using a utility that shows keyboard and mouse combinations named Moukey. for some cases like on a projector in the classroom it doesn't detect my Windows 10 and I don't want to call the technician. Also, I mostly like using OSX (of my dual boot MAC), sometimes and I'm looking for an OSX El Capitan version of this Key and Mouse Stroke Displayer. In conclusion, I'm looking for an OSX Version...

I am using Windows 10 (well, the version is irrelevant I believe) and I would like to execute my programs through 'Run' just for convenience. My problem is, where do I look for each software's Run keyword ? For example, to open paint, you can run 'mspaint', to open Notepad++ I luckily figured out you can run notepad++ but what about other processes ? For example, I have no clue how to open Sublime text 3 with Run or paint.net and many other software. If you are willing to help, please also provi...

Sometimes I get flicker on my screen. It only happens, when I wake my computer from sleep. I can't do anything and is left with no other option than to restart, or tu off my computer, as it persist. I have uploaded a short video, which shows my problem. Please pay attention to the monitor to the right, as it is the one which flickers: https://drive.google.com/file/d/0B0HPr-SgDU4tY0t3aVZ1WTFBbWc/view?usp=sharing I have recently made a fresh re-installation of windows 10, and have already installe...

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

In OneNote 2013, let's say you're currently editing some text in a regular text box/field: Now I want to exit this text box and move the cursor somewhere else on the page. Pressing Escape doesn't work, neither do the usual suspects (Ctrl+Enter, Alt+Enter, etc.). Can I exit the box with a keyboard shortcut of some kind? I have looked at the official page for OneNote 2013 keyboard shortcuts to no avail. Let's block ads! بخوانید...

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

Hi on a dell latitude laptop with Windows 10, for a specific user account keyboard doesn't work after the login screen. But it starts working back only when we launch on-screen keyboard application. And it also continues to work even after we close the on-screen keyboard. So far we've tried to uninsall keyboard driver but this didn't solve our problem. And nothing suspicious on system start. Any help is appreciated. Let's block ads! بخوانید...

today i tried to install openSUSE Leap 42.1 on a SD-card. I used a USB stick as installation medium. So far everything has gone well. The installation finished without any problems. Then I went to the Bios to select the SD-card as Boot Option #1. But I couldn't find the SD-card there! What do I have to change in order to make the SD-card appear in the BIOS? Thanks for your help! Let's block ads! بخوانید...

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

I am using a INDEX, MATCH function in sheet Car Search to pull data from sheet Raw Data. One of the cells is Date Purchased, this will show the date in format dd/mm/yyyy (UK Format). The problem is, when I enter a date in this format, it doesn't correctly pull over to the Car Search sheet. Instead, it shows up 42350 when I entered 12/12/2015 in the Raw Data sheet. Both cells have been formatted to Date, but it is still showing up as 42350 and not 12/12/2015. Is it because the function is prevent...

Trying to make changes on one worksheet to another. the 1st sheet is where I want to show the changes, the other sheets is where I make the changes ...

On my iPhone, there is an app for Google Inbox, where I can swipe messages left or right to archive them or snooze them. Is there a way to get the web version to do the same thing on a touchscreen computer? If it helps, I'm currently using Google Chrome on a Microsoft Surface Pro 4, but I expect that this would be applicable to any touchscreen laptop / tablet running Windows 10. Let's block ads! بخوانید...

I create a daily chart as this. As you can see, the data is hourly and the chart is daily. The bar is sum of all data in given day. How to make the chart so display average of the data in given day? ...