Forum Discussion
Countifs done in multiples
Hello, We are new to this community, but not without experience in excel. Our club has recently done a survey of our members, and we are trying to find when people are available and which of ...
I was using the asterisks at the end of the day of the week, as you see in the photo, but I didn't think to put the asterisk at the front of the word as well. Thanks!
Good solution by Ferran RodrÃguez. Simple and fits with Medieval Club UBCO existing knowledge.
Another option is a combination of Power Query and Pivot Table (if you have Excel 2010 - 2016 that is)
I realise this is no where as near as straightforward as Ferran's excellent fix, but I thought I'd share it anyway. It also avoids the risk of spelling mistakes not being picked up e.g. Satuday