Recent content by brems

Hi chirayu, Khalid and Badale, Thank you very much for the offered solutions. They sure meet my requirement and the offered solutions are very inspirational on approaching and solving Excel challenges! Thanks again. Brems

Hi, I have a file with some hard-coded conditional formatting. I attached an example. The conditions for formatting the cells are hard-coded in the conditional formatting itself but I want to have the possibility to have the conditions refer to the cells C2, C3 and C4. I know this is possible...

Hi Jon, Thank you very much for the link. I'll try this later this day and I'll keep you posted. Have a nice day! Wim

Hello, I may be posting it in the wrong place but I don't know if it can be done without a macro. I have an excel sheet (input) where the user has to complete some fields. On the sheet there is a button to transmit the entered data to another sheet. Let's call this sheet MainSheet. The...

I have an additional question. I'm trying to understand the used formula but at the moment it's still to abstract. Can you point me to some recommended reading? Especially the use of ROW isn't very clear. Thanks!

Hi Debraj, Unfortunately I can one click 'like' once. ;)) Fortunately this is EXACTLY what I was looking for. Thank you very much!! Wim

Hi, I'm trying to find a solution for a simple challenge (aka problem). In a chart I'm displaying 8 quarters of data. (2014 en 2015) As soon as the first quarter of 2016 starts the oldest value (2014 Q1) must be omitted and the new value (2016 Q1) must be added. Each start of a new quarter...

Hi Sajan and shrivallabha, Thanks a lot for sharing this solution. Works perfect! :) I learned again...

Hi all, It may already be treated on the forum but I didn't find it. Nor did I find an applicable solution for this problem on the internet. I want to find the 7 most recent dates in a table but each date is listed more then once. I already succeeded in filtering unique dates but these are...

Hi r1c1, Works EXCELLENT! It's just great.:) Thank you very much. Wim

Hi dan_I, Can you explain your question a bit more please?

sorry, password is: vakpla damn, and it ain't monday... o_O I'm not at all expecting a complete solution. Just a hint to get me started again would be great. :)

Allright... I think it's ready. :) sheet 'db afdelingen' is the dashboard. Some results don't display correct anymore due to the changes. sheet 'db AM' is the sheet where you can specify the 6 criteria and the date range. I want to create a similar dashboard like the sheet 'db afdelingen'...

I'll do that Smallman. Thanks!

Hello, I'm writing a bit more of the explanation because I don't (yet) have an example to add. And my boss wouldn't be very happy when throwing the original data on the internet. ;) I have an excel sheet with a table in and I made a dashboard where the user can define 3 criteria by means of a...