Hi, this is my first post to this forum.
I am compiling a database in Excel and would like some tips on how best to go about it.
Basically, the spreadsheet is as follows:
c. 100 rows of data, each row pertaining to one survey respondant.
The 100 respondants are split between 5 surveyors, who are responsible for inputting the survey responses
The survey consists of 15 Yes/No questions.
What I would like to do is have it so that each surveyor can only change answers for their own respondants- Is there a practical way to do this in Excel?
Also I would like to know if there is any way of entering Yes/No answers in cells that is more convenient/conducive to analysis/presentable?
Thanks you in advance and apologies for being such a novice.
Bookmarks