Recent content by marcvanderpeet12

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