Hi Azid, The excel file is not attached. When you have added it via Add Files, you must then press Start Upload. From what I understand, it shou...
Hi, Maurizio, Here is a solution on Foglio3 with VBA. BR, Lionel
Hi Chantal, The easiest way is to use a single line of code and mention the sheet concerned : Sheets("Sheet1").Range("A:C").EntireColumn.Hidden ...
Hi Bilal, This is a very good question but we don't have enough data to help you. Can you attach a file that explains the starting situation and th...
Hi, Pedro, I'm not sure I've grasped all the finer points of the reasoning. I suggest this solution based on a pivot table. In sheet_2, you have th...
Hi Arte Mis, For me, the file is not enough to understand exactly what the problem is. There is data but we don't know where it comes from or if it...
Hi Pedro, The file is not attached. When you click on Attachments, you can select your file via Add Files and then finalise the procedure by clicki...
Hi, In order to give the most precise answer possible, can you provide us with a file with the elements in your possession and the desired result? ...
Hi James, Here is the file with some adaptations (I give here the formulas in French because I am Belgian but they will adapt automatically when yo...
Hi, My first post was only an answer to the problem I was facing. Now that other questions have emerged, and as Mynda says very well, other answers...
Hi, You can add a condition, as in the attached file. BR, Lionel
Hi B Fig, Voici une solution en utilisant PowerQuery (in A22). BR, Lionel
Hi Murali, Here is a solution (without knowing which version of excel you are using). I added data for a GRADE 2 and a second sheet for the graph a...
Hi Kent, Indeed, it is a good solution to use SUMIF but you will have a problem because you have two identical 'tco' identifiers (line 15 and line ...
Hi Aarti, In the file, you will find a formula to get to the target. As far as the WORKDAY part is concerned, you can add your holidays (it's bette...