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: +-------------+----+ | Folder_PATH | ID | +-------------+----+ | Path1 | 1 | | Path3 | 9 | | Path15 | 3 | +-------------+----+ My result should be that the the ID's from the first tab...

I installed Gnucash on my Mac OS X El Capitan, but I'm having problems with titles and headings on the interface and reports. By following the advice on here https://wiki.gnucash.org/wiki/FAQ#Q:_How_get_I_rid_of_strange_unreadable_characters_or_adjust_the_font_size I've managed to get rid of the problem on the interface and the headings on reports, but the problem still affects the titles of reports (see image below). Instead of getting the title Income Statement for ..., etc, I get a long list of numbers. Income Statement Report Regarding advice below (from the Gnucash wiki page) MacOs: Create a plain text file in your home folder (~ is unix shorthand for your home folder): X Window version...

I would like to create a Regular Expression String that counts the number of characters in each line. If it's longer than say 10, 12 or 15 characters it would take the number of characters in the line and divide it by two. Next have it jump to the begiing of the word that starts before the half way point and select the space, then replace it with the "|" character at this spot. I've tried several things based on what I have found on this SuperUser Site but I'm fairly new to Regular Expressions and sort of clueless as to all the in's and out's to get this working. Example STRAIGHT FLUSH BEATS THREE OF A KIND. I WENT TO HIS HOUSE BUT HE WAS ALREADY DEAD. Would become. STRAIGHT FLUSH|BEATS THRE...

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

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

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 are the examples that are incorrect) Does anyone have any suggestions or ideas? Formula: =IFERROR(IF(MATCH(""&C3&"",$A$2:$A$6,0)>=0,IF(MATCH(""&D3&"",$A$2:$A$6,0)>=0,1,0)),0) Let...

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

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 caot get it to work as the number of references associated to a component is not constant. Let's block ads! بخوانید...

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

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

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. Is there a way I can "test" how my graph and data would look if I opened it in Excel 2007, without actually having it? I dont see .xls Let's block ads! بخوانید...

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 preventing it from showing date format? Anybody know why Excel does this? I have tried on a new sheet, but same result. Any help much appreciated :) Please see images below. Car Search Sheet Raw Data Sheet L...

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

My title needs some elaboration. I don't want the "single webpage" option, as that creates an mht file In Microsoft Word, and while Chrome can open it, I see the Firefox has issues Here's the file as a docx https://we.tl/XN4V8w6flT or from ge.tt http://ge.tt/8r0iFNd2 though that can easily be created just by having some text and highlighting part of it . And that's just a demonstration file, I may have lots more text and lots more blocks of text highlighted. I don't want an MHT file 'cos firefox doesn't open it straight away, and if I want to send it to somebody then I think an html file is more compatible. I can get Word to produce an html webpage but then it makes a subdirectory with the...

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

I need to read multiple excel files and load into target table using Informatica powercenter.Can anyone help on this. Regards, Venu.Ch ...

I have taken integers from 1 to 100 as my total population set. Now I generated 5 random numbers (using =randbetween() command) and called it my sample 1. Similarly, I created 200 such samples. Now I changed the number of data points in my sample and increased it to 10 in each sample and again created 200 new samples with sample size = 10. This thing I again did for sample size = 20. Now my problem is this - I have to plot them in such a maer that on my X-axis, I have Sample size = 5, sample size = 10, sample size = 20 as my 3 points and all the sample points corresponding to each sample size on the Y-axis (hence making 3 different clustered scatter plot in shape of straight line). But I am ...