I would like to learn how to enter data on excel faster. I have a large
datasheet, my samples are in "rows" while the tests are in "columns". The
samples are arranged in numerical order but when I'm testing them, I group
them into fixed groups of around 90-100 members. The members of these groups
are randomly arranged. I get my result one group at a time. And I conduct
different tests on each fixed group. I just score the test as normal or
abnormal.
For example, I'm testing test A on goup 1 which is a fixed group of 90
members and the result is normal for all, I have to go through my samples
numbered 001-900's to score each member of group 1 (randomly arranged) as
normal. I don't want to sort my samples according to the fixed groups because
I want to preserve the numerical order of the samples as much as possible. Is
there a way to enter my data faster without rearranging the samples?
Thanks.