Hi thenewbee, Here is the correction according to my understanding. 😉 BR, Lionel
Hi thenewbee, From what I understand, this is what I propose. 1. You load your data in PwQ (t_source). 2. You duplicate this array and name it t...
Hi Catalin Bombea, Thanks for the reply which led me to a solution that seems to work. I have created a function to retrieve all the PDFs in my ...
Hi Ridwan Ar, I think that we are missing an essential piece of information: how leave and sick days are allocated. 22 days of leave, I suppose, is...
Hi Loren, Thanks for asking this question. In order to be able to answer as precisely as possible (and as easily as possible), could you upload a f...
Hi Saliha, To retrieve your data, I suggest you use INDEX + MATCH with two criteria (which you will combine with '&'). The formula is in cells ...
Hi Yvonne, Can you attach your file so that it is easier to answer your question? BR, Lionel
Hi Riny. Thank you for this proposal. I actually prefer my presentation as I have to do some more processing afterwards. But your proposal will ...
Hi Gogol D, I suggest a solution with Power Query and structured tables. This way, if you add or delete data, Excel calculates for you. BR, L...
Hi David, Do the examples refer to structured tables? Maybe that's why you have @. See : Using structured references with Excel tables BR, ...
Hi lea, Here is your file with conditional formatting. See : Use conditional formatting to highlight information BR, Lionel
Hi M K, What do you mean 'it doesn't work'? You don't get the result you want? You have an error message? Here is an example on the sheet 'Sheet...
Hi Annalisa Loh, I suggest you work with Power Query. The first step is to import your data into Power Query Then you separate your data to g...