Search results

Dear all, I have the following Excel. In Sheet1C2 I try to perform a hlookup function to fetch data from the source-data tab. But for some reason this is not working. ANy thoughts on what goes wrong?

Dear all, Cell C2 in the sheet shows an error I have tried various things (make sure it's selected as text and contr + "``" but that does not work. Any tips on what I can do? I have included the relevant sheet.

Dear all, I have the following Excel sheet. In sheet1:C3:C10 I have the following formula =VLOOKUP(B3;Sheet2!$B$2:$C$10;2;TRUE) For some reason, however, the sheet returns strange values. Any thoughts on what goes wrong?

Dear all, I have the following Excel. C5 marks the starttime, C7 the endtime and C6 the number of minutes of a break. I would like to take the total amount of hours (C7-C5) and subtract the number of minutes (so in this example 7h and 10 min). But doing C7-C5-C6 does not work. Any thoughts...

Dear all, I have the following sheet. I expect DashboardC4 to give me the value: 309,92 but it throws an error. Any thoughts on what goes wrong here?

Dear all, I have a .csv in a folder: P:\Projects\PROJECTEN (cl] Continue\Continue\Finance\Verwerken\ that is called: 2023-07-19-08-40-50-bunq-transactieoverzicht.csv Loading the folder like this works: Set Wb1 = Workbooks.Open("P:\Projects\PROJECTEN (cl]...

Dear all, I have the following VBA code. -- >>> use code - tags <<< Sub load_excel() Dim Wb1 As Workbook 'Dont update the screen - makes it work faster Application.ScreenUpdating = False 'Open the other workbook 'Input the FULL path to the file, including its extension 'Grab the...

Dear all, I have the following Excel. In sheet BE in formatted the sections C68:N78 as number (with two digits). However, the data keeps showing more than 2 digits. Any thoughts on what goes wrong here...

Dear all, I have the following Excel sheet. In the tab "BE" there's an area that is using conditional formatting (fe, section C68: N78). I would like to try different ranges for conditional formatting. So ideally I want to be able to fill in data in the range Q68 to S 74 after which different...

Dear all, I have a case where I need an count if statement that performs a count when criteria a and b is met. In the attached example I would like to perform a count IF the column A is "apple" or "apples". Any feedback on how I should do this? kr, Marc

Dear all, I am looking for an sumif formula that takes into account multiple values. So in the case of the attachment - how can I write an sumif statement that count the cases where the condition apple and cheap is met?

Dear all, I am using a DBCount formula that counts the instances in a certain range. See my example sheet. This works, however I am looking for a formula that counts the instances that are either one of two instances (fe, "oranges" and "bananas"). Could you anybody help me with how to do this...

Dear all, I have a dataset that looks like the tab: data (I now provided 34 rows of data but the actual dataset is a lot bigger). From this dataset, I would like to create an overview like example_output. I tried to accomplish this via database sum formulas. The problem however though is that...

Dear all, I am looking for a way to store the paste special functionality in a macro. Lets say I have the following situation: - I create a graph in a powerpoint - I adjust the lines and colours and add a title. Now I would like to store exactly these formats in a macro. So I can just select...

I wrote the following code which aligns all the textboxes that I have selected to the right. Sub alignFunction(direction) Dim oSel As ShapeRange Set oSel = ActiveWindow.Selection.ShapeRange With oSel .TextFrame.TextRange.Paragraphs.ParagraphFormat.Alignment = direction End With End Sub...

Dear all, I have the following powerpoint (see attachment). Running the following code gives me a single bar chart. Sub function_line_title() Set myChart = ActivePresentation.Slides(1).Shapes(1).Chart With myChart .HasTitle = False .SeriesCollection(1).Delete...

I have code that creates a map of the US in powerpoint. Sub ArrayLoop(array1, array2, amountOfLine) Dim i AsLongFor i =0To amountOfLineWith ActivePresentation.Slides(1).Shapes.AddLine(BeginX:=array1(i), BeginY:=array2(i), EndX:=array1(i +1), EndY:=array2(i +1)).Line.DashStyle =...

Dear all, I have a powerpoint with a shape on it. I already wrote code in powerpoint VBA so it prints out all the "editable" points of the shape. You can reproduce that by copying the figure from the excel sheet into a powerpoint and run the following code (cant upload ppt files) Sub test()...

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

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

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?