Search results

Dear all, I have the following use case: - I have a dataset that I would like to filter based on value (the value I H2 is my example). Therefore I am using the dbsum formula and a query. One value in the query is customizable so you can quickly get a sum of the different variables. Attached...

I have the following list. For this list I need to put all distances between clubs. I can just fill it in one by one but then Ill do a lot of double work. Cause when Ive looked up the distance of Aston Villa to Arsenal I do not have to search for the distance of Arsenal to Aston Villa. As it's...

My apologies, i appreciated the effort! My bet

@NARAYANK991 Sorry for duplicating but I thought this is about something else. Thing is that I think the multiple conditions are not working. Check out this screenshot: I used an advanced filter which should fetch the values with instrumentalness BETWEEN 0,04 AND 0,44 but when I see the results...

Guys, I have the following condition for an advanced filter (zie Screenshot attachted). I does not seem to work however. The record on row 7 has a value of 0,03198 which is NOT between 0,63 and 0,73. Any thought on why this filter is not working fine? File is uploaded as well. Cheers, Marc...

Thanks for your feedback guys, gonna try it out tomorrow and will let you know what works!

Guys, I wrote the following VBA code to automate an advanced filter. Sub Macro1() Sheets("Nummers").Range("B2:H5817").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range("B2:H4"), CopyToRange:=Range("B6:H6"), Unique:=False End Sub When I hit it I do not...

Guys, I have the following Excel sheet (see attached). In the tab "Overzicht" I have the following formula in cell D11: "=DSUM(Datum_afschrift_26aug!A1:I200;Datum_afschrift_26aug!E1;'query''s'!C14:J15)" This should give me a sum of all values in "Datum_afschrift_26aug" fitting the query I...

Guys, Im using the attached Excel file. Because I would like to read my file into R I want to replace my "," values in column G into ".". However, when I select everything and do replace all with ",", "." Excel sometimes translates 1,11 into 11.11. See for example record 370. Doe anybody know...

Guys, Im using the WEEKNUM function to transfer a date to a weeknum. In cell A2 I have a data ("29-12-2007") but when I enter =WEEKNUM(A2, 1) in in B2 i get "22-02-1900" instead of the weeknumber. A Any thoughts what goes wrong here?

Im sorry for the confusion. Anyway I think im one step closer to the solution. A .csv file which does not cause any issues is structured like this when I open it in notepad: address,direction,street,crossStreet,intersection,Location 1 "S CATON AVE & BENSON AVE,N/B,Caton Ave,Benson Ave,Caton...

[ I know but I just want to know why the excel file I attached cannot be transformed into a .csv.... Any thoughts on that? quote="marcvanderpeet12, post: 145280, member: 3093"]Guys, I have an excel document which I would like to transform into a .csv file. When I save I as an .csv file it...

Guys, I have an excel document which I would like to transform into a .csv file. When I save I as an .csv file it does not give me a csv file however. I included two screenshots -> csv_right shows how I want i come out and csv_wrong it what i get. I also included the relevant excel file which...

Guys, Im using Microsoft office professional plus 2013 and want to add a trendline to my graph. Googling showed me I could do this by using the layout tab (which should appear when I click the graph). However when I click the graph I only get "design" and "format" under chart tools. Any...

Sweet, thanks!

Guys, I have a problem with the attached excel file. If im filtering on column "H" and tried to sort my date from a-z the first records go well. But if you scroll down to row 423 you will see that the sorting is not accurate anymore... Does anybody know this problem and has a solution for...

Sweet, thanks guys, this was exactly what I was looking for!

Guys, I have certain data with which I created a graph -> see my attached excel file Nothing fancy here. Thing is that I would like to change the colors of the graph bars depending the percentage. So when the percentage is within range 25-35% is must be red, when between 35-50% it must be...

I uploaded the file. It's about all the values in column G. I want to get rid of all the " - " before the texts...

Guys, I want to use a =Right() function on some text to extract the text from a word. All words are written like this " - Bank" and I want to transfer that to just "Bank". This can obviously be done by a simple =right(a2;4) function but problem is that the bank values differ. I also have -...

Thats what I thought as well but I didnt manage to do it. Im using excel 2003, might that be the case? I attached the sheet. The relevant sheet is "Procespers. DLT"

Guys, I have a table which let me automatically insert a new record. Only thing is that when I go to the final row of my table I have a formula in it (see: http://www.flickr.com/photos/112983354@N05/12769914184/) But when I scroll down that formula is gone and I have to drag the formula from a...

Thanks Debraj!

Dear all, I want to create a macro which does the following: - Select A5: U5 - Select all rows down (control, shift down) - Copy Problem is however that i cant to this because I copied an if statement till row 300 (the data in the tab is filtered from another tab which can contain 25 - 300...

Dear all, I got the following VBA code whick opens a folders, checks whether a file is there and then export an excel file from access in the map. All works fine except that the macro does not work if there's no file in the map. Does anybody know how I can enhance code below so it - checks...