Recent Questions

The entire BlueGriffon Tutorial has been updated for the version 3 series of BlueGriffon. Those thinking of using it to create a website can find the complete series online., ...ادامه مطلب

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: +-------------+----+ | Folder_PATH | ID | +-------------+----+ | Path1 | 1 | | Path3 | 9 | | Path15 | 3 | +-------------+----+ My result should be that the the ID's from the first table match the correct path coming from the second table Let's block ads! بخوانید,excel vlookup find string ...ادامه مطلب

Used this AMI ami-b7418dd7 followed this guide: https://docs.openvpn.net/how-to-tutorialsguides/virtual-platforms/amazon-ec2-appliance-ami-quick-start-guide/ Now, when a user connects to the VPN I want all of their normal inteet traffic to go through the public inteet, but when they are trying to access one of our inteal systems I want that traffic to go through the VPN. How? I've seen a lot of other answers, and I've found very few of them helpful. On this official AMI from openvpn, I can't find any server.conf or client.conf files that so many answers seem to point toward. Any help appreciated, this is the single stupidest task to be given as a software engineer, not an IT / systems-administrator. Let's block ads! بخوانید, ...ادامه مطلب

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 provide a way to FIND the run keyword for any software. Maybe there is a way to see it through task manager ? Through cmd maybe ? There should be a way ! Ideally, I would love to have a solution that doesn't need the installation of any extra software for this. Thanks in advance, George Let's block ads! بخوانید,how to find pokemon in pokemon go,how to find pokemon,how to find the area of a circle,how to find standard deviation,how to find slope,how to find the area of a triangle,how to find nearby pokemon,how to find ip address,how to find area,how to find percentage ...ادامه مطلب

I hope this is the right place to ask this. My University lets students download a preconfigured executable of OpenVPN, where the settings are already branded in. Once you installed it, you just enter your credentials and you are connected. However, I noticed that it doesn't work anymore after the system is has been installed on is rebooted. If I install it, I get a successful connection with the VPN and can use it. If I restart my Laptop, it does not work anymore, but the Icons in the Tray still show a green screen. If I then uninstall it and reinstall it, without rebooting, it works again. The only difference in the log window when it's connecting, I notice when it does not work, one of the lines would say "Failed ARP Flash on Interface" or something like this, when it works this exact same line says "Successful ARP Flush on Interface". I'm running Windows 10, this has been a problem since Windows 8.1 though. Any ideas on how to fix that? I've tried both the x64 and x86 installers my,openvpn only ping works,openvpn only google works ...ادامه مطلب

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 three points below: In I2, sum A2:D2 In J2, sum lowest 2 numbers in E2:H2 In K2, sum I2 and J2 Please note that the values in A2 to H2 are referenced from another sheet. Thanks in advance. Let's block ads! بخوانید, ...ادامه مطلب

I spend two days trying to compile my code with header as cross compiler for OpenWrt I am using LinksysWRT54GL, and mipsel architecture. I download the libpcap from OpenWrt and tried to generate the MakeFile using ./configure --prefix=$TOOLCHAIN --build=mipsel-openwrt-linux-gnu --host=mipsel-openwrt-linux-uclibc --with-pcap=null and I got this error when I ran make pcap-usb-linux.o: could not read symbols: File in wrong format collect2: ld retued 1 exit status make: *** [libpcap.so] Error 1 Thans for all Let's block ads! بخوانید, ...ادامه مطلب

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! بخوانید,onenote 2013 keyboard shortcuts,onenote 2013 keyboard shortcuts pdf,change onenote 2013 keyboard shortcuts,onenote 2013 customize keyboard shortcuts,onenote 2013 create keyboard shortcuts ...ادامه مطلب

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! بخوانید,rearrange rows in excel,rearrange rows in r,rearrange rows in pivot table,rearrange rows in matlab,rearrange rows in datatable c#,rearrange rows into columns excel,rearrange rows in access,rearrange rows in word,rearrange rows in sql,rearrange rows in uitableview ...ادامه مطلب

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! بخوانید,excel create a drop down list,excel create a chart,excel create a report,excel create array,excel create a table,excel create a macro,excel create array from range,excel create a named range,excel create a custom list,excel create a function ...ادامه مطلب

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+ documents by hand. I've tried looking around the Inteet, but it looks like most tutorials only talk about the Document Pane itself, not this specific question. Let's block ads! بخوانید,excel 2013 opens blank,excel 2013 opens minimized,excel 2013 open and repair,excel 2013 opens 2 windows,excel 2013 open in same window,excel 2013 opens grey screen,excel 2013 open read only,excel 2013 open blank workbook,excel 2013 open multiple instances,excel 2013 open blank workbook by default ...ادامه مطلب

I have a Dell Inspiron 15 laptop with factory-installed Windows 8, upgraded to Windows 8.1, and later to Windows 10. Since I have purchased a new computer, I decided to perform a factory reset on the laptop (using the Remove files and clean the drive option) in order to repurpose it. It reset flawlessly on the first try in about 5-6 hours, and runs perfectly now, but with only one issue introduced after the reset that wasn't present before: the laptop now powers itself on from a shut-down state upon opening the lid, as opposed to opening the lid and then pressing the power button (this occurs on both battery and power). To add on to that, there was even an instance where the lid was already open and the laptop was completely shut down, and opening the lid just a little bit more tued the laptop back on too! Very strange, but this hasn't happened more than once yet. I've tried tuing of,dell laptop powering off,dell laptop not powering on,dell laptop not powering off,dell laptop keeps powering down,dell studio laptop not powering on,dell inspiron laptop not powering up,dell inspiron laptop not powering on,dell xps laptop not powering on,my dell laptop not powering up ...ادامه مطلب

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 block ads! بخوانید,excel vlookup with text,excel vlookup with multiple results,excel vlookup with if,excel vlookup with multiple conditions,excel vlookup with wildcard,excel vlookup with match,excel vlookup with dates,excel vlookup with two criteria,excel vlookup with multiple values,excel vlookup with tables ...ادامه مطلب

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 from D, to be as per column H. Hopefully you can decipher what I am after and provide some suggestions for how to tackle this. General info: Windows 10, Excel 2016 Let's block ads! بخوانید,goal seek excel formulas ...ادامه مطلب