Good day
If someone could be as kind as to assist with the following, I am tracking Personnel on Board (POB) on a daily basis. Column A to N has names, surnames etc... which one of the columns include company they work for (F).
Column O - EX has Dates (sequential). On each new day a 1 will be in the respective column where the name and date match.
I want to create a summary page where the argument will calculate the Company (F) Match with the column date if it is 1, and not if 0.The date moves one column every day.
Thank you in advance.
If someone could be as kind as to assist with the following, I am tracking Personnel on Board (POB) on a daily basis. Column A to N has names, surnames etc... which one of the columns include company they work for (F).
Column O - EX has Dates (sequential). On each new day a 1 will be in the respective column where the name and date match.
I want to create a summary page where the argument will calculate the Company (F) Match with the column date if it is 1, and not if 0.The date moves one column every day.
Thank you in advance.