Apply locked for editing
We currently use an excel spreadsheet which requires input by different users within the department. I know there is a facility you can activate which displays a pop up message box stating another user is currently 'in' the spreadsheet and it can be accessed via a read-only action....but, I can't seem to find information on how to put it into action. I am probably typing in the wrong HELP question?
Excel Countifs
In excel I would like to count the number of measurements in column G if the condition in column C is fulfilled. Problem is that in column C I have three different conditions which should be considered; such as. count G1:G600 if C1:C600=cond1 or cond2 or cond3 I hope I was clear enough. Thanks for your help.
