Hello, looking for help with some of my work. Here is a description of the files.
Version: Office 365
There are just 9 columns in this order (Date, ID, Nose, Eye, Ear, Cough, Fecal, Navel, Joint). There are 22,289 rows of data.
Date is the date of observation
ID is a unique ID for the animal
The rest are scored on a scale of 0 to 5. The vast majority of the spreadsheet is 0's. These animals were checked 2x per week until they were moved. They were moved between week 10 and week 12, so some have more checks than others. I want to truncate all the data at 10 weeks which would be 20 checks for each animal.
How can I put in a formula so that I can sort by the first 20 checks, in order to remove the extra checks some animals had due to staying longer.
I'll be here all day trying to come up with an idea, if you need more info let me know, anything helps.
Bookmarks