Search results

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

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

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

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

Hi, I'm using the following code to merge all worksheets of the two workbooks to one new workbook. The formulas in the new document still link to the previous (unmerged) documents. Is there a way this can be solved by adding some code? The formula links must link to the data in the new...

Hello to all, I want to count a certain value on different tabs. Therefor I started to determine to the range within the formula needs to look. Starting point was determined with the formulas MATCH and ADDRESS. This resulted in cel B6 as the starting point of my range. Then I worked the same...

Hello to all, I'm using an INDIRECT formule to refer to a cell reference in another tab. When the name of the tab is 1 word (example: table1), there is no problem at all. I get the specific cell content from the tab with name table1. The problem arises when the name consists of more then one...

Hi, On a daily basis I'm putting in some data in an excel sheet. I've made an example file to clarify... We have 10 categories For each category there's an amount of emails that comes in daily: IN For each category there's an amout of emails that gets processed daily: OUT And of course...

Hi, I want to calculate the weighted average pricing of each category and therefore I use SumProduct but instead of selecting the cells for each category I want to use SumIfs together with SumProduct to do it for me. It would be more correct and much quicker. Below is an example of the data...