Search results

Dear all, I have the following Excel sheet. The tab: "MatchMessenger.matches per day" contains data that I refresh. The aim of the tab: "Sheet 1" is to get an overview of the number of times a club has been mentioned on a rule in the datatab. So the cel "G2" gives 4 which mean that the name...

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?

Awesome, thanks.

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

Awesome, this is exactly what I am looking for. Thanks!

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

You are a ninja! Thanks!! One small additional question ... You know how to include a background to the map? Grey for example...

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

Works! Thanks a lot!

Good one SirJB7. See the file attached! Any thoughts?

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

Totally works guys. Thanks!