I got it wrong since A can combine with C in the same team. Back to the drawing borad, but this was the idea. I think a macro wiill have to be t...
First idea no macro's I used the filter function and the extra column 1 or 0 to select the odd or even rows. Needs more working out for the comb...
Okay, will see what I can do, do you prefer it to be without macro's?
Hi Andrew, I think I get the idea. Just a question, which version of Excel are you using? I'm asking this because of the use of the newest funct...
Hi, I haven't tried it but maybe it works like in Excel. You could trigger a macro that when you open the document it unprotects it and directl...
Hi, I've never used MEDIAN but what if you include an IF condition to check if the event occurs on a single day before you calculate the MEDIAN? ...
Hi, Maybe you understand what you're asking for; to mee it's entirely unclear Furthermore I advice you to also mention the Excel/Office bersion ...
Hi, I sugguest first that you attach a file with non private data file with the macros as you have it now and also tell us the Excel/Office version yo...
Hi, the only thing I know when adressing SharePoint links is that you may NOT use spaces but have to replace them with %20
Hi, thanks for the lik, I was aware of that one but that didn't solve it. I finally managed to go on location and noticed that all the other macro'...
The file opens allright but the connections are invalid for us, DataFormat.Error: 'CAR-NCMR.mdb' is not a valid path. Make sure that the path n...
Have you tried saving is as a binary file? xlsb is smaller than xlsm and retains all macro's
Just playing around with the cell contents, I don't like DIV/0 and NA in tables
Nice one Riny
Your logic: You want to keep track of every date until 120 days overdue, at least that's what you small table tells us. The overdue dats above 9...