Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel problem N. A B C D E F G H I 1 Sort the following table so that the fields are grouped by Layer
Excel problem
N. A B C D E F G H I 1 Sort the following table so that the fields are grouped by Layer first then by Name then by Time. 2 All the records should be grouped by layer. Within each layer the records should be in name order. Within each well name, the records should be in time order. 4 5 Name 6 W2 7 W2 8 W2 9 W2 10 W2 11 W2 12 W2 13 W2 14 W2 15 W2 16 W2 17 W2 18 W2 19 W2 20 W2 21 W2 22 W2 23 W2 24 W2 25 W2 26 W2 27 W2 28 W2 29 W2 30 W2 31 W2 Time X Y 7:18:24 AM 796072.9 980540.7 7:30:48 AM 796072.9 980540.7 7:42:00 AM 796072.9 980540.7 7:54:24 AM 796072.9 980540.7 8:06:24 AM 796072.9 980540.7 8:18:48 AM 796072.9 980540.7 8:30:48 AM 796072.9 980540.7 8:43:12 AM 796072.9 980540.7 8:55:36 AM 796072.9 980540.7 9:07:36 AM 796072.9 980540.7 9:20:00 AM 796072.9 980540.7 9:32:00 AM 796072.9 980540.7 9:44:24 AM 796072.9 980540.7 9:56:48 AM 796072.9 980540.7 10:08:24 AM 796072.9 980540.7 10:20:48 AM 796072.9 980540.7 10:32:48 AM 796072.9 980540.7 10:45:12 AM 796072.9 980540.7 10:57:12 AM 796072.9 980540.7 11:09:36 AM 796072.9 980540.7 11:22:00 AM 796072.9 980540.7 11:34:00 AM 796072.9 980540.7 11:46:24 AM 796072.9 980540.7 11:58:24 AM 796072.9 980540.7 12:10:48 PM 796072.9 980540.7 12:23:12 PM 796072.9 980540.7 Layer Observed 68.36 67.65 67.99 68.39 67.66 68.13 67.29 67.84 67.97 67.48 67.61 67.61 67.88 67.7 67.51 67.62 68.04 67.6 67.27 67.6 67.37 68.01 67.51 1 67.53 68.13 67.6 N. A B C D E F G H I 1 Sort the following table so that the fields are grouped by Layer first then by Name then by Time. 2 All the records should be grouped by layer. Within each layer the records should be in name order. Within each well name, the records should be in time order. 4 5 Name 6 W2 7 W2 8 W2 9 W2 10 W2 11 W2 12 W2 13 W2 14 W2 15 W2 16 W2 17 W2 18 W2 19 W2 20 W2 21 W2 22 W2 23 W2 24 W2 25 W2 26 W2 27 W2 28 W2 29 W2 30 W2 31 W2 Time X Y 7:18:24 AM 796072.9 980540.7 7:30:48 AM 796072.9 980540.7 7:42:00 AM 796072.9 980540.7 7:54:24 AM 796072.9 980540.7 8:06:24 AM 796072.9 980540.7 8:18:48 AM 796072.9 980540.7 8:30:48 AM 796072.9 980540.7 8:43:12 AM 796072.9 980540.7 8:55:36 AM 796072.9 980540.7 9:07:36 AM 796072.9 980540.7 9:20:00 AM 796072.9 980540.7 9:32:00 AM 796072.9 980540.7 9:44:24 AM 796072.9 980540.7 9:56:48 AM 796072.9 980540.7 10:08:24 AM 796072.9 980540.7 10:20:48 AM 796072.9 980540.7 10:32:48 AM 796072.9 980540.7 10:45:12 AM 796072.9 980540.7 10:57:12 AM 796072.9 980540.7 11:09:36 AM 796072.9 980540.7 11:22:00 AM 796072.9 980540.7 11:34:00 AM 796072.9 980540.7 11:46:24 AM 796072.9 980540.7 11:58:24 AM 796072.9 980540.7 12:10:48 PM 796072.9 980540.7 12:23:12 PM 796072.9 980540.7 Layer Observed 68.36 67.65 67.99 68.39 67.66 68.13 67.29 67.84 67.97 67.48 67.61 67.61 67.88 67.7 67.51 67.62 68.04 67.6 67.27 67.6 67.37 68.01 67.51 1 67.53 68.13 67.6Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started