Forum Discussion
nunomiguelneto
Oct 10, 2020Copper Contributor
How to make a cell count just 1 number if there is 2 or 1?
Hello everyone, I work with disabled people and in this project we do a lot of different activities, so things you need to know to help me if you can. - We do 2 Activities per day. - There are 2 f...
SergeiBaklan
Oct 10, 2020Diamond Contributor
From your screenshot it's not clear where are days and where are attendances, and how you received 1 in Z and AA on first screenshot. It's better to submit sample file with formulas you use now and manually added desired result.
- nunomiguelnetoOct 12, 2020Copper Contributor
SergeiBaklan Hello Sergei, thank you so much, here is the sample file
- SergeiBaklanOct 12, 2020Diamond Contributor
Thank you for the file, it's more clear now.
Perhaps here
it'll be simply maximum of two, please check attached.
- nunomiguelnetoOct 12, 2020Copper Contributor
SergeiBaklan Thank you so much Sergei... it was basic... sometimes the answer is right under my nose and I cannot find it.