vendredi 3 décembre 2021

Repeat Dates and Roles using Column Dates from (E to I)

I have some Data where, there are 8 columns. I want to keep Column, B,E,F,G,H and I.

In Column B I have Some positions and in other columns E,F,G,H and I i have dates. I want to convert the dates as 1 to count the Roles, to know that how many times the date is repeated in "Headers" for the "Roles".

I would really appreciate the help if it can be achieved using formula.

DATA

enter image description here

RESULT

enter image description here

Google Sheets Link

Aucun commentaire:

Enregistrer un commentaire