Hi, I have a quik question bout Excel and any help would be fantastic.
OK I have a very large amout of data that I have collected for research in an Excel file. I have a number of columns all with values between 0 and 4. What I would like to do is count the number of times, for example. 0 appears in column A AND 3 appears in column C but only when they occur at the same time, not separately. I have looked through the help section of Excel and I can't find anything. Any help would be great, thanks.
Richard
OK I have a very large amout of data that I have collected for research in an Excel file. I have a number of columns all with values between 0 and 4. What I would like to do is count the number of times, for example. 0 appears in column A AND 3 appears in column C but only when they occur at the same time, not separately. I have looked through the help section of Excel and I can't find anything. Any help would be great, thanks.
Richard