Search results

Ok, thank you very much.

So it was a small detail in the end. Thank you very much. Could I ask you what "...{1;1;1;1;1;1;1;1;1}))>0);1;0)) ..." does in the formula? Is it related to columns in the data? Eoin

Of course. Whenever you have time. I'll be back in work on Monday.

Thanks Narayan. I cannot replicate the formula from last year's file. The only thing that occurs to me is that there is a problem in the MMULT part of the formula but since it works in the "Copia...." file, I have no clue of how to fix it in the new file "Inspectors and Inspections 4". The link...

Dear Narayan, Last year you very kindly resolved a problem for me. I am looking at the data again and made some changes and unfortunately messed up the formula. Do you by any chance have the same Excel file? The Dropbox link shows as closed.

Dear Narayan, This looks excellent. Regardless, I am very grateful. Sincere thanks for taking the time and effort. Best wishes, Eoin

Thanks for taking the time to answer but I'm afraid it didn't work for me. I've lined up my ranges with the data labels you used but I don't understand all of the COUNTIFS function. I get the following: Range of Dates; more than the Cut-off date; Range of Participants; Specific participant; But...

Problem - I have 2 COUNTIF functions that work but I cannot combine them into a COUNTIFS function based on the same data. I have a list of events with the participants. Participants can take part in more than one event. I want to count how many events someone has participated in since a given...