I have coded activities as 1, 2, 3 etc.
I am trying to find how often a person completes a "1" activity before a "3" activity. I'd like to identify where these patterns are on the spreadsheet and get a total count of how many times it happens.
I have attached a sample spreadsheet.
Is there an easy way to do this? I don't really understand macros (but from what I've gathered they may be my answer) but am willing to try to learn if there is any reading material that is somewhat basic/doesn't require extensive knowledge to understand?
thank you!
Bookmarks